Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Location
    Illinois
    Posts
    6

    Unanswered: 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

    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.

  2. #2
    Join Date
    Jul 2008
    Posts
    94

  3. #3
    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.

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    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.7.0.6 os 6.1.0.0

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •