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) = ON  02 10 2004 13:01:51.019864

Unit of Work Information                 (UOW) = OFF

The monitor switches can be turned on at the instance level or at an application 

level. To switch the monitors at the instance level, modify the appropriate 

database manager parameter. After modifying the 

DFT_MON_BUFPOOL

 parameter, 

as shown in Example 9 12, all users with administration authorities will be able to 

collect buffer pool statistics on any database in the instance.

Example 9 12   Updating monitor switches at instance level

db2 update dbm cfg using DFT_MON_BUFPOOL ON

To switch the monitors at the application level, issue the 

UPDATE MONITOR 

SWITCHES

 command from the command line. The changes will only be applicable 

to that particular prompt window. Example 9 13 shows how to update the suitable 

monitor switch for collecting buffer pool information.

Example 9 13   Updating monitor switches at application level

db2 update monitor switches using BUFFERPOOL ON

The complete list of monitor switches and related database manager parameters 

is presented on Table 9 2.

Table 9 2   List of monitor switches and related DBM parameters

Database manager 

Monitor switch

Information provided

parameter

DFT_MON_BUFFERPOOL

BUFFERPOOL

Number of reads and 

writes, time taken

DFT_MON_LOCK

LOCK

Lock wait times, deadlocks

DFT_MON_SORT

SORT

Number of heaps used, 

sort performance

DFT_MON_STMT

STATEMENT

Start/stop time, SQL 

statement identification

DFT_MON_TABLE

TABLE

Measure of activity (rows 

read/written)

 Chapter 9. Testing and tuning 

287