467,118 Members | 916 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,118 developers. It's quick & easy.

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

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
  • viewed: 4626
Share:
1 Reply
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.

Similar topics

4 posts views Thread by New MSSQL DBA | last post: by
10 posts views Thread by Jean | last post: by
2 posts views Thread by TomHorner | last post: by
3 posts views Thread by lauren quantrell | last post: by
1 post views Thread by Chris | last post: by
3 posts views Thread by Bishman | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.