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

Identify DB2 Objects that were created before a date


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

New User


Joined: 25 Jul 2005
Posts: 15
Location: Hyderabad

PostPosted: Thu Jan 24, 2013 2:38 pm
Reply with quote

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
Back to top
View user's profile Send private message
enrico-sorichetti

Senior Moderator


Joined: 14 Mar 2007
Posts: 10722
Location: italy

PostPosted: Thu Jan 24, 2013 2:58 pm
Reply with quote

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 icon_cool.gif

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
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 Date conversion using SORT SYNCSORT 4
No new posts De-compile AFP objects IBM Tools 1
No new posts Date Conversion Y2T to Y2W SYNCSORT 8
No new posts Date format conversion DFSORT/ICETOOL 4
No new posts Hex Value - vb file replace old date ... DFSORT/ICETOOL 14
Search our Forums:

Back to Top