How to export/import DB2 database

[kjwchu]

I want to export my DB2 version 8 database to another DB2 version 9 database. Can someone tell me the commands to do so? I did research on the net before asking this question but all I found are related to extracting data from a table to an OS file. I want to be able to export a whole database. Thanks for any thoughts.

[SuperKuper]

Research on the net is nice, but reliable information is in DB2 documentation (http://www-1.ibm.com/support/docview...d=swg27009552). There is no concept of "exporting a database" in DB2. You can export one table at a time (see command EXPORT) and IMPORT or LOAD into another database. You can also do a BACKUP for the entire database and RESTORE (perhaps REDIRECTed). You can also set up federated nicknames and LOAD directly from one database to another (also one table at a time).

[kjwchu]

Thanks for correcting me. Could you repost the DB2 documentation link? The link you posted is error.

[docdiesel]

Hi,

for using the link posted by SuperKuper just delete the final ")" in the URL. Besides, there's a way to move parts of or a whole databases from one DB2 to another without using backup/restore. First you'll have to use "db2look" to extract the definitions of the database objects (tables, indexes ,...) and then run the resulting sql/ddl script against the destination database. Then you may move the data by exporting and importing/loading with "db2move".

Have a look at an older post here in bytes.com at http://bytes.com/forum/thread781679-db2move.html . The article at IBM website at http://www-128.ibm.com/developerwork...nyk/index.html may be useful, too.

Regards,

Bernd