2

I have two IBM DB2 servers at separate remote locations.

I need to copy data from several tables on one database on the first server to another database in the second server.

Previously I've used the IBM data studio tool to export the data and Replace Load it into the other table in the second server.

I am in need of a way to automate this. Probably through command line shell scripts.

How can I accomplish this?

Hannah Vernon ♦
71.1k22 gold badges178 silver badges323 bronze badges
asked Apr 19, 2013 at 13:22

2 Answers 2

1

I think you may have answered your own question. I would use command line shell scripts. Seeing as you are on Linux, you have several to choose from (sh, ksh, and perl to name a few).

Another thing that could make things easier is if you catalog the remote server and database locally. Then you can connect to it and work with it without your script having to worry about ssh'ing over to another box.

answered Apr 22, 2013 at 13:09
1

The LUW flavour of DB2 includes a set of tools known (strangely enough) as "Replication tools". This includes a GUI and CLI based application that can automate the replication of data between Databases. See the IBM Infocenter page for more details.

answered Jun 4, 2013 at 6:57

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.