Skip to main content

Qlik Community

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Official Support Articles

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.

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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Barb_Fill21
Support
Support
‎2023-03-29 10:50 AM

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)
Labels:
77 Views
Version history
Last update:
‎2023-03-29 10:50 AM
Updated by:
Digital Support