Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Posts
    5

    Unanswered: Query - When DB2 server/databas has been started

    I'm trying to find out when DB2 DATABASE/SERVER started and how long it has been running. Is there query or command in that I can use to check this? Is there more than one option to find this out and is it same for all DB2 versions or diffferent from version to version?

    Thanks

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    db2top gives you that info on the "d" (database) screen

  3. #3
    Join Date
    Jan 2010
    Posts
    335
    Hi,

    the start-timestamp for an Instance running on LUW is given in the snapshot for the database manager
    get snapshot for dbm -> "Start Database Manager timestamp"
    This works for all versions i know.

    Starting with Version 9 you could use
    select DB2START_TIME from SYSIBMADM.SNAPDBM

Posting Permissions

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