Reference material

  • Control Center icons
  • Satellite Administration Center icons
  • Configuration Parameters
  • Database Manager Configuration Parameter Summary
  • Database Configuration Parameter Summary
  • Capacity Management
  • Database Shared Memory
  • Application Shared Memory
  • Agent Private Memory
  • Agent/Application Communication Memory
  • Database Manager Instance Memory
  • Locks
  • I/O and Storage
  • Agents
  • Database Application Remote Interface (DARI)
  • Logging and Recovery
  • Database Log Files
  • Database Log Activity
  • Recovery
  • Distributed Unit of Work Recovery
  • Database Management
  • Query Enabler
  • Attributes
  • DB2 Data Links Manager
  • Status
  • Compiler Settings
  • Communications
  • Communication Protocol Setup
  • Distributed Services
  • DB2 Discovery
  • Parallel
  • Communications
  • Parallel Processing
  • Instance Management
  • Diagnostic
  • Database System Monitor Parameters
  • System Management
  • Instance Administration
  • Data Elements
  • Data 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
  • Process or Thread ID
  • Coordinator Agent
  • Database Manager Configuration
  • Remote Connections To Database Manager
  • Remote Connections Executing in the Database Manager
  • Local Connections
  • Local Connections Executing in the Database Manager
  • Local Databases with Current Connects
  • Connects Since Database Activation
  • Applications Connected Currently
  • Applications Executing in the Database Currently
  • Agents Registered
  • Agents Waiting for a Token
  • Maximum Number of Agents Registered
  • Maximum Number of Agents Waiting
  • Number of Idle Agents
  • Agents Assigned From Pool
  • Agents Created Due to Empty Agent Pool
  • Maximum Number of Coordinating Agents
  • Stolen Agents
  • Maximum Number of Associated Agents
  • Committed Private Memory
  • Secondary Connections
  • Number of Associated Agents
  • Maximum Agent Overflows
  • Total Inactive DRDA Agents
  • Connection Switches
  • Total Sort Heap Allocated
  • Post Threshold Sorts
  • Piped Sorts Requested
  • Piped Sorts Accepted
  • Total Sorts
  • Total Sort Time
  • Sort Overflows
  • Active Sorts
  • Total Hash Joins
  • Hash Join Threshold
  • Total Hash Loops
  • Hash Join Overflows
  • Hash Join Small Overflows
  • FCM Buffers Currently Free
  • Minimum FCM Buffers Free
  • Message Anchors Currently Free
  • Minimum Message Anchors
  • Connection Entries Currently Free
  • Minimum Connection Entries
  • Request Blocks Currently Free
  • Minimum Request Blocks
  • Number of Nodes
  • Connection Status
  • Total FCM Buffers Sent
  • Total FCM Buffers Received
  • Database Configuration
  • Buffer Pool Data Logical Reads
  • Buffer Pool Data Physical Reads
  • Buffer Pool Data Writes
  • Buffer Pool Index Logical Reads
  • Buffer Pool Index Physical Reads
  • Buffer Pool Index Writes
  • Total Buffer Pool Physical Read Time
  • Total Buffer Pool Physical Write Time
  • Database Files Closed
  • Buffer Pool Asynchronous Data Reads
  • Buffer Pool Asynchronous Data Writes
  • Buffer Pool Asynchronous Index Writes
  • Buffer Pool Asynchronous Index Reads
  • Buffer Pool Asynchronous Read Time
  • Buffer Pool Asynchronous Write Time
  • Buffer Pool Asynchronous Read Requests
  • Buffer Pool Log Space Cleaners Triggered
  • Buffer Pool Victim Page Cleaners Triggered
  • Buffer Pool Threshold Cleaners Triggered
  • Buffer Pool Information
  • Bufferpool Name
  • Time Waited for Prefetch
  • Buffer Pool Data Pages to Extended Storage
  • Buffer Pool Index Pages to Extended Storage
  • Buffer Pool Data Pages from Extended Storage
  • Buffer Pool Index Pages from Extended Storage
  • Direct Reads From Database
  • Direct Writes to Database
  • Direct Read Requests
  • Direct Write Requests
  • Direct Read Time
  • Direct Write Time
  • Catalog Cache Lookups
  • Catalog Cache Inserts
  • Catalog Cache Overflows
  • Catalog Cache Heap Full
  • Package Cache Lookups
  • Package Cache Inserts
  • Package Cache Overflows
  • Maximum Package Cache Size
  • Section Lookups
  • Section Inserts
  • Maximum Database Heap Allocated
  • Maximum Secondary Log Space Used
  • Maximum Total Log Space Used
  • Secondary Logs Allocated Currently
  • Number of Log Pages Read
  • Number of Log Pages Written
  • Unit of Work Log Space Used
  • Total Log Space Used
  • Total Log Available
  • Database and Application Activity
  • Locks Held
  • Total Lock List Memory In Use
  • Deadlocks Detected
  • Number of Lock Escalations
  • Exclusive Lock Escalations
  • Lock Mode
  • Lock Status
  • Lock Object Type Waited On
  • Lock Object Name
  • Lock Node
  • Number of Lock Timeouts
  • Maximum Number of Locks Held
  • Connections Involved in Deadlock
  • Lock Escalation
  • Lock Mode Requested
  • Lock Waits
  • Time Waited On Locks
  • Table Space Name
  • Current Agents Waiting On Locks
  • Total Time Unit of Work Waited on Locks
  • Lock Wait Start Timestamp
  • Agent ID Holding Lock
  • Application ID Holding Lock
  • Sequence Number Holding Lock
  • Rolled Back Application
  • Rolled Back Agent
  • Rolled Back Sequence Number
  • Rollforward Timestamp
  • Tablespace Being Rolled Forward
  • Rollforward Type
  • Log Being Rolled Forward
  • Log Phase
  • Number of Rollforward Table Spaces
  • Table Type
  • Table Name
  • Table Schema Name
  • Rows Deleted
  • Rows Inserted
  • Rows Updated
  • Rows Selected
  • Rows Written
  • Rows Read
  • Accesses to Overflowed Records
  • Internal Rows Deleted
  • Internal Rows Updated
  • Internal Rows Inserted
  • Table File ID
  • Page Reorganizations
  • Open Remote Cursors
  • Open Remote Cursors with Blocking
  • Rejected Block Cursor Requests
  • Accepted Block Cursor Requests
  • Open Local Cursors
  • Open Local Cursors with Blocking
  • Static SQL Statements Attempted
  • Dynamic SQL Statements Attempted
  • Failed Statement Operations
  • Commit Statements Attempted
  • Rollback Statements Attempted
  • Select SQL Statements Executed
  • Update/Insert/Delete SQL Statements Executed
  • Data Definition Language (DDL) SQL Statements
  • Internal Automatic Rebinds
  • Internal Commits
  • Internal Rollbacks
  • Internal Rollbacks Due To Deadlock
  • SQL Requests Since Last Commit
  • Statement Node
  • Binds/Precompiles Attempted
  • Statement Type
  • Statement Operation
  • Package Name
  • Section Number
  • Cursor Name
  • Application Creator
  • Statement Operation Start Timestamp
  • Statement Operation Stop Timestamp
  • Event Stop Time
  • Event Start Time
  • Most Recent Statement Elapsed Time
  • SQL Dynamic Statement Text
  • Statement Sorts
  • Number of Successful Fetches
  • SQL Communications Area (SQLCA)
  • Query Number of Rows Estimate
  • Query Cost Estimate
  • Subsection Number
  • Subsection Node Number
  • Subsection Status
  • Subsection Execution Elapsed Time
  • Number of Agents Working on a Subsection
  • Waiting for Any Node to Send on a Tablequeue
  • Waited for Node on a Tablequeue
  • Total Number of Tablequeue Buffers Overflowed
  • Current Number of Tablequeue Buffers Overflowed
  • Number of Rows Read from Tablequeues
  • Number of Rows Written to Tablequeues
  • Maximum Number of Tablequeue Buffers Overflows
  • Waited on Node on a Tablequeue
  • Statement Executions
  • Statement Compilations
  • Statement Worst Preparation Time
  • Statement Best Preparation Time
  • Elapsed Statement Execution Time
  • Number of Agents Working on a Statement
  • Number of Agents Created
  • Degree of Parallelism
  • User CPU Time used by Agent
  • System CPU Time used by Agent
  • User CPU Time used by Statement
  • System CPU Time used by Statement
  • User CPU Time
  • System CPU Time
  • User CPU Time used by Subsection
  • System CPU Time used by Subsection
  • Total System CPU for a Statement
  • Total User CPU for a Statement
  • Last Reset Timestamp
  • Input Database Alias
  • Snapshot Time
  • Number of Nodes in Partition
  • Number of Event Monitor Overflows
  • Time of First Event Overflow
  • Time of Last Event Overflow
  • Byte Order of Event Data
  • Version of Monitor Data
  • Event Monitor Name
  • Partial Record
  • Event Time
  • 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
  • TP Monitor Client User ID
  • TP Monitor Client Workstation Name
  • TP Monitor Client Application Name
  • TP Monitor Client Accounting String
  • Performance Variables Reference
  • Performance variables organized by database object
  • Database Manager Instance
  • Database
  • Connection
  • Table Space
  • Table
  • Performance variables organized by category
  • Agents
  • Buffer Pool and I/O
  • Connections
  • Lock and Deadlock
  • Sort
  • SQL Statement Activity
  • Table
  • UOW
  • Performance variables organized alphabetically
  • General concepts
  • DB2 DB2 Universal Database concepts
  • DB2 UDB for OS/390 concepts
  • Data Warehouse Center concepts
  • Satellite concepts
  • Performance monitoring concepts
  • Visual Explain concepts

    •