Wednesday, June 3, 2015

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



Labels:

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home