Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2009
    Posts
    272

    Unanswered: database creation time

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

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I usually go by the time the system catalog tables got created (db2 list tables for schema SYSIBM).

  3. #3
    Join Date
    Jun 2009
    Posts
    272
    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.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    I think sysibm.sysversions gets updated during upgrade / migration. Take a look at this table.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •