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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved