Friday, November 30, 2012

1 db2top

To analysis DB2 performance issue, we commonly collect the snapshot. DB2top is the command line tool that help us to analysis the snapshot . when I first look at it, it looks like the command line version of the taskmgr but focus on the DB2 system level.

db2top -d DBNAME


You can hit the shortcut keys to navigate to the monitor features. If you forge what keys, just hit “h” to go to the help page. Once you find what you need, just hit the enter key to go back to previous session and go from there.

m: Memory usage


B: Bottleneck






SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates