Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

What is UOW Waiting in DB2 LIST APPLICATIONS?

1,313 views
Skip to first unread message

Ted

unread,
Nov 29, 2003, 12:09:33 PM11/29/03
to

In doing a db2 list applications show detail, I have 320 entries
applications. Of those sometimes all of them are "UOW Waiting."
Ususally there are from 1 to 4 marked UOW Executing. The rest are
still waiting.

What is meant by "waiting"? We have set TCPCOMMMGR to 4 (16 CPUs). We
have increased IOCLEANERS and IOSERVERS, which had been set to low.
Still the "waiting".

Thanks in advance,
Ted

Ian

unread,
Nov 29, 2003, 2:39:21 PM11/29/03
to

This means that the application is idle (at least as far as the
database is concerned), and is not actively doing any work in the
database.

Good luck,


-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----

Bob Long

unread,
Nov 30, 2003, 12:49:12 PM11/30/03
to
Chances are the programs/queries being executed do not have a terminate
statement.

Sean McKeough

unread,
Dec 1, 2003, 10:11:37 AM12/1/03
to
Ted,

Not sure if your EEE, but...

One thing that can be confusing about list applications, is that by
defalut it will report the app status on the node where the snapshot was
taken. For EEE, this may not represent the 'overall' status of the app
(the app may be active on other nodes, if the snapshot is not taken at
the application coordinator node). You can use a 'db2 list applications
global' to get back the 'overall' status of the app.

0 new messages