Who Should Use This Book
How This Book is Structured
Conventions
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
Dynamic SQL Snapshot
Node and Global Snapshots
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
Taking a Global Snapshot
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
Node with Least Available Log Space
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
DCS Application Agents
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
Blocking Cursor
Outbound Blocking Cursor
Statement Execution Elapsed Time
Transaction Processor Monitoring
Federated Database Systems
Data Source Name
Application Identification
Disconnects
Inserts
Updates
Deletes
Create Nicknames
Pass-Through
Stored Procedures
Remote Locks
Rows Returned by Stored Procedures
Query Response Time
Insert Response Time
Update Response Time
Delete Response Time
Create Nickname Response Time
Pass-Through Time
Stored Procedure Time
Remote Lock Time
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
Switch List 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
db2GetSnapshotSize - Estimate Size Required for db2GetSnapshot() Output Buffer
db2MonitorSwitches - Get/Update Monitor Switches
db2ResetMonitor - Reset Monitor
DROP EVENT MONITOR
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
UPDATE MONITOR SWITCHES
Appendix B. Logical Data Groupings
Snapshot Monitor Logical Data Groupings
Event Monitor Logical Data Groupings
Appendix C. Parallel Edition Version 1.2 Users
API Changes
Obsolete Commands
Appendix D. DB2 Version 1 sqlestat Users
Appendix E. Using the DB2 Library
DB2 PDF Files and Printed Books
DB2 Information
Printing the PDF Books
Ordering the Printed Books
DB2 Online Documentation
Accessing Online Help
Viewing Information Online
Using DB2 Wizards
Setting Up a Document Server
Searching Information Online
Appendix F. Notices
Trademarks