Enable monitor switches on DB2 instance
db2 => get monitor switches
Monitor Recording Switches
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = OFF
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = OFF
Unit of Work Information (UOW) = OFF
db2 => update monitor switches using SORT on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
db2 => update monitor switches using bufferpool on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
db2 => update monitor switches using statement on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
db2 => update monitor switches using table on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
db2 => update monitor switches using lock on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
db2 => get monitor switches
Monitor Recording Switches
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = ON 06/03/2015 20:54:39.404121
Lock Information (LOCK) = ON 06/03/2015 20:55:10.877652
Sorting Information (SORT) = ON 06/03/2015 20:54:24.260609
SQL Statement Information (STATEMENT) = ON 06/03/2015 20:54:48.091248
Table Activity Information (TABLE) = ON 06/03/2015 20:54:57.851274
Take Timestamp Information (TIMESTAMP) = OFF
Unit of Work Information (UOW) = OFF
Monitor Recording Switches
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = OFF
Lock Information (LOCK) = OFF
Sorting Information (SORT) = OFF
SQL Statement Information (STATEMENT) = OFF
Table Activity Information (TABLE) = OFF
Take Timestamp Information (TIMESTAMP) = OFF
Unit of Work Information (UOW) = OFF
db2 => update monitor switches using SORT on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
db2 => update monitor switches using bufferpool on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
db2 => update monitor switches using statement on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
db2 => update monitor switches using table on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
db2 => update monitor switches using lock on
DB20000I The UPDATE MONITOR SWITCHES command completed successfully.
db2 => get monitor switches
Monitor Recording Switches
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = ON 06/03/2015 20:54:39.404121
Lock Information (LOCK) = ON 06/03/2015 20:55:10.877652
Sorting Information (SORT) = ON 06/03/2015 20:54:24.260609
SQL Statement Information (STATEMENT) = ON 06/03/2015 20:54:48.091248
Table Activity Information (TABLE) = ON 06/03/2015 20:54:57.851274
Take Timestamp Information (TIMESTAMP) = OFF
Unit of Work Information (UOW) = OFF
Labels: db2 monitor switches
0 Comments:
Post a Comment
Subscribe to Post Comments [Atom]
<< Home