IBM Books

System Monitor Guide and Reference

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 Attachment or a Database Connection
  • Dynamic SQL Snapshot
  • 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
  • Monitor Output Format
  • DB2 Productivity Tools

    • 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
  • Time Zone Displacement
  • Database Identification and Status
  • Database Name
  • Database Path
  • Database Activation Timestamp
  • Time of Database Connection
  • 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 with Oldest Transaction
  • 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
  • Node Number
  • Coordinating Node
  • Connection Request Start Timestamp
  • Maximum Number of Concurrent Connections
  • Connection Request Completion Timestamp
  • Previous Unit of Work Completion Timestamp
  • Unit of Work Start Timestamp
  • Unit of Work Stop Timestamp
  • Most Recent Unit of Work Elapsed Time
  • Unit of Work Completion Status
  • Unit of Work Status
  • Previous Transaction Stop Time
  • Application Idle Time
  • DB2 Agent Information
  • Database Manager Configuration
  • Agents and Connections
  • Sort
  • Hash Join
  • 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
  • Dynamic SQL
  • Intra-query Parallelism
  • CPU Usage
  • Snapshot Monitoring Elements
  • Event Monitoring Elements
  • DB2 Connect
  • DCS Database Name
  • Host Database Name
  • Database Alias at the Gateway
  • DB2 Connect Gateway First Connect Initiated
  • Maximum Number of Concurrent Connections
  • Total Number of Attempted Connections for DB2 Connect
  • Current Number of Connections for DB2 Connect
  • Number of Connections Waiting for the Host to Reply
  • Number of Connections Waiting for the Client to Send Request
  • Elapsed Time Spent on DB2 Connect Gateway Processing
  • Number of SQL Statements Attempted
  • Number of Open Cursors
  • DCS Application Status
  • Host Coded Character Set ID
  • Outbound Communication Protocol
  • Outbound Communication Address
  • Inbound Communication Address
  • Inbound Number of Bytes Received
  • Outbound Number of Bytes Sent
  • Outbound Number of Bytes Received
  • Inbound Number of Bytes Sent
  • Transaction ID
  • Host Response Time
  • Most Recent Response Time for Connect
  • Most Recent Connection Elapsed Time
  • Communication Errors
  • Communication Error Time
  • Transaction Processor Monitoring

    • Chapter 4. Event Monitor Output

  • Output Records
  • Matching Event Records with Their Application
  • File Event Monitor Buffering
  • Blocked Event Monitors
  • Non-Blocked Event Monitors
  • File Event Monitor Target
  • Reading an Event Monitor Trace
  • Reading the Log Stream Header
  • Reading the Log Header
  • Reading the Data Stream
  • Swapping Bytes in Numerical Values
  • Printing Event Records

    • Chapter 5. Snapshot Monitor Output

  • Snapshot Requests
  • Snapshot Output
  • Snapshot Scenarios
  • Making a Snapshot Request
  • Setting Up the sqlma and Issuing the Snapshot Call
  • Reading the Snapshot

    • Appendix A. Database System Monitor Interfaces

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

    • Appendix B. Logical Data Groupings

    Appendix C. Parallel Edition Version 1.2 Users

  • API Changes
  • Obsolete Commands

    • Appendix D. DB2 Version 1 sqlestat Users

    Appendix E. How the DB2 Library Is Structured

  • Completing Tasks with SmartGuides
  • Accessing Online Help
  • DB2 Information - Hardcopy and Online
  • Viewing Online Information
  • Accessing Information with the Information Center
  • Setting Up a Document Server
  • Searching Online Information
  • Printing the PostScript Books
  • Ordering the Printed Books

    • Appendix F. Notices

  • Trademarks
  • Trademarks of Other Companies

    • Appendix G. Contacting IBM

    Index

    [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

    [ DB2 List of Books | Search the DB2 Books ]