Results 1 to 7 of 7
  1. #1
    Join Date
    May 2007
    somewhere in dbforums

    Unanswered: LOAD or FEDERATION

    I have a specific scenario wherein I have a single server having DB2 UDB v8.2. In this particular server i have 2 databases on 2 separate nodes. Now i want to move data (huge amount of data) from one of these databases to another.

    So i needed to know in this particular scenario which option would be better
    1. Do select from first and then LOAD into the other.
    2. Use federation to load data.

    At this point of time federation seems to be the most logical option for me since data gets transferred from one db to other on the same machine but then i needed to know whether any issues are present which will tilt the balance in favour of using the LOAD method

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    Advantages of the export/load approach:

    1) Fairly easy to do, simple scripts
    2) No extra setup necessary


    1) requires disk space to store the intermediate files
    2) Two step process

    Advantages of using federation

    1) Once setup is complete, simple scripts, one step process
    2) no extra disk space needed


    1) Setup can be tedious and time consuming, but only done once

    Picking which one to use really depends on your particular needs. On the face of it, using export/load might seem the way to go if you have the disk space to spare, but if this will be an on going process, setting up federation might be the way to go since you only have to do it once.


  3. #3
    Join Date
    Apr 2006
    Provided Answers: 11
    if on unix platform you could create a pipe
    export to pipe... and load from same pipe
    no disk space is being used only memory
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified

  4. #4
    Join Date
    Mar 2008
    how to do pipe export? and load from same pipe?
    Pawan Kumar

  5. #5
    Join Date
    Jan 2007
    Jena, Germany
    Everything in UNIX is a file. That holds also true for pipes. So you create a named pipe and export to it - or import/load from it.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    Jul 2003
    Austin, TX, USA

    Named Pipe?

    Please can you explain the same with the help with an example. I understand the concept but am not sure how the same would be represented with the help of commands.

    Will appreciate an syntax based example here.


    Ask the experienced rather than the learned

  7. #7
    Join Date
    May 2007
    somewhere in dbforums

    you may try out this pretty old but pretty good tutorial for named pipes....

Posting Permissions

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