Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
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 TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
This topic is locked: you cannot edit posts or make replies. Get correct date and time when curren... balaji81_k DB2 24 Fri Oct 14, 2016 10:40 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts Add system date inside of a PS file a... pramitdas DFSORT/ICETOOL 5 Sun Aug 28, 2016 12:06 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us