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

SYSIBM Catlog tables to see DDL changes history


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
rakesh17684

New User


Joined: 08 Oct 2006
Posts: 61
Location: San Diego

PostPosted: Fri Jun 08, 2018 3:43 am
Reply with quote

Hi,

I am back to the mainframe world after a longtime. I wanted to see if there is a DB2 catlog table to see DDL changes performed in the last few months. I have a table which was changed couple of times last month. I wanted to see when these changes were performed.

Thanks
R
Back to top
View user's profile Send private message
Terry Yin

New User


Joined: 19 Sep 2018
Posts: 4
Location: China

PostPosted: Thu Sep 20, 2018 8:14 am
Reply with quote

SYSCOPY will provide you change timestamp which meets your requirement.
but no details logged in any catlog tables as far as I know. icon_cry.gif
Please correct me if I'm wrong.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3048
Location: NYC,USA

PostPosted: Thu Sep 20, 2018 8:00 pm
Reply with quote

SYSCOPY don't provide DDL changes. I guess you need to explore DB2 logs and achieves.
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 Looking for a little history of ISPF ... TSO/ISPF 5
No new posts Need to fetch data from so many DB2 t... DB2 9
No new posts Change history of vsam file. JCL & VSAM 3
No new posts How to: PK does not exist in several ... DB2 6
No new posts Discrepancy b/w SYSIBM tables and BMC... DB2 0
Search our Forums:

Back to Top