Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2009
    Posts
    153

    Unanswered: Server to server data transfer

    Hi Experts,

    Is it possible to insert data from one table in a server to another server into a table having same structure?

    Is it possible to achive using SELECT statement?

    TIA

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Yes, by means of "federation". When you can select data from a db2-table residing on another db2-database you van just as easy code a "load from cursor" of a "insert from select...).

  3. #3
    Join Date
    Jan 2009
    Posts
    153
    I have succesfully tried load and insert into select statements from one db to another but i want to know how can i achive the same in different db's residing in different physical machines.

  4. #4
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    dr_te already gave you the answer. Look up federation.
    --
    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
  •