Skip to main content

Qlik Replicate DB2 z/OS Adding Column DDL changes are not coming through to target

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Barb_Fill21
Support
Support

Qlik Replicate DB2 z/OS Adding Column DDL changes are not coming through to target

Last Update:

Mar 29, 2023 10:50:37 AM

Updated By:

Sonja_Bauernfeind

Created date:

Mar 29, 2023 10:50:37 AM

When performing an  ALTER TABLE ADD COLUMN on a DB2 z/OS  application table, the newly added column is not captured.  Even though DATA CAPTURE CHANGES is SET at the application table level,  the column is not coming through to the target. 

 

Resolution

There is a simple solution to this situation.  Ask the DB2 DBA to set :

ALTER TABLE SYSIBM.SYSTABLES  DATA CAPTURE CHANGES  on this system table. 

Cause 

The cause is a mere oversight of turning on this setting on the SYSIBM.SYSTABLES

Related Content 

Installing and upgrading the R4Z product in z/OS | Qlik Replicate Help

 

Environment

Qlik Replicate  and corresponding R4Z  -  Any Version
DB2 z/OS   - Any Version

Labels (1)
Version history
Last update:
‎2023-03-29 10:50 AM
Updated by: