Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2005

    Unanswered: Migrating data from one db2instance to another

    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 :

    INSERT INTO inst2.table2 SELECT * FROM inst1.table1
    Is this possible in DB2. If so, how can I do it?

    Thanks & regards

  2. #2
    Join Date
    May 2003
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Jan 2005
    You can with Websphere Information Integrator. But if it's infrequent, investigate the db2move utility.

    James Campbell

Posting Permissions

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