monitoring dynamic server 英文.pdf

Module 5 Monitoring Dynamic Server Monitoring Dynamic Server 11-2003 5-1 © 2001, 2003 International Business Machines Corporation Objectives At the end of this module, you will be able to: Describe the use of the system monitoring interface (SMI) Connect to the sysmaster database and run simple SQL queries Use onstat to monitor information about the database server Use oncheck to gather information about space usage and the status of indexes and tblspaces Use ISA to monitor server activity 5-2 5-2 Monitoring Dynamic Server Monitoring Utilities There are several ways you can monitor a server: System monitoring interface (SMI) onstat oncheck ISA 5-3 Dynamic Server provides several ways for you to monitor your database server. These interfaces and utilities are covered in the following pages. Monitoring Dynamic Server 5-3 System Monitoring Interface The System Monitoring Interface (SMI) is a read-only access method to administrative information related to a Dynamic Server system that: Provides SQL access to shared memory structures Shared Memory Provides profile information for specific user sessions sysmaster Allows a Dynamic Server Database administrator to easily automate the system monitoring process NOTE: SMI is not a utility!