Application Status

 
Snapshot Level
Application
Lock

 
Logical Data Grouping
appl_id_info
appl_lock

 
Monitor Switch
Basic
Basic

Resettable

No

Element Name
Element Type

appl_status
information

Description:  The current status of the application.

Usage:  This element can help you diagnose potential application problems. Values for this field are:

API Constant	Description
SQLM_CONNECTPEND	Database Connect Pending:  The application has initiated a database connection but the request has not yet completed.
SQLM_CONNECTED	Database Connect Completed:  The application has initiated a database connection and the request has completed.
SQLM_UOWEXEC	Unit of Work Executing:  The database manager is executing requests on behalf of the unit of work.
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_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_COMMIT_ACT	Commit Active:  The unit of work is committing its database changes.
SQLM_ROLLBACK_ACT	Rollback Active:  The unit of work is rolling back its database changes.
SQLM_RECOMP	Recompiling:  The database manager is recompiling (that is, rebinding) a plan on behalf of the application.
SQLM_COMP	Compiling:  The database manager is compiling an SQL statement or precompiling a plan on behalf of the application.
SQLM_INTR	Request Interrupted:  An interrupt of a request is in progress.
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_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_THCOMT	Transaction Heuristically Committed:  The unit of work is part of a global transaction that has been heuristically committed.
SQLM_THABRT	Transaction Heuristically Rolled Back:  The unit of work is part of a global transaction that has been heuristically rolled-back.
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_CREATE_DB	Creating Database:  The agent has initiated a request to create a database and that request has not yet completed.
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_BACKUP	Backing Up Database:  The application is performing a backup of the database.
SQLM_LOAD	Data Fast Load:  The application is performing a "fast load" of data into the database.
SQLM_UNLOAD	Data Fast Unload:  The application is performing a "fast unload" of data from the database.
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_QUIESCE_TABLESPACE	Quiescing a Table space:  The application is performing a quiesce table space request.
SQLM_WAITFOR_REMOTE	Wait for Remote Node:  The application is waiting for a response from a remote node in a partitioned database instance.