SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Versioning and Distribution Messages (25000
through 25399)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
20-21
Recovery. Execute the folllowing command on remote_node:
>> DOWNGRADE ALL METADATA TO VERSION 1200
Execute the folllowing command on the local node:
>> RECOVER ALL METADATA RESUME
SQL 25269
Where version-1 is the actual version of the system schema.
Where catalog is the external format ANSI name of the user-specified catalog.
Where version-2 is the user-specified target version for the DOWNGRADE
operation.
Cause. Certain versions of user schemas cannot be represented in a higher version
system schema. A DOWNGRADE of all metadata in a user catalog specified such a
schema version which is lower than the system schema version.
Effect. The operation fails.
Recovery. Either use the DOWNGRADE ALL METADATA command to downgrade all
metadata on the entire system or downgrade the metadata in the system catalog
before downgrading metadata in user catalogs.
SQL 25270
Where version is the actual version of the system schema.
Where node is the Expand node name of the local system.
Cause. Certain versions of user schemas cannot be represented in a higher version
system schema. Such user schemas exist on the system, and an UPGRADE of all
metadata in the system catalog to a higher version was attempted.
Effect. The operation fails.
Recovery. Either use the UPGRADE ALL METADATA command to upgrade all the
metadata on the entire system or upgrade only the metadata in user catalogs before
upgrading metadata in the system catalog.
25269 : The version of the system schema is version-1;
metadata in catalog catalog cannot be downgraded to version
version-2.
25270 The version of the metadata in the system catalog must
remain at version as long as user schemas of that version
exist on node.