Query - When DB2 server/databas has been started

sholtan · #1 (**permalink**) 09-05-10, 15:27

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

dr_te_z · #2 (**permalink**) 09-06-10, 06:12

db2top gives you that info on the "d" (database) screen

nvk@vhv · #3 (**permalink**) 09-06-10, 06:16

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

Internet Services

Web Development

Digital Marketing

Consumer Tech