Problem Populating The DDL History Table For Golden Gate V188.8.131.52 For DB2 12.1 Z/OS
(Doc ID 2616680.1)
Last updated on MAY 11, 2022
Applies to:Oracle GoldenGate - Version 184.108.40.206.3 to 220.127.116.11.3 [Release 12.3]
I have created the Golden Gate V18.104.22.168 history table in Db2 for Zos using the scripts SQL provided. When I run the first insert query to populate the DDL_HIST_NEW table the Insert fails with message : SQLCODE = -407, ERROR: AN UPDATE, INSERT, OR SET VALUE IS NULL, BUT THE OBJECT COLUMN CANNOT CONTAIN NULL VALUES.
I have selected the data using DSNTEP2 in a job and data is selected but in reviewing that data I see that the column C.DEFAULTVALUE from SYSIBM.SYSCOLUMNS has null values in some of the rows.
I will attach 2 jobs, one which is the failing insert and one that just issues the select statement for the data that the failing query is trying to insert.
Please advise on how I should address this issue so the DDL history table can be successfully populated.
I have extracted the SQL from the script ddl_update.sh and converted them to batch jobs.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document