470,647 Members | 1,099 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

Waiting for remote node - Why?

I am running a 9 node system using DB2 v8.2 on AIX v5.3. When listing
applications using Control Centre I often see one with status "Waiting
for remote node". A snapshot of the locks shows no lock waits. Any
ideas on how I can investigate this?
Derek

Oct 11 '06 #1
1 5919
Ian
mcteard wrote:
I am running a 9 node system using DB2 v8.2 on AIX v5.3. When listing
applications using Control Centre I often see one with status "Waiting
for remote node". A snapshot of the locks shows no lock waits. Any
ideas on how I can investigate this?
Derek
You're seeing the status on the coordinator node, which is doing exactly
what you see - "waiting for remote node".

The other partitions are doing the work, and when they complete they
send data to the coordinator, which combines the results and returns
them to the client.

Of course, I'm making an assumption about how your system is configured
(i.e. the first partition typically is the catalog/coordinator, and the
other partitions hold the real data).

If you look at the other partitions you'll probably see 'UOW Executing'
or similar.

The logical question is, "how do I see this in Control Center?", and
unfortunately I have no idea. I don't find Control Center particularly
useful for monitoring, so I'll typically drop out to the command line.
For example:

db2_all "<<+4< db2 list applications show detail"
Oct 11 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Lamont | last post: by
1 post views Thread by Raquel | last post: by
3 posts views Thread by Terry | last post: by
2 posts views Thread by Douglas Harber | last post: by
10 posts views Thread by mairhtin o'feannag | last post: by
1 post views Thread by Korara | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.