Waiting for remote node - Why?

[mcteard]

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

[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"