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

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

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

    ‏2012-02-29T20:03:05Z  
    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

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

    ‏2012-02-29T20:08:52Z  
    • nivanov1
    • ‏2012-02-29T20:03:05Z
    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.
    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

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

    ‏2012-02-29T20:23:40Z  
    • Joanie
    • ‏2012-02-29T20:08:52Z
    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.
    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 ...