sriteja
New User
Joined: 25 Jul 2005 Posts: 15 Location: Hyderabad
|
|
|
|
Hi,
I was looking for a way I can identify objects like Storage Group, Database, Tablespace, Tables etc that were created in DB2 system before a particular date.
I have checked all Catalog tables and I dont see any columns that tell me the date of creation.
Does DB2 actually store any such information? Is it possible to get such data in any way?
I need this information on DB2 for z/OS.
Thanks |
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
Quote: |
I need this information on DB2 for z/OS. |
if You have checked the catalog tables and no <date> info is there
then Your need will have to be satisfied by some other mean
anyway a simple search in the DB2 manuals for the string CREATEDTS
( which in any language means CREATEed Time Stamp )
reports that
Quote: |
SYSIBM.SYSSTOGROUP table, 7.7.83
SYSIBM.SYSROLES table, 7.7.72
SYSIBM.SYSSYNONYMS table, 7.7.85
SYSIBM.XSROBJECTCOMPONENTS table, 7.7.106
SYSIBM.SYSDATABASE table, 7.7.26
SYSIBM.SYSCONTEXTAUTHIDS table, 7.7.23
SYSIBM.SYSCTXTTRUSTATTRS table, 7.7.25
SYSIBM.SYSJAROBJECTS table, 7.7.45
SYSIBM.SYSTABCONST table, 7.7.87
SYSIBM.SYSXMLRELS table, 7.7.101
SYSIBM.XSROBJECTS table, 7.7.105
SYSIBM.SYSINDEXES table, 7.7.35
SYSIBM.SYSTABLESPACE table, 7.7.91
SYSIBM.SYSCONTEXT table, 7.7.22
SYSIBM.SYSDATATYPES table, 7.7.27
SYSIBM.SYSKEYTARGETS table, 7.7.50
SYSIBM.SYSSEQUENCES table, 7.7.80
SYSIBM.SYSTRIGGERS table, 7.7.96
SYSIBM.SYSTABLES table, 7.7.90
SYSIBM.SYSINDEXPART table, 7.7.37
SYSIBM.SYSTABLEPART table, 7.7.88
SYSIBM.SYSCOLUMNS table, 7.7.19
SYSIBM.SYSROUTINES table, 7.7.74
TIMESTAMP_FORMAT, 3.2.137 |
contain the string |
|