can we see the query(if any) when the application status is UOWWAIT in spotlight in db2??



Thanks,
Nanaavinash

when status is uow the control is in the application. most of the time last statement is commit.

Hi,

i am confused now.

could you plz explain that the process which is in waiting state.how this can be in commit or rollback operation?



Thanks,
Nana

when executing
db2 list applications show detail
check the status
connect completed - uow waiting - lockwait - executing - performing rollback .....
commit is not a status - when a uow is committed and not disconnected - uow waiting

Thank you very much