Application Identification and Status

The following elements provide information about databases and their related applications.

• Application Handle (agent ID)
• Application Status
• ID of Code Page Used by Application
• Application Status Change Time
• 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
• Connection Request Completion Timestamp
• Maximum Number of Concurrent Connections
• Previous Unit of Work Completion Timestamp
• Unit of Work Start Timestamp
• Unit of Work Stop Timestamp
• Unit of Work Completion Status
• Previous Transaction Stop Time
• Application Idle Time
• Process or Thread ID
• 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
• TP Monitor Client User ID
• TP Monitor Client Workstation Name
• TP Monitor Client Application Name
• TP Monitor Client Accounting String
• Inbound Number of Bytes Received
• Host Response Time
• Most Recent Response Time for Connect
• Most Recent Connection Elapsed Time
• Communication Errors
• Communication Error Time
• Most Recent Statement Elapsed Time
• Statement Executions
• Statement Compilations
• Statement Worst Preparation Time
• Statement Best Preparation Time
• Most Recent Unit of Work Elapsed Time
• Elapsed Statement Execution Time
• Number of Nodes in Partition
• Total Log Space Used
• Total Log Available
• Lock Mode Requested
• Application with Oldest Transaction
• Total Inactive DRDA Agents
• Connection Switches