Snapshot Information Level Application Lock |
API Structure(s) sqlm_appl_id_info sqlm_appl_lock |
Monitor Group Basic Basic |
Resettable |
No |
|
API 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 Tablespace: The application has detected an I/O error and is attempting to disable a particular tablespace. The application has to wait for all other active transactions on the tablespace to complete before it can disable the tablespace. |
| SQLM_QUIESCE_TABLESPACE | Quiescing a Tablespace: The application is performing a quiesce tablespace request. |
[ Top of Page | Table of Contents | Glossary | Index ]