469,330 Members | 1,379 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,330 developers. It's quick & easy.

How to export/import DB2 database

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.
Apr 4 '08 #1
3 26269
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).
Apr 5 '08 #2
Thanks for correcting me. Could you repost the DB2 documentation link? The link you posted is error.
Apr 6 '08 #3
297 Expert 100+

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.


Apr 7 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Oliver Stratmann | last post: by
7 posts views Thread by phillip.s.powell | last post: by
2 posts views Thread by mike_dba | last post: by
5 posts views Thread by Simon | last post: by
5 posts views Thread by Harris Kosmidhs | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.