Select one of the following IBM-supplied performance
variables:
- Active Connections - Database
- Active Local Connections - Database
Manager Instance
- Active Local Connections (%) -
Database Manager Instance
- Active Local Databases - Database
Manager Instance
- Active Remote Connections - Database
Manager Instance
- Active Remote Connections (%) -
Database Manager Instance
- Active Sorts - Database
- Agents Registered - Database Manager
Instance
- Agents Waiting for a Token - Database
Manager Instance
- Agents Waiting (%) - Database Manager
Instance
- Application Idle Time - Connection
- Application In Lock Wait (%) -
Database
- Application Sorts - Connection
- Applications in Lock Wait - Database
- Average Direct Read Time (ms) -
Database
- Average Direct Read Time (ms) -
Table Space
- Average Direct Write Time (ms) -
Database
- Average Direct Write Time (ms) -
Table Space
- Average I/O Time (ms) - Table Space
- Average Lock Wait Time (s) -
Database
- Average Locks Held Per App -
Database
- Average Physical Read Time (ms) -
Database
- Average Physical Read Time (ms) - Table
Space
- Average Physical Write Time (ms) -
Database
- Average Physical Write Time (ms) - Table
Space
- Average Pool I/O Time (ms) - Database
- Average Pool I/O Time (ms) - Table
Space
- Average Pool Read Time (ms) -
Database
- Average Pool Read Time (ms) - Table
Space
- Average Pool Write Time (ms) -
Database
- Average Pool Write Time (ms) - Table
Space
- Average Sort Time (ms) - Database
- Average Synchronous I/O (ms) -
Database
- Average Synchronous I/O (ms) - Table
Space
- Average Synchronous Read (ms) -
Database
- Average Synchronous Read (ms) - Table
Space
- Average Synchronous Write (ms) -
Database
- Average Synchronous Write (ms) -
Table Space
- Buffer Pool Hit Ratio (%) -
Connection
- Buffer Pool Hit Ratio (%) - Database
- Buffer Pool Hit Ratio (%) - Table
Space
- Buffer Pool Hit Ratio, Index (%) -
Connection
- Buffer Pool Hit Ratio, Index (%) -
Database
- Buffer Pool Hit Ratio, Index (%) -
Table Space
- Buffer Pool I/Os per Second - Database
- Buffer Pool I/Os per Second - Table
Space
- Catalog Cache Hit Ratio (%) -
Database
- Cleaners due to Dirty Threshold -
Database
- Commits - Connection
- Commits Attempted - Database
- Committed Statements per Second - Database
- Current Connections - Database
- Current Gateway Connections - Database Manager
Instance
- Current Gateway Connections - Database
- Data Page Writes (4K pages) -
Connection
- DDL SQL Statements - Connection
- DDL SQL Statements - Database
- DDL SQL (%) - Database
- Deadlock Rollbacks (%) - Database
- Deadlocks - Connection
- Deadlocks - Database
- Direct Reads (4K pages) - Connection
- Direct Writes (4K pages) - Connection
- Dynamic SQL Statements -
Connection
- Dynamic SQL Statements - Database
- Explicit Commits - Connection
- Explicit Rollbacks - Connection
- Failed SQL - Connection
- Failed SQL Statements - Connection
- Failed SQL Statements - Database
- Failed SQL (%) - Database
- Failed SQL (%) - Database
- Free Buffers - Database Manager Instance
- Free Buffers (%) - Database Manager
Instance
- Free Connection Entries - Database
Manager Instance
- Free Connection Entries (%) -
Database Manager Instance
- Free Message Anchors - Database Manager
Instance
- Free Message Anchors (%) - Database
Manager Instance
- Free Request Blocks - Database Manager
Instance
- Free Request Blocks (%) - Database
Manager Instance
- Gateway Connections Waiting for Client
Reply - Database Manager Instance
- Gateway Connections Waiting for Client
Reply - Database
- Gateway Connections Waiting for Host
Reply - Database Manager Instance
- Gateway Connections Waiting for Host Reply
- Database
- Inbound Bytes Received - Connection -
Connection
- Inbound Bytes Received - Statement -
Connection
- Inbound Bytes Received - UOW -
Connection
- Inbound Bytes Sent - Connection -
Connection
- Inbound Bytes Sent - Statement -
Connection
- Inbound Bytes Sent - UOW -
Connection
- Index Page Reads (4K pages) -
Connection
- Index Page Writes (4K pages) -
Connection
- Local Connections - Database Manager
Instance
- Lock Escalations - Connection
- Lock Escalations - Database
- Lock List In Use (bytes) - Database
- Lock Timeouts - Database
- Lock Wait Time (s) - Connection
- Lock Waits - Connection
- Lock Waits - Database
- Locks Held - Connection
- Locks Held - Database
- Logical Data Reads (4K pages) -
Connection
- Maximum Agents Registered - Database
Manager Instance
- Maximum Agents Waiting - Database
Manager Instance
- Minimum Free Buffers - Database Manager
Instance
- Minimum Free Connection Entries -
Database Manager Instance
- Minimum Free Message Anchors -
Database Manager Instance
- Minimum Free Request Blocks -
Database Manager Instance
- Number of nodes - Database Manager
Instance
- Open Block Cursors - Connection
- Open Cursors - Connection
- Outbound Bytes Received - Connection -
Connection
- Outbound Bytes Received - Statement -
Connection
- Outbound Bytes Received - UOW -
Connection
- Outbound Bytes Sent - Connection -
Connection
- Outbound Bytes Sent - Statement -
Connection
- Outbound Bytes Sent - UOW -
Connection
- Overflow Accesses - Table
- Package Cache Hit Ratio (%) -
Connection
- Page Cleans - Database
- Pages for each Cleaner - Database
- Pages for each Prefetch Request -
Database
- Piped Sorts Accepted (%) - Database
Manager Instance
- Piped Sorts Rejected (%) - Database
Manager Instance
- Pool I/O Time (s) - Connection
- Pool Read Time (s) - Connection
- Pool Write Time (s) - Connection
- Post Threshold Sorts - Database
Manager Instance
- Prefetch Requests - Database
- Prefetch Requests - Table Space
- Prefetch Satisfied (%) - Table
Space
- Rejected Block Cursors -
Connection
- Remote Connections - Database Manager
Instance
- Rollbacks - Connection
- Rollbacks - Connection
- Rollbacks Attempted - Database
- Rollbacks Attempted - Database
- Rollbacks per Second - Database
- Rollbacks per Second - Database
- Rows Deleted - Connection
- Rows Inserted - Connection
- Rows Read per Second - Table
- Rows Selected - Connection
- Rows Updated - Connection
- Rows Written per Second - Table
- Select SQL Statements - Connection
- Select SQL Statements - Database
- Select SQL (%) - Database
- Sort Heap Allocated (4K pages) -
Database Manager Instance
- Sort Heap Allocated (%) - Database
Manager Instance
- Sort Overflowed (%) - Database
- Sort Time (s) - Connection
- SQL Statements - Connection
- SQL Statements - Database
- SQL Statements per Second - Database
- SQL Statements per Second - Database
- Statement Sorts - Connection
- Static SQL Statements - Connection
- Static SQL Statements - Database
- Synchronous Read Time (ms) - Database
- Synchronous Read Time (ms) - Table
Space
- Synchronous Reads (4K pages) -
Database
- Synchronous Reads (4K pages) - Table
Space
- Synchronous Write Time (ms) - Database
- Synchronous Write Time (ms) - Table
Space
- Synchronous Writes (4K pages) -
Database
- Synchronous Writes (4K pages) - Table
Space
- Time Connected on Gateway - Connection
- Time Spent on Gateway Processing -
Connection
- Total Attempted Gateway Connections -
Database Manager Instance
- Total Attempted Gateway Connections -
Database
- Total Connections - Database
- Total Deadlocks - Connection
- Total Deadlocks - Database
- Total Direct I/O Time (ms) -
Database
- Total Direct I/O Time (ms) - Table
Space
- Total Exclusive Lock Escalations -
Database
- Total I/O (%) - Table Space
- Total Lock Escalations -
Connection
- Total Lock Wait Time (ms) -
Database
- Total Lock Wait Time (s) -
Connection
- Total Log Space Cleaners Invoked -
Database
- Total Piped Sorts Accepted - Database
Manager Instance
- Total Piped Sorts Rejected - Database
Manager Instance
- Total Piped Sorts Requested - Database
Manager Instance
- Total Pool Physical I/O (ms) -
Database
- Total Pool Physical I/O (ms) - Table
Space
- Total Pool Physical Read (ms) -
Database
- Total Pool Physical Read (ms) - Table
Space
- Total Pool Physical Write (ms) -
Database
- Total Pool Physical Write (ms) - Table
Space
- Total Pool Reads (4K pages) -
Database
- Total Pool Reads (4K pages) - Table
Space
- Total Pool Writes (4K pages) -
Database
- Total Pool Writes (4K pages) - Table
Space
- Total Prefetch Request (4K page) -
Database
- Total Sort Heap In Use (4K page) -
Database
- Total Sort Time (ms) - Database
- Total Sort Time (s) - Connection
- Total Synchronous I/O Time (ms) -
Database
- Total Synchronous I/O Time (ms) -
Table Space
- Total Synchronous I/O (4K pages) -
Database
- Total Synchronous I/O (4K pages) - Table
Space
- Transactions - Connection
- Transactions - Database
- Transactions per Second - Database
- UID SQL (%) - Database
- UOW Lock Wait Time (s) -
Connection
- Update/Insert/Delete SQL - Connection
- Update/Insert/Delete SQL - Database
- Victim Page Cleaners Invoked -
Database