On DB2 ESE v8, AIX 5.2

Would it be correct for an application snapshot (global) to show a
status of UOW Waiting when it hasn't returned results but is waiting
for subagents to finish?

Thanks,
Rita

"Rita Childress" <ritachildress@sc.rr.com> wrote in message
news:971584bc.0408221404.5761ba62@posting.google.c om...
> On DB2 ESE v8, AIX 5.2
>
> Would it be correct for an application snapshot (global) to show a
> status of UOW Waiting when it hasn't returned results but is waiting
> for subagents to finish?
>
> Thanks,
> Rita
>

I am not sure about your application connection, but most times UOW waiting
seems to mean that a connection exists but there is no current activity
executing.

Thanks for your reply. We have a pmr open on this, db2 support is
saying an executing application can show UOW Waiting while subagents
are working and the coordinating agent is waiting for table queues.
Our understanding was UOW Waiting means DB2 is finished and waiting
for another transaction.


"Mark A" <nobody@nowhere.com> wrote in message news:<RU8Wc.211$jR5.7175@news.uswest.net>...
> "Rita Childress" <ritachildress@sc.rr.com> wrote in message
> news:971584bc.0408221404.5761ba62@posting.google.c om...
> > On DB2 ESE v8, AIX 5.2
> >
> > Would it be correct for an application snapshot (global) to show a
> > status of UOW Waiting when it hasn't returned results but is waiting
> > for subagents to finish?
> >
> > Thanks,
> > Rita
> >
>
> I am not sure about your application connection, but most times UOW waiting
> seems to mean that a connection exists but there is no current activity
> executing.