This identifier
is incremented whenever a unit of work ends (that
is, when a COMMIT or ROLLBACK terminates a unit of work). Together,
the appl_id and sequence_no uniquely
identify a transaction.
Table 1. Snapshot
Monitoring Information| Snapshot Level |
Logical Data Grouping |
Monitor
Switch |
|---|
| Application |
appl_id_info |
Basic |
| DCS
Application |
dcs_appl_info |
Basic |
Table 2. Event
Monitoring Information| Event Type |
Logical Data Grouping |
Monitor
Switch |
|---|
| Connection |
event_conn |
- |
| Connections |
event_connheader |
- |
| Statements |
event_stmt |
- |
| Transactions |
event_xact |
- |
| Deadlocks |
event_dlconn |
- |
| Deadlocks with Details |
event_detailed_dlconn |
- |
| Deadlocks with Details
History |
event_detailed_dlconn |
- |
| Deadlocks with Details
History |
event_stmt_history |
- |
| Deadlocks with Details History Values |
event_detailed_dlconn |
- |
| Deadlocks with Details History Values |
event_stmt_history |
- |
DB2 Version 9.7 for Linux, UNIX, and Windows