Technical Blog Post
Weekly Tips from DB2 Experts: Determine Instance uptime using db2pd utility
db2pd is a very powerful tool which can be used for troubleshooting many complex issue in DB2 like - high memory usage, locking issues, HADR, and collecting various statistics. It can also be used to find out a simple thing like how long the instance has been up.
db2pd with a '-' option displays the uptime for an instance. It displays the number of days and hours the instance has been running. No database connection is required.
$ db2pd -
Database Member 0 -- Active -- Up 4 days 00:13:14 -- Date 2014-10-27-14.56.06.346538
If the instance is down, the following message will be displayed.
$ db2pd -
Unable to attach to database manager on member 0.
Please ensure the following are true:
- db2start has been run for the member.
- db2pd is being run on the same physical machine as the member.
- DB2NODE environment variable setting is correct for the member
or db2pd -mem setting is correct for the member.
Thanks for reading. Please feel free to post your comments/feedback.