Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Identify DB2 Objects that were created before a date

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: Identify DB2 Objects that were created before a date
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 Member


Joined: 14 Mar 2007
Posts: 10622
Location: italy

PostPosted: Thu Jan 24, 2013 2:58 pm    Post subject: Reply to: Identify DB2 Objects that were created before a da
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    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Date insertion returns -180 Raghu navaikulam CICS 1 Mon Jul 29, 2019 5:12 pm
This topic is locked: you cannot edit posts or make replies. Need to write the date at the end of ... Poha Eater DFSORT/ICETOOL 16 Tue Jul 23, 2019 2:33 pm
No new posts Identify who, from where, sign on CIC... Weilin Wen CICS 1 Thu May 09, 2019 1:23 pm
No new posts SQL to retrieve latest Eff date and then vinu78 DB2 8 Tue Apr 30, 2019 3:45 pm
No new posts how to add date & timestamp to th... dharmaraok DFSORT/ICETOOL 5 Thu Apr 18, 2019 2:45 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us