insert data to another machine

mann madhan · #1 (**permalink**) 03-30-10, 08:10

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

ARWinner · #2 (**permalink**) 03-30-10, 08:11

Try export and import.

Andy

mann madhan · #3 (**permalink**) 03-30-10, 08:13

sorry, i want to do it in query itself. In ms sql we can do that in query

ARWinner · #4 (**permalink**) 03-30-10, 08:16

How about supplying more information. What DB2 version and OS are you using?

Andy

mann madhan · #5 (**permalink**) 03-30-10, 08:19

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

ARWinner · #6 (**permalink**) 03-30-10, 08:21

Look in the manuals for "Federation".

Andy

mann madhan · #7 (**permalink**) 03-30-10, 08:25

thanks for the help. i will check it out....

mann madhan · #8 (**permalink**) 03-30-10, 08:55

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

sathyaram_s · #9 (**permalink**) 03-30-10, 09:18

My DB2 UDB Journal: Basic db2 federation setup

Check this out

mdx34 · #10 (**permalink**) 03-30-10, 09:38

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"

mann madhan · #11 (**permalink**) 03-31-10, 00:56

Quote:

Originally Posted by sathyaram_s

My DB2 UDB Journal: Basic db2 federation setup

Check this out

i tried sathyaram suggestion but the warrper is not creating. :-(

dr_te_z · #12 (**permalink**) 03-31-10, 03:57

Quote:

Originally Posted by ARWinner

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.

mann madhan · #13 (**permalink**) 03-31-10, 04:38

i am new to db2. some one guide me to solve this problem

stolze · #14 (**permalink**) 03-31-10, 05:24

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.