Usually we run uptime command in Unix to find the uptime of the server. But, what about DB2 database? How long it had been working?

db2 “select db_conn_time from table (mon_get_database(-2))”

The db2pd -d <database> – –> will also tell the uptime of the database. Note dash after the database name.

db2pd – ==> will tell instance uptime. Note dash after db2pd for instance uptime.