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

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

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

Apr 2 '06 #1
Share this Question
Share on Google+
1 Reply


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

Apr 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.