db2查看连接状态

1.执行命令：db2 list applications show detail

2.可以得到：

CONNECT Auth Id                                                                                                                  Application Name     Appl.      Application Id                                                 Seq#  Number of  Coordinating DB  Coordinator     Status                         Status Change Time         DB Name  DB Path
                                                                                                                                                      Handle                                                                          Agents     partition number pid/thread
-------------------------------------------------------------------------------------------------------------------------------- -------------------- ---------- -------------------------------------------------------------- ----- ---------- ---------------- --------------- ------------------------------ -------------------------- -------- --------------------
DB2AP                                                                                                                            db2jcc_application   296        172.17.248.129.34893.1210240429                                02813 1          0                75047           UOW Waiting                    Not Collected              SAMPLE   /usr/db2ad/db2ad/NODE0000/SQL00001/

DB2AP                                                                                                                            db2jcc_application   763        172.17.248.179.43290.1210240437                                02802 1          0                195067          Commit Active                  Not Collected              SAMPLE   /usr/db2ad/db2ad/NODE0000/SQL00001/

DB2AP                                                                                                                            db2jcc_application   605        172.17.248.178.56811.1210240435                                02805 1          0                154461          Compiling                      Not Collected             SAMPLE   /usr/db2ad/db2ad/NODE0000/SQL00001/

3.状态解释：

Description
Database Connect Pending:==>The application has initiated a database connection but the request has not yet completed. 
Database Connect Completed:==>The application has initiated a database connection and the request has completed. 
Unit of Work Executing:==>The database manager is executing requests on behalf of the unit of work.
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. 
Lock Wait:==>The unit of work is waiting for a lock. After the lock is granted, the status is restored to its previous value. 
Commit Active:==>The unit of work is committing its database changes.
Rollback Active:==>The unit of work is rolling back its database changes.
Recompiling:==>The database manager is recompiling (that is, rebinding) a plan on behalf of the application. 
Compiling:==>The database manager is compiling an SQL statement or precompiling a plan on behalf of the application. 
Request Interrupted:==>An interrupt of a request is in progress.
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. 
Decoupled from Agent:==>The application has been decoupled from an agent. 
Transaction Prepared:==>The unit of work is part of a global transaction that has entered the prepared phase of the two-phase commit protocol.
Transaction Heuristically Committed:==>The unit of work is part of a global transaction that has been heuristically committed.
Transaction Heuristically Rolled Back:==>The unit of work is part of a global transaction that has been heuristically rolled-back.
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.
Creating Database:==>The agent has initiated a request to create a database and that request has not yet completed.
Restarting Database:==>The application is restarting a database in order to perform crash recovery. 
Restoring Database:==>The application is restoring a backup image to the database. 
Backing Up Database:==>The application is performing a backup of the database. 
Data Fast Load:==>The application is performing a "fast load" of data into the database. 
Data Fast Unload:==>The application is performing a "fast unload" of data from the database. 
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. 
Quiescing a Table space:==>The application is performing a quiesce table space request. 
Wait for Remote Partition:==>The application is waiting for a response from a remote partition in a partitioned database instance. 
Remote Request Pending:==>The application is waiting for results from a federated data source. 
Rollback to savepoint:==>The application is rolling back to a savepoint.