View previous topic :: View next topic
|
Author |
Message |
rakesh17684
New User
Joined: 08 Oct 2006 Posts: 61 Location: San Diego
|
|
|
|
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 |
|
|
Terry Yin
New User
Joined: 19 Sep 2018 Posts: 4 Location: China
|
|
|
|
SYSCOPY will provide you change timestamp which meets your requirement.
but no details logged in any catlog tables as far as I know.
Please correct me if I'm wrong. |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3048 Location: NYC,USA
|
|
|
|
SYSCOPY don't provide DDL changes. I guess you need to explore DB2 logs and achieves. |
|
Back to top |
|
|
|