IBM Mainframe Forum Index
Log In
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register

how to capture the DDL Changes in DB2 Log?

IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2


Similar Topics
Topic Forum Replies
No new posts Capture GDG Dataset Name JCL & VSAM 10
No new posts Capture DSN names through SORT / IDCAMS DFSORT/ICETOOL 8
No new posts How to Capture the Max return code of... All Other Mainframe Topics 2
No new posts Change Data Capture DFSORT/ICETOOL 14
No new posts Sort,remove & capture dup recs ha... DFSORT/ICETOOL 21
Search our Forums:

Back to Top