UOW Executing & UOW Waiting - How are they different? Their definition does not show it clearly or I am not getting it, could someone help me to understand? If you can give some examples, it would be great. Here are the definitions from infocenter:
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.
what is the difference between database manager executing and the system executing? what does 'application' mean (is it DB2 or client application like Java?)
UOW Waiting: The application (user, external interface, etc) issued a statement, the database serviced that statement to completion and the database is now waiting on the application to do something else in the same UOW. No Commit or rollback has been issued to end the UOW. Note if the last statement was a commit or rollback, then this means that a new UOW has been started and the database is waiting on the application to do something.
UOW Execution: The application issued a statement to the database which the database is currently executing.