SQL6024E Table or index "tab_name" is not defined on node "0".

[db2udbgirl]

Env : DB2 UDB 8.2 / AIX 5.3

When I try to use some DB2 Utilities against a partitioned table which
is not defined on a particular node (Node 0 in this case) I'm getting
this error.

/home/db2udbgirl> db2 load query table ETL.TRANSACTION
SQL6024E Table or index "TRANSACTION" is not defined on node "0".

Hence I would do the following operation as a workaround
/home/db2udbgirl> export DB2NODE=1
/home/db2udbgirl> db2 terminate
DB20000I The TERMINATE command completed successfully.
/home/db2udbgirl> db2 connect to ETLDB

Database Connection Information

Database server = DB2/AIX64 8.2.3
SQL authorization ID = DB2UDBGIRL
Local database alias = ETLDB

/home/db2udbgirl> db2 load query table ETL.TRANSACTION
Tablestate:
Normal

My questions are
[1] What happens internally when a load query table command is issued ?
[2] Is there is any other utilities which depends on Node information ?
(I'm aware of this problem only when I issue a load query table?

Thanks in advance in anticipation of your assistance.
db2udbgirl

[Ian]

db2udbgirl wrote:

Env : DB2 UDB 8.2 / AIX 5.3

When I try to use some DB2 Utilities against a partitioned table which
is not defined on a particular node (Node 0 in this case) I'm getting
this error.

/home/db2udbgirl> db2 load query table ETL.TRANSACTION
SQL6024E Table or index "TRANSACTION" is not defined on node "0".
[deleted]
My questions are
[1] What happens internally when a load query table command is issued ?
Remember that a partitioned instance is somewhat like a bunch of
independent databases "glued" together. LOAD QUERY checks if the
table exists in the current partition - if it does, it reports the
load status.

If the table doesn't exist on the partition, it's the same as if you
query status for a table that doesn't exist in a non-partitioned
instance.
[2] Is there is any other utilities which depends on Node information ?
(I'm aware of this problem only when I issue a load query table?

Lots of things do:

list utilities
list applications
get snapshot
get database configuration
...

Note, IBM has added a "GLOBAL" option to many of these commands that
will aggregate results from all partitions.