Database and Application Activity

The following sections provide information on 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
• 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 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
• 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