db2move to copy data between databases

09 July,2010 by Jack Vamvas

I need to move ddl and data from one database to another . On the same server and instance.

The basic idea was going to be :
a)using db2move export all ddls and data into a file
b)using db2move import the ddls and data

STEP 1

--this exports all tables and data, the output files are stored in the current directory , I used /tmp
db2move MYDB export
--output 
Application code page not determined, using ANSI codepage 1208
***** DB2MOVE *****
Action: EXPORT
Start time: Fri Jul 9 13:47:29 2010


Connecting to database MYDB ... successful! Server : DB2 Common Server V9.1.4
Binding package automatically ... /MTSCHEMA/sqllib/bnd/db2common.bnd ... successful!
Binding package automatically ... /MTSCHEMA/sqllib/bnd/db2move.bnd ... successful!
EXPORT: 76836 rows from table "MTSCHEMA "."TABLE1 "
Disconnecting from database ... successful!

STEP 2

--as I had remained on /tmp - the command below dealt with this automatically
db2move MYDB import

Author: Jack Vamvas(http://www.dba-db2.com)

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on db2move to copy data between databases

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright