如何释放Connect Completed 与 UOW Waiting
aix + db2 v9.5
db2 list applications show detail
看到的Connect Completed 与 UOW Waiting
问一下：
这两个的具体区别在哪里？
Connect Completed 可以用db2 terminate释放，那UOW Waiting呢？
db2 list applications show detail
看到的Connect Completed 与 UOW Waiting
问一下：
这两个的具体区别在哪里？
Connect Completed 可以用db2 terminate释放，那UOW Waiting呢？
7同行回答
浏览3886
楼上正解。。。收起
浏览3781
浏览4147
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.收起
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.收起
浏览4190
Database Connect Completed:==>The application has initiated a database connection and the request has completed.
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.收起
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.收起
浏览3813