IBM Books

System Monitor Guide and Reference

Sys Mon IBM DB2 Universal Database
System Monitor Guide and Reference

Version 5

S10J-8164-00


10J8164

Before using this information and the product it supports, be sure to read the general information under Appendix E. "Notices".

This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties and any statements provided in this manual should not be interpreted as such.

Order publications through your IBM representative or the IBM branch office serving your locality or by calling 1-800-879-2755 in U.S. or 1-800-IBM-4YOU in Canada.

When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you.

© Copyright International Business Machines Corporation 1993, 1997. All rights reserved.
Note to U.S. government Users -- Documentation related to restricted rights -- Use, duplication or disclosure is subject to restrictions set forth in GSA ADP Schedule contract with IBM Corp.

Table of Contents

About This Book

  • Who Should Use This Book
  • How This Book is Structured
  • Conventions

    • Chapter 1. Introducing the Database System Monitor

  • Database System Monitor Capabilities

    • Chapter 2. Using the Database System Monitor

  • Database Manager Maintains Operation and Performance Data
  • Monitor Switches Control Data Collected by the Database Manager
  • Accessing Monitor Data
  • Snapshot Monitoring
  • Authority Required for Snapshot Monitoring
  • Snapshot Monitor Interface
  • Information Available by Taking Snapshots
  • Snapshot Uses an Instance Connection
  • Availability of Snapshot Monitor Data
  • Event Monitors
  • Authority Required for Event Monitoring
  • Using Event Monitors
  • Querying the State of an Event Monitor
  • Information Available from Event Monitors
  • Using Pipe Event Monitors
  • When Counters are Initialized
  • Resetting Monitor Data
  • System Monitor Memory Requirements - (mon_heap_sz)
  • Partitioned Database Considerations
  • Taking a Snapshot on Multi-node Systems
  • Using Event Monitors on Multi-node Systems
  • Monitoring Subsections
  • DB2 Productivity Tools
  • System Monitor Definitions

    • Chapter 3. Database System Monitor Data Elements

  • How to Read the Data Element Tables
  • Element Types
  • Server Identification and Status
  • Start Database Manager Timestamp
  • Configuration NNAME at Monitoring (Server) Node
  • Server Instance Name
  • Database Manager Type at Monitored (Server) Node
  • Server Product/Version ID
  • Server Version
  • Service Level
  • Server Operating System
  • Product Name
  • Product Identification
  • Status of DB2 Instance
  • Database Identification and Status
  • Database Name
  • Database Path
  • Database Activation Timestamp
  • Database Deactivation Timestamp
  • Status of Database
  • Catalog Node Network Name
  • Database Location
  • Catalog Node Number
  • Last Backup Timestamp
  • Application Identification and Status
  • Application Handle (agent ID)
  • Application Status
  • ID of Code Page Used by Application
  • Application Status Change Time
  • Application Name
  • Application ID
  • Sequence Number
  • Authorization ID
  • Configuration NNAME of Client
  • Client Product/Version ID
  • Database Alias Used by Application
  • Host Product/Version ID
  • Outbound Application ID
  • Outbound Sequence Number
  • User Login ID
  • DRDA Correlation Token
  • Client Process ID
  • Client Operating Platform
  • Client Communication Protocol
  • Database Country Code
  • Application Agent Priority
  • Application Priority Type
  • User Authorization Level
  • Coordinating Node
  • Connection Request Start Timestamp
  • Connection Request Completion Timestamp
  • Previous Unit of Work Completion Timestamp
  • Unit of Work Start Timestamp
  • Unit of Work Stop Timestamp
  • Unit of Work Completion Status
  • Previous Transaction Stop Time
  • Application Idle Time
  • DB2 Agent Information
  • Database Manager Configuration
  • Agents and Connections
  • Sort
  • Fast Communication Manager
  • Database Configuration
  • Buffer Pool Activity
  • Non-buffered I/O Activity
  • Catalog Cache
  • Package Cache
  • Database Heap
  • Logging
  • Database and Application Activity
  • Locks and Deadlocks
  • Lock Wait Information
  • Rollforward Monitoring
  • Table Activity
  • SQL Cursors
  • SQL Statement Activity
  • SQL Statement Details
  • Subsection Details
  • Intra-query Parallelism
  • CPU Usage
  • Snapshot Monitoring Elements

    • Chapter 4. Event Monitor Output

  • Output Stream Format
  • Matching Event Records with Their Application
  • File Event Monitor Buffering
  • Blocked Event Monitors
  • Non-Blocked Event Monitors
  • File Event Monitor Target
  • Programming to Read an Event Monitor Trace
  • Reading the Data Stream
  • Swapping Bytes in Numerical Values
  • Reading the Event Records
  • Reading the Log Header
  • Printing Event Records
  • Reading Events from a FILE Trace

    • Appendix A. Database System Monitor Interfaces

  • CREATE EVENT MONITOR Command and SQL
  • db2eva - Event Analyzer Command
  • db2evmon - Event Monitor Trace Formatter Command
  • DROP EVENT MONITOR Command and SQL
  • EVENT_MON_STATE SQL Function
  • GET DATABASE MANAGER MONITOR SWITCHES Command
  • GET MONITOR SWITCHES Command
  • GET SNAPSHOT Command
  • LIST ACTIVE DATABASES Command
  • LIST APPLICATIONS - Command
  • LIST DCS APPLICATIONS - Command
  • RESET MONITOR Command
  • SET EVENT MONITOR STATE Command and SQL
  • sqlmon - Get/Update Monitor Switches API
  • sqlmonss - Get Snapshot API
  • sqlmonsz - Estimate Size Required for sqlmonss() Output Buffer API
  • sqlmrset - Reset Monitor API
  • UPDATE MONITOR SWITCHES Command

    • Appendix B. Parallel Edition Version 1.2 Users

  • API Changes
  • Obsolete Commands

    • Appendix C. DB2 Version 1 sqlestat Users

    Appendix D. How the DB2 Library Is Structured

  • SmartGuides
  • Online Help
  • DB2 Books
  • About the Information Center

    • Appendix E. Notices

  • Trademarks
  • Trademarks of Other Companies

    • Appendix F. Contacting IBM

    Index

    About This Book

    Your DB2 Database Manager is instrumented to gather data on its operation and performance. You can use this data to:

    The DB2 DBMS function that collects this data is called the database system monitor. This book describes how to use the database system monitor.

    Various tools allow users to exploit the strengths of the database system monitor with minimal explicit knowledge of its associated commands, APIs, or data formats. Some of these tools, for example the Control Center, are described briefly, but for detailed information you should refer to the Administration Getting Started.

    [ Top of Page | Next Page | Index ]

    [ DB2 List of Books | Search the DB2 Books ]