
Support
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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
469 Views