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: 2576
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 Column names in SYSIBM tables DB2 5
No new posts insert into session tables with UR DB2 0
No new posts Sync logic between VSAM files and DB2... COBOL Programming 9
No new posts Need to delete inactive records from ... DB2 5
No new posts DB2 Unload / Load Multiple tables DB2 8
Search our Forums:

Back to Top