HI,
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 http://www.ibm.com/developerworks/db...ham/index.html 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

You need to use db2look to get the ddl to create the tables:

http://publib.boulder.ibm.com/infoce...e/r0002051.htm

And db2move to copy the data:

http://publib.boulder.ibm.com/infoce...e/r0002079.htm

Andy

let me check it ....
thanks .