Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
how to capture the DDL Changes in DB2 Log?

Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message

New User

Joined: 09 Apr 2009
Posts: 50
Location: Bangalore

PostPosted: Wed Apr 29, 2020 5:25 pm    Post subject: how to capture the DDL Changes in DB2 Log?
Reply with quote

Hi All,
I am working on a DB2 real-time replication project.
I am reading the DB2 (version 12 Mode 500, running on z/OS 2.3) logs by using IBM IFI306 API calls. I am able to extract the DML changes from the logs. However, I don't see any DDL changes being captured in the logs? ( To be more specific, For Alter table).

I would like to know the following
1. Does the IBM DB2 for z/OS capture the DDL changes on logs?
2. Are there any subsystem level settings that need to be done to capture the DDL changes?

Currently, as a workaround, I am depending on DB2 catalog tables to identify the DDL changes for a specific table.

Any help will be highly appreciated! Thank you!

Back to top
View user's profile Send private message

View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1


Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Capture DSN names through SORT / IDCAMS reach2abhinavtyagi DFSORT/ICETOOL 8 Tue Nov 05, 2019 7:33 pm
No new posts How to Capture the Max return code of... anilkumar922 All Other Mainframe Topics 2 Thu Jan 12, 2017 12:02 pm
No new posts Change Data Capture Ron Klop DFSORT/ICETOOL 14 Fri Apr 15, 2016 2:56 pm
No new posts Sort,remove & capture dup recs ha... subratarec DFSORT/ICETOOL 21 Tue Apr 28, 2015 9:28 pm
No new posts DYNALLOC macro in Assember -Is there ... sudarshan.srivathsav PL/I & Assembler 2 Wed May 07, 2014 10:11 pm

Back to Top
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us