Results 1 to 15 of 15
  1. #1
    Join Date
    Mar 2010
    Posts
    15

    Unanswered: insert data to another machine

    Hai all,
    i want to retrive a data from local machine and insert the data's into another machine help meeeeeeeeee

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Try export and import.

    Andy

  3. #3
    Join Date
    Mar 2010
    Posts
    15
    sorry, i want to do it in query itself. In ms sql we can do that in query

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    How about supplying more information. What DB2 version and OS are you using?

    Andy

  5. #5
    Join Date
    Mar 2010
    Posts
    15
    i am using v9.5 in windows 2003. i have to retrive the data from local machine and insert the data's into another machine.i have use only query, help me it is very urgent

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look in the manuals for "Federation".

    Andy

  7. #7
    Join Date
    Mar 2010
    Posts
    15
    thanks for the help. i will check it out....

  8. #8
    Join Date
    Mar 2010
    Posts
    15
    i tried. i cann't understand. can you help me...
    server A
    os : windows 2003
    database : db2
    version : 9.5
    ip : 192.168.1.31
    Table : TableA
    username :clientusername1
    password :clientpassword1
    server B
    os : windows 2003
    database : db2
    version : 9.5
    ip : 192.168.1.32
    Table :TableB
    username :clientusername1
    password :clientpassword1

    i want to insert the data from serverA.tableA to serverB.tableB.. kindly help
    Last edited by mann madhan; 03-31-10 at 01:22.

  9. #9
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  10. #10
    Join Date
    Oct 2004
    Posts
    268
    You can not do that in SQL Server's Query Analyzer unless you add a Linked server. Either use export/Import or do what sathyaram suggesting you.

    Here is a simple syntax for export/import

    db2 "export to tableA.ixf of ixf messages msgs.txt select * from tableA"

    Copy the files created from above statement to serverB and run below statement.

    db2 "import from tableA.ixf of ixf insert into tableB"

  11. #11
    Join Date
    Mar 2010
    Posts
    15
    Quote Originally Posted by sathyaram_s View Post
    i tried sathyaram suggestion but the warrper is not creating. :-(

  12. #12
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by ARWinner View Post
    Look in the manuals for "Federation".Andy
    Yes. This in combination with "load from cursor" gives the best results. Believe me: "been there".
    Not for you topicstarter (you're on windows) but when you're on unix/linux you can export/load thru a named-pipe. Also very fast!

    and topicstarter: go thru the history of this forum. Bella (db2girl) and me have posted a few times on this "federated" subject.
    Last edited by dr_te_z; 03-31-10 at 05:01.

  13. #13
    Join Date
    Mar 2010
    Posts
    15
    i am new to db2. some one guide me to solve this problem

  14. #14
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Seriously: the referenced documents describe rather detailed how to set up federation and how to use it. I guess we cannot really help you any further if you don't provide more detailed information like what exactly you tried, which error messages are returned, and so on.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  15. #15
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by mann madhan View Post
    i am new to db2. some one guide me to solve this problem
    IF you are located in the Netherlands
    THEN hire me for a day or 2
    ELSE hire one of my collegues
    END-IF

    In my earlier post I referenced to this: http://www.dbforums.com/db2/1646192-...nning-aix.html

Posting Permissions

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