DB2 Version 9.7 for Linux, UNIX, and Windows

appl_id_oldest_xact - Application with Oldest Transaction monitor element

The application ID (which corresponds to the agent_id value from the application snapshot) of the application that has the oldest transaction.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Database	dbase	Basic

Usage: This element can help you determine which application has the oldest active transaction. This application can be forced to free up log space. If it is taking up a great deal of log space, you should examine the application to determine if it can be modified to commit more frequently.
There are times when there is not a transaction holding up logging, or the oldest transaction does not have an application ID (for example, indoubt transaction or inactive transaction). In these cases, this application's ID is not returned in the data stream.