If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Load through Informatica

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-29-09, 15:13
keitht keitht is offline
Registered User
 
Join Date: Jun 2004
Location: Illinois
Posts: 6
Load through Informatica

A user I work with is attempting to use Informatica to load a table on db2 using db2's loader. He is getting the error

Quote:
SQL6024E Table or index "" is not defined on node "0".
I am assuming this is due to the API it is using since I can load the table fine from the local client or from a remote windows client. Does anyone know how to get around this using Informatica? Thanks.
Reply With Quote
  #2 (permalink)  
Old 04-29-09, 22:33
laknar laknar is offline
Registered User
 
Join Date: Jul 2008
Posts: 80
Reply With Quote
  #3 (permalink)  
Old 04-30-09, 10:13
keitht keitht is offline
Registered User
 
Join Date: Jun 2004
Location: Illinois
Posts: 6
Thanks. I've seen that though. The problem is this is coming through Informatica so I don't think we can do the export node command. I seem to remember that you can catalog to connect to a certain node, but can't remember how.
Reply With Quote
  #4 (permalink)  
Old 04-30-09, 13:06
Cougar8000 Cougar8000 is offline
Registered User
 
Join Date: Nov 2005
Location: IL
Posts: 554
Keith,

isn't it the same problem that I was dealing with 2 yrs ago? it is a limitation of Informatica. Table that they are trying to load is not on the node 0. I think 8.6 informatica is able to resolve this issue? I think I dealt with Lisa A at that time.

Call me.
__________________
--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows

DB2 v9.1.0.2 os 5.3.0.0
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On