Upgrading from Version 9.7.1

10.3

Back Next

Step 3. Extract Operational Reference Store DDLs and Data

Extract the Operational Reference Store DDLs and data to the

<Operational Reference Store name>.ddl

file.

Change directory to the target Operational Reference Store directory that you created.

To extract DDLs and data for the Operational Reference Store schema, run the following command:

db2look -d <database name> -ct -z <Operational Reference Store name> -e -o <Operational Reference Store name>.ddl

The

<Operational Reference Store name>.ddl

file is created.

Check the

<Operational Reference Store name>.ddl

file for errors.

Update the CONNECT TO statement in the

<Operational Reference Store name>.ddl

file to include the user name and password.

Use the following syntax:

CONNECT TO <new database name> USER <Operational Reference Store name> USING <password>;

To extract granted privileges for the Operational Reference Store tables, run the following command:

db2look -d <database name> -x -z <Operational Reference Store name> -o <Operational Reference Store name>2.ddl

The

<Operational Reference Store name>2.ddl

file is created.

Check the

<Operational Reference Store name>2.ddl

file for errors.

Edit the following line in the

<Operational Reference Store name>2.ddl

file:

Change from.

CONNECT TO <database name>;

Change to.

CONNECT TO <new database name> USER <Operational Reference Store name> USING <password>;

To export data from the Operational Reference Store tables, run the following command:

db2move <database name> export -u db2admin -p <password> -sn <Operational Reference Store name> > db2move_export_<Operational Reference Store name>.out

The

db2move_export_<Operational Reference Store name>.out

file is created.

Check the

db2move_export_<Operational Reference Store name>.out

file for errors.

Migrate Databases to IBM DB2 with Oracle-compatibility Disabled

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

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

Rename Saved Search

Table of Contents

Upgrading from Version 9.7.1

Upgrading from Version 9.7.1

Step 3. Extract Operational Reference Store DDLs and Data

Step 3. Extract Operational Reference Store DDLs and Data