Database manager 

Monitor switch

Information provided

parameter

DFT_MON_UOW

UOW (Unit Of Work)

Start/end times, 

completion status

DFT_MON_TIMESTAMP

TIMESTAMP

Timestamps

Sample snapshots

The 

database manager snapshot

 (Example 9 14) captures information specific to 

the instance level. The information centers on the total amount of memory 

allocated to the instance and the number of agents that are currently active on 

the system.

Example 9 14   Database manager snapshot

db2 get snapshot for database manager

The 

lock snapshot

 (Example 9 15) is very useful in determining what locks an 

application currently is holding, or what locks another application is waiting on. 

The snapshot lists all applications on the system and the locks that each is 

holding. Each lock and each application is given a unique identifier number.

Example 9 15   Lock snapshot

db2 get snapshot for locks on db2_emp

The 

table snapshot

 (Example 9 16) contains information on the usage and 

creation of all tables. This information is quite useful in determining how much 

work is being run against a table and how much the table data changes. This 

information can then be used to decide how your data should be laid out 

physically.

Example 9 16   Table snapshot

db2 get snapshot for tables on db2_emp

The 

table space

 and 

buffer pool snapshots

 (Example 9 17) contain similar 

information. The table space snapshot returns information on the layout of the 

table space and how much space is being used. The buffer pool snapshot 

contains information on how much space is currently allocated for the buffer pool, 

and how much space will be allocated when the database is next reset. Both 

snapshots contain a summary of the way in which data is accessed from the 

database. This access can be done from a buffer pool, direct from tables on disk, 

or through a direct read or write for LOBs or 

LONG

 objects.

288 

MySQL to DB2 UDB Conversion Guide