By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,236 Members | 1,292 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,236 IT Pros & Developers. It's quick & easy.

Waiting for remote node - Why?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.