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.