Search This Blog

Thursday, January 30, 2014

DB2 Tuning Commands & DB2 Utility Commands

Quickly look at some basic tuning measurements:
db2 "select db_name,  rows_read, rows_selected, lock_waits, lock_wait_time, deadlocks, lock_escals, total_sorts, total_sort_time from table (snapshot_database (' ', -1) ) as snapshot_database"


List the running utilities and their progress
=>db2 list utilities show detail
Throttle a running utility.
First find the Utility ID.
=>db2 list utilities show detail
Throttle the utility to a value of 1 to 10. 10 being the most throttled.
=>db2 set UTIL_IMPACT_PRIORITY for TO 5

No comments:

Post a Comment

Default Communication Template for each application - Maximo

  Add the dialog from Library to the SR and WOTRACK application. So, the application xml overwrites the Library xml. Now the SR is using the...