Results 1 to 3 of 3

Thread: export/import

  1. #1
    Join Date
    Jan 2008

    Unanswered: export/import

    How can i export and import a db2 database , I am using db2 v8.1..

    I have one database "test1". It has 10 tables.
    How can I export tables from "test1" and import all these to a newly created database "test2".

    I checked in export/import command of table, but by using this we can exp/imp only single table data at a time. And also the table should me created in the new database.

    In oracle We can export/import all tables,triggers,etc .

    plz help me to do in DB2..thanks to all

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 5
    You need to use db2look to get the ddl to create the tables:

    And db2move to copy the data:


  3. #3
    Join Date
    Jan 2008
    let me check it ....
    thanks .

Posting Permissions

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