Results 1 to 6 of 6
  1. #1
    Join Date
    Jan 2004
    Location
    Phoenix, AZ
    Posts
    42

    Unanswered: How to tell when a DB2 instance was last Stopped/Started

    Hello,

    Does anyone know of a way to tell when a database instance was last stopped and started?

    I thought of ps -ef | grep db2, but I am getting no consistent dates.

    Any better ideas?

    Thanks!

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look in db2diag.log

    Andy

  3. #3
    Join Date
    Jan 2004
    Location
    Phoenix, AZ
    Posts
    42
    Thanks Andy, great idea, however,

    We keep our diaglevel at a 3, so we trim lines from the log to keep its size down to conserve file system space. So, we have no past record.

    Do you know of a way to tell at the OS level (Unix)?

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Not sure what you mean by 'no consistent date' ... Do you mean that various processes are started at different times ?? If so, see the time on the process db2gds

    This is the 'global daemon spawner' which will be 'managing' other db2 associated threads ...

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Jan 2004
    Location
    Phoenix, AZ
    Posts
    42

    Thumbs up

    Thanks Sathyaram. That is exactly what I needed.

  6. #6
    Join Date
    Sep 2002
    Posts
    456
    To get the time when instance was started, issue the following command for the instance in question:

    db2 get dbm cfg

    The output of this will show you the instance startup timestamp.

    dollar

Posting Permissions

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