Skip to main content
Announcements
Qlik Data Gateway upgrade REQUIRED by September 15 READ MORE

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

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: