DB2 Version 9.7 for Linux, UNIX, and Windows

appl_status - Application Status monitor element

The current status of the application.

Table 1. Snapshot Monitoring Information
Snapshot Level	Logical Data Grouping	Monitor Switch
Application	appl_id_info	Basic
Lock	appl_lock_list	Basic

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Locking	-	-
Connection	event_conn	-

Usage

For a locking event monitor's lock wait, lock timeout, or deadlock event, the lock requester reports the appl_status value that was in effect before entering lock wait status rather than the current lock wait status.

This element can help you diagnose potential application problems. Values for this field are listed in the following table.

API Constant	Description
SQLM_AUTONOMOUS_WAIT	Autonomous Wait: The application is waiting for an autonomous routine to complete.
SQLM_BACKUP	Backing Up Database: The application is performing a backup of the database.
SQLM_COMMIT_ACT	Commit Active: The unit of work is committing its database changes.
SQLM_COMP	Compiling: The database manager is compiling an SQL statement or precompiling a plan on behalf of the application.
SQLM_CONNECTED	Database Connect Completed: The application has initiated a database connection and the request has completed.
SQLM_CONNECTPEND	Database Connect Pending: The application has initiated a database connection but the request has not yet completed.
SQLM_CREATE_DB	Creating Database: The agent has initiated a request to create a database and that request has not yet completed.
SQLM_DECOUPLED	Decoupled from Agent: There are no agents currently associated with the application. This is a normal state. When the Connection Concentrator is enabled, there is no dedicated coordinator agent, so an application can be decoupled on the coordinator partition. In non-concentrator environments, an application cannot be decoupled on the coordinator partition as there will always be a dedicated coordinator agent .
SQLM_DISCONNECTPEND	Database Disconnect Pending: The application has initiated a database disconnect but the command has not yet completed executing. The application may not have explicitly executed the database disconnect command. The database manager will disconnect from a database if the application ends without disconnecting.
SQLM_INTR	Request Interrupted: An interrupt of a request is in progress.
SQLM_IOERROR_WAIT	Wait to Disable Table space: The application has detected an I/O error and is attempting to disable a particular table space. The application has to wait for all other active transactions on the table space to complete before it can disable the table space.
SQLM_LOAD	Data Fast Load: The application is performing a "fast load" of data into the database.
SQLM_LOCKWAIT	Lock Wait: The unit of work is waiting for a lock. After the lock is granted, the status is restored to its previous value.
SQLM_QUIESCE_TABLESPACE	Quiescing a Table space: The application is performing a quiesce table space request.
SQLM_RECOMP	Recompiling: The database manager is recompiling (that is, rebinding) a plan on behalf of the application.
SQLM_REMOTE_RQST	Federated request pending: The application is waiting for results from a federated data source.
SQLM_RESTART	Restarting Database: The application is restarting a database in order to perform crash recovery.
SQLM_RESTORE	Restoring Database: The application is restoring a backup image to the database.
SQLM_ROLLBACK_ACT	Rollback Active: The unit of work is rolling back its database changes.
SQLM_ROLLBACK_TO_SAVEPOINT	Rollback to savepoint: The application is rolling back to a savepoint.
SQLM_TEND	Transaction Ended: The unit of work is part of a global transaction that has ended but has not yet entered the prepared phase of the two-phase commit protocol.
SQLM_THABRT	Transaction Heuristically Rolled Back: The unit of work is part of a global transaction that has been heuristically rolled-back.
SQLM_THCOMT	Transaction Heuristically Committed: The unit of work is part of a global transaction that has been heuristically committed.
SQLM_TPREP	Transaction Prepared: The unit of work is part of a global transaction that has entered the prepared phase of the two-phase commit protocol.
SQLM_UNLOAD	Data Fast Unload: The application is performing a "fast unload" of data from the database.
SQLM_UOWEXEC	Unit of Work Executing: The database manager is executing requests on behalf of the unit of work.
SQLM_UOWQUEUED	Unit of Work queued (Version 9.7 Fix Pack 1 and later): The unit of work is queued, waiting for another activity to complete execution. The unit of work is queued because the threshold for the number of concurrently executing activities has been reached. For more information, see Activity queuing.
SQLM_UOWWAIT	Unit of Work waiting: The database manager is waiting on behalf of the unit of work in the application. This status typically means that the system is executing in the application's code.
SQLM_WAITFOR_REMOTE	Pending remote request: The application is waiting for a response from a remote partition in a partitioned database instance.