Migrate DB2 express C Database to Power 6.

[z***@pakre.org.pk]

Hi we have built an application on our testing server and now after purchase of a mainframe we want to want migrate our whole database from DB2 Express C to the new machine (IBM Power 6).

Is there a way to restore the whole database image from DB 2 express C with all the data,i ndexes, sequences and constraints to the new machine?

Would it require manual ddl with csv epxort/imports ?

Thanks and waiting for replies,
Mike.

[blair kenneth adamache]

Please see this topic:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.ha.doc/doc/c0005960.html

If you can't do a backup and restore, then copy the schema with
db2look -e
and use db2move to export the tables and load them into the new database.

Post by z***@pakre.org.pk
Hi we have built an application on our testing server and now after purchase of a mainframe we want to want migrate our whole database from DB2 Express C to the new machine (IBM Power 6).
Is there a way to restore the whole database image from DB 2 express C with all the data,i ndexes, sequences and constraints to the new machine?
Would it require manual ddl with csv epxort/imports ?
Thanks and waiting for replies,
Mike.

[z***@pakre.org.pk]

Hi guys any hints on using db2 move command for this problem ?

[blair kenneth adamache]

There are samples of db2move usage in the sample database:

http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/topic/com.ibm.db2.luw.admin.cmd.doc/doc/r0002079.html

Post by z***@pakre.org.pk
Hi guys any hints on using db2 move command for this problem ?