Technical Blog Post
Abstract
Monitor the progress of DB2 commands
Body
Unavoidably some commands are time-consuming. This blog summarizes the commands that you can use to monitor the progress of DB2 commands.
| DB2 Commands/Activities | Monitoring Commands |
|---|---|
| Crash Recovery |
db2pd -rec -db <dbname> db2pd -util Further reading: /support/pages/node/501343 Perf tuning: UTIL_HEAP_SZ, adjust parallelism by setting number of redo workers, eg, set to 5 below(the below number 6 = 5 workers + 1 redo master): |
| Rollforward |
db2pd -rec -db <dbname> db2 list utilities show detail or db2pd -util Perf tuning: same as Crash Recovery |
| Backup and Restore |
db2 list utilities show detail or db2pd -util Perf tuning: UTIL_HEAP_SZ, parallelism, buffer |
| Reorg |
db2pd -db <dbname> -reorg Perf tuning: Dropping unnecessary indexes, sortheap & sheapthres(>SORTHEAP*#of_processors), number of page cleaner(NUM_IOCLEANERS) |
| Rebalance |
db2 list utilities show detail or db2pd -util MON_GET_REBALANCE_STATUS table function |
| Application rollback | db2 GET SNAPSHOT FOR ALL APPLICATIONS |
| Load |
db2pd -util db2pd -load -alldbs Perf tuning: Load parallelism and data buffer(>1/4*util_heap_sz), UTIL_HEAP_SZ Further reading: |
| Indexing |
Perf tuning: UTIL_HEAP_SZ, SHEAPTHRES |
| Runstats |
db2 list utilities show detail or db2pd -util db2pd -db <dbname> -runstats Further reading: |
| Partition Detach | db2 list utilities show detail or db2pd -util |
UID
ibm13286329