Upgrading from Version 9.7.1

Back Next

Step 2. Extract MDM Hub Master Database DDLs and Data

Extract the MDM Hub Master Database DDLs and data to the

CMX_SYSTEM.ddl

file.

Change directory to the MDM Hub Master Database directory that you created in Step 1. Create Target Directories.

To extract DDLs and data for the MDM Hub Master Database schema, run the following command:

db2look -d <database name> -ct -z CMX_SYSTEM -e -o CMX_SYSTEM.ddl

The

CMX_SYSTEM.ddl

file is created.

Check the

CMX_SYSTEM.ddl

file for errors.

Update the CONNECT TO statement in the

CMX_SYSTEM.ddl

file to include the user name and password.

Use the following syntax:

CONNECT TO <new database name> USER db2admin USING <password>;

To export data from the MDM Hub Master Database tables, run the following command:

db2move <database name> export -u db2admin -p <password> -sn CMX_SYSTEM > db2move_export_cmx_system.out

The

db2move_export_cmx_system.out

file is created.

Check the

db2move_export_cmx_system.out

file for errors.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.