SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Utilities

HP NonStop SQL/MX Reference Manual—640322-001

5-123

Example of UPGRADE

This example transforms all the metadata to the /usr/dbadmin/upgradeLog file:

UPGRADE ALL METADATA LOG TO OUTFILE /usr/dbadmin/upgradeLog

CLEAR;

The following is an excerpt from the output file.

*************** Time: <time> Process: <process> Log opened

***************

The UPGRADE ALL METADATA has started

...

Schema XCAT.ASCH will be upgraded from version 1200 to version 3000

Schema YCAT.ASCH will be upgraded from version 1200 to version 3000

Schema YCAT.ZSCH will be upgraded from version 1200 to version 3000

Schema ZCAT.SCH1 will be upgraded from version 1200 to version 3000

Schema ZCAT.SCH2 will be upgraded from version 1200 to version 3000

...

Creating version 3000 definition schema for catalog XCAT

Upgrading version 1200 metadata to version 3000 for affected schemas in

catalog XCAT

Set schema version to 3000 for XCAT.ASCH

Remove XCAT.DEFINITION_SCHEMA_VERSION_1200

Schema XCAT.ASCH has been upgraded from version 1200 to version 3000.

Creating version 3000 definition schema for catalog YCAT

...

Set schema version to 3000 for ZCAT.SCH1

Set schema version to 3000 for ZCAT.SCH2

Schema ZCAT.SCH1 has been upgraded from version 1200 to version 3000.

Schema ZCAT.SCH2 has been upgraded from version 1200 to version 3000.

Remove ZCAT.DEFINITION_SCHEMA_VERSION_1200

The UPGRADE ALL METADATA has completed

Note. The date-time-processid prefix of each line and the output for schemas in the system

catalog are not displayed in the output file. Also, source definition schemas are removed as

part of the operation.