Upgrading the metadata after system upgrade

UPGRADE is a syntax-based utility command that can be executed from MXCI. The UPGRADE command transforms the metadata from the existing version to the current schema version for the SQL/MX Software Version (MXV). For more information, see the SQL/MX Reference Manual.

The following describes the 3.5 features and limitations related to upgrading the database, which includes physical data files and all related objects.

  • An upgrade of older version metadata (v1200 schemas, v3000 schemas, v3100 schemas, v3200 schemas, v3400 schemas) to v3500 is supported.

  • Databases created on release 2.x (v1200 schemas) are not generally supported. The metadata upgrade is mandatory.

  • Databases created on previous releases of SQL/MX (v3000 schemas, v3100 schemas, v3200 schemas, v3400 schemas) are supported. In this case, the metadata upgrade is optional.

    • v3500 schemas can be created in new catalogs without having to upgrade existing metadata.

    • New schemas in an existing, non-empty catalog will be of the same version as the existing schemas in the catalog. The version of a new schema in an empty catalog will be 3500, unless the CREATE_DEFINITION_SCHEMA_VERSION CQD is set to another supported version.

    WARNING:

    If you are using MXDM client, and to continue to use it with R3.5, you must upgrade the schema to minimum v3200 version as the minimum supported metadata schema version for MXDM is 3200.