Topic
3 replies Latest Post - ‏2012-02-29T20:23:40Z by nivanov1
Joanie
Joanie
3 Posts
ACCEPTED ANSWER

Pinned topic Using IDMT to transfer XML table from DB2 windows to DB2 AIX

‏2012-02-23T19:26:46Z |
I'm trying to use IDMT to transfer a table with XML data from a DB2 windows instance to a DB2 AIX instance. Both instances are V9.7. I'm using pipes. With a regular table (no XML data) I have no problem. With the XML table, it doesn't load - I get this error in the log:
DB21016E The Command Line Processor encountered a system error while sending
the command to the backend process.
DB21018E A system error occurred. The command line processor could not
continue processing.
DB21016E The Command Line Processor encountered a system error while sending
the command to the backend process.
DB21018E A system error occurred. The command line processor could not
continue processing.

Is there something else that needs to be setup to transfer XML data?
Updated on 2012-02-29T20:23:40Z at 2012-02-29T20:23:40Z by nivanov1
  • nivanov1
    nivanov1
    22 Posts
    ACCEPTED ANSWER

    Re: Using IDMT to transfer XML table from DB2 windows to DB2 AIX

    ‏2012-02-29T20:03:05Z  in response to Joanie
    I can't say a lot about this particular IDMT problem, but as a workaround you could try simply EXPORTing table data, then LOADing them into the target table.
    • Joanie
      Joanie
      3 Posts
      ACCEPTED ANSWER

      Re: Using IDMT to transfer XML table from DB2 windows to DB2 AIX

      ‏2012-02-29T20:08:52Z  in response to nivanov1
      I was able to export the data from the old server/load it into the new server, but I'm trying to get it to work through the tool so I can use named pipes. My test table is about 40 GB, but the production version of the table is over 500 GB.
      • nivanov1
        nivanov1
        22 Posts
        ACCEPTED ANSWER

        Re: Using IDMT to transfer XML table from DB2 windows to DB2 AIX

        ‏2012-02-29T20:23:40Z  in response to Joanie
        I see. You can still mimic the same behaviour with EXPORT/LOAD, something like this:

        $ mkfifo /tmp/thepipe
        $ db2 load from /tmp/thepipe of ixf ....
        1. in another session
        $ db2 export to /tmp/thepipe of ixf select ...