160 Sybase to DB2 Conversion Guide
In Sybase ASE, the database system is often monitored using the Sybase
ASE Monitor, and the performance statistics are analyzed with the Sybase
ASE Monitor Viewer using the Adaptive Server Enterprise plug-in for the
Sybase Central administration tool. In addition, Sybase ASE provides a set of
System Monitor tables that contain performance and diagnostics information,
from which information, such as physical reads, buffer pool hit ratios, and
CPU times, can be queried.
To facilitate DB2 monitoring, DB2 collects information from the database
manager, databases, and any connected applications, which enables you to:
򐂰 Forecast hardware requirements based on database usage patterns
򐂰 Analyze the performance of individual applications or SQL queries
򐂰 Track the use of indexes and tables
򐂰 Pinpoint the cause of poor system performance
򐂰 Assess the impact of optimization activities
8.4.1 Monitor switches
There are essentially two types of monitoring:
򐂰 Snapshot monitor
The snapshot monitor provides a snapshot of the database system monitor
data. A snapshot of monitor data describes the state of database activity at
the particular point-in-time that a snapshot is taken. This approach of
database system monitoring is particularly useful in evaluating the
performance of a database system and in detecting potential problems.
򐂰 Event monitoring
The event monitoring captures and logs data as specific database events
occur over a continuous period.
In both the monitoring methods, you must enable DB2 for monitoring by turning
the monitor switches on. The monitor switches enable specific events to be
monitored. The state of the monitor switches can be obtained using the GET
MONITOR SWITCHES command. Example 8-25 shows the event monitor
switches.
Example 8-25 Monitor recording switches
Switch list for db partition number 0
Buffer Pool Activity Information (BUFFERPOOL) = ON 02/21/2011 18:54:51.140028
Lock Information (LOCK) = ON 02/21/2011 18:54:51.140028
Sorting Information (SORT) = ON 02/21/2011 18:54:51.140028
SQL Statement Information (STATEMENT) = ON 02/21/2011 18:54:51.140028
Table Activity Information (TABLE) = ON 02/21/2011 18:54:51.140028
Take Timestamp Information (TIMESTAMP) = ON 02/21/2011 18:54:51.140028

Get Sybase to DB2 Conversion Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.