Results 1 to 5 of 5
  1. #1
    Join Date
    Jul 2002
    Posts
    86

    Unanswered: How can I find the creation time of the database

    db2v7.2

    Thanks

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    I am not sure how accurate it is, but it should be very close.
    You can issue:

    List HISTORY ALL FOR MyDatabase

    and the very first entry should be close.

    List history shows a list of DB admin activities including backup restore, tablespace creations and alterations, etc.

    so if you created any tablespaces right after you created th DB that that timestamp should be close enough.

    I have not found anything else yet that might help you.

    HTH

    Andy

  3. #3
    Join Date
    Sep 2002
    Posts
    456

    Database create timestamp

    or.....you can take a look at the timestamp of the folder NODE0000 or so...there has to be a better way than this..!!!

    dollar

    Originally posted by ARWinner
    I am not sure how accurate it is, but it should be very close.
    You can issue:

    List HISTORY ALL FOR MyDatabase

    and the very first entry should be close.

    List history shows a list of DB admin activities including backup restore, tablespace creations and alterations, etc.

    so if you created any tablespaces right after you created th DB that that timestamp should be close enough.

    I have not found anything else yet that might help you.

    HTH

    Andy

  4. #4
    Join Date
    Sep 2002
    Posts
    456

    Re: How can I find the creation time of the database

    try this:

    select * from sysibm.sysversions;

    dollar

    Originally posted by David2002
    db2v7.2

    Thanks

  5. #5
    Join Date
    Jul 2002
    Posts
    86

    Re: How can I find the creation time of the database

    Originally posted by dollar489
    try this:

    select * from sysibm.sysversions;

    dollar

    Thank you all for your consideration.

Posting Permissions

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