View previous topic :: View next topic
|
Author |
Message |
Naga Rajender.K
New User
Joined: 19 Dec 2008 Posts: 13 Location: Hyderabad
|
|
|
|
Hi ,
Can anyone help me to "how can we know a db2 table creation history".
like
1) when the table is created
2) when a particular column has been added.. etc
Thanks in advance |
|
Back to top |
|
|
Dsingh29
Active User
Joined: 16 Dec 2008 Posts: 132 Location: IBM
|
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
Dsingh29 wrote: |
yes, very much..it can be done thru DB2 logs
|
I like to see you do it for for a table that was created 3 monts ago and somewhere within these three months 3 columns were added , 2 deleted and 1 altered. Good Luck!
Without decent change management tools/administration this can not be done. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Naga,
Check the DB2 Catalogs,
Columns CREATEDTS, ALTEREDTS in SYSIBM.SYSTABLES
Columns CREATEDTS, ALTEREDTS in SYSIBM.SYSCOLUMNS
Thanks
Sushanth |
|
Back to top |
|
|
|