Filter
Top Products
can provide information that lets you observe trends and identify potential
problem areas. Snapshot monitoring is performed by executing the GET SNAPSHOT
command from the DB2 Command-Line Processor (CLP).
Snapshot Monitor Commands
To use snapshot monitors, turn on the monitor switches and view data. The
following table describes the command and syntax for specific tasks:
Task Command and Syntax
Turn on monitor
switches
db2 UPDATE MONITOR SWITCHES USING options
Options are:
lock on
sort on
statement on
table on
timestamp on
uow on
Note: Monitor switches can also be controlled in the database
manager configuration.
Check status of
monitor switches
GET MONITOR SWITCHES
View snapshot data Switches must be turned on to view data.
GET SNAPSHOT FOR options
Options:
bufferpools on database_name
locks on database_name
dynamic sql on database_name
tables on database_name
applications on database_name
tablespaces on database_name
database on database_name
DB2 Event Monitors
Information about snapshot monitors is available by searching at
http://www.ibm.com/developerworks/.
Event monitors are used to monitor events in an area over time, such as by
producing event records at the start and end of multiple events. These records are
useful for resource planning, trend analysis, and so on.
Performance Management 49