DB2 Session States

From DB Optimizer
Jump to: navigation, search

DB2 Session States

#define SQLM_INIT 0 /* Performing initialization */
#define SQLM_CONNECTPEND 1 /* connect pending */
#define SQLM_CONNECTED 2 /* connect completed */
#define SQLM_UOWEXEC 3 /* UOW executing */
#define SQLM_UOWWAIT 4 /* UOW waiting */
#define SQLM_LOCKWAIT 5 /* lock wait */
#define SQLM_COMMIT_ACT 6 /* commit active */
#define SQLM_ROLLBACK_ACT 7 /* rollback active */
#define SQLM_RECOMP 8 /* recompiling a plan */
#define SQLM_COMP 9 /* compiling a SQL statement */
#define SQLM_INTR 10 /* request interrupted */
#define SQLM_DISCONNECTPEND 11 /* disconnect pending */
#define SQLM_TPREP 12 /* Prepared transaction */
#define SQLM_THCOMT 13 /* heuristically committed */
#define SQLM_THABRT 14 /* heuristically rolled back */
#define SQLM_TEND 15 /* Transaction ended */
#define SQLM_CREATE_DB 16 /* Creating Database */
#define SQLM_RESTART 17 /* Restarting a Database */
#define SQLM_RESTORE 18 /* Restoring a Database */
#define SQLM_BACKUP 19 /* Performing a Backup */
#define SQLM_LOAD 20 /* Performing a fast load */
#define SQLM_UNLOAD 21 /* Performing a fast unload */
#define SQLM_IOERROR_WAIT 22 /* Wait to disable tablespace */
#define SQLM_QUIESCE_TABLESPACE 23 /* Quiescing a tablespace */
#define SQLM_WAITFOR_REMOTE 24 /* Waiting for remote node */
#define SQLM_REMOTE_RQST 25 /* Pending results from remote request */
#define SQLM_DECOUPLED 26 /* App has been decoupled from coord */
#define SQLM_ROLLBACK_TO_SAVEPOINT 27 /* Rollback to savepoint */