How long is database up and running

grofaty · #1 (**permalink**) 12-24-03, 05:09

Hi,

Is there any command to found out how long time is database up and running.

I can find out for Linux/Unix with command: uptime. Is there something like that on DB2 UDB v8.1 for Linux?

Thanks,
Grofaty

sathyaram_s · #2 (**permalink**) 12-24-03, 05:25

db2 get snapshot for database on <dbname> | grep 'First database connect timestamp'

Quote:

Originally posted by grofaty
Hi,

Is there any command to found out how long time is database up and running.

I can find out for Linux/Unix with command: uptime. Is there something like that on DB2 UDB v8.1 for Linux?

Thanks,
Grofaty

cchattoraj · #3 (**permalink**) 12-24-03, 10:48

get snapshot for dbm | grep -i 'start database manager timestamp'

will give the instance start timestamp

Question for Satyaram : If the database is explicitly activated after instance startup, does db2 consider that to be first connect?

sathyaram_s · #4 (**permalink**) 12-24-03, 11:27

Yes, it does ...

The interesting thing is , following activate database command, the count of the 'Application Connects' is changed to 1 but the 'high watermark for connections' remains 0

Cheers
Sathyaram

Quote:

Originally posted by cchattoraj
get snapshot for dbm | grep -i 'start database manager timestamp'

will give the instance start timestamp

Question for Satyaram : If the database is explicitly activated after instance startup, does db2 consider that to be first connect?

Internet Services

Web Development

Digital Marketing

Consumer Tech