database creation time

blazer789 · #1 (**permalink**) 02-23-11, 01:46

How do we get the time when the database has been created ?

db2girl · #2 (**permalink**) 02-23-11, 01:53

I usually go by the time the system catalog tables got created (db2 list tables for schema SYSIBM).

blazer789 · #3 (**permalink**) 02-23-11, 05:35

Well, if a fixpack upgrade or a version migration is done, I believe these tables create_time will be changed to the upgraded/migrated time. And so, that wouldn't be the exact time when database was created

Correct me if I am wrong.

db2girl · #4 (**permalink**) 02-23-11, 06:22

I think sysibm.sysversions gets updated during upgrade / migration. Take a look at this table.

Internet Services

Web Development

Digital Marketing

Consumer Tech