Migrating data from one db2instance to another

arulmani · #1 (**permalink**) 03-03-05, 23:42

I have two db2 instances (inst1, inst2) each with its own set of tables. Is there a way of migrating data from one db2 instance to another?

What I would eventually like to do is something like :

Code:

INSERT INTO inst2.table2 SELECT * FROM inst1.table1

Is this possible in DB2. If so, how can I do it?

Thanks & regards
Arulmani

Marcus_A · #2 (**permalink**) 03-04-05, 01:24

You would have to setup DB2 Federated support if you have an SQL statement which needs to recognize a table in an different database than the one you are connected to. This is true regardless of whether the database is in the same instance or a different instance.

You could also do exports and imports of the data. If you want to automate the export and import of a large group of tables, you can use db2move command.

You can also do a redirected restore of a backup.

jacampbell · #3 (**permalink**) 03-04-05, 01:46

You can with Websphere Information Integrator. But if it's infrequent, investigate the db2move utility.

James Campbell

Internet Services

Web Development

Digital Marketing

Consumer Tech