SQL/MX 3.1 Database and Application Migration Guide (H06.23+, J06.12+)

Considerations for upgrading to SQL/MX Release

3.1

HP NonStop SQL/MX Release 3.1 Database and Application Migration Guide—663853-001

2-6

New metadata in SQL/MX Release 3.1

The change of ownership and separation of privileges features require new metadata

tables to store privilege information. These new metadata tables are created when

SQL is initialized on SQL/MX Release 3.1 or when the metadata is upgraded. The

UPGRADE command creates the SYSTEM_SECURITY_SCHEMA in the system catalog,

and then creates and initializes the tables in that schema. When you downgrade the

metadata, the SYSTEM_SECURITY_SCHEMA and the tables it contains will be removed.

You can downgrade to v1200 and v3000 schemas.

Note. If the downgrade operation fails, you can use the RECOVER command to undo the

effects of the failed downgrade. However, the contents of the tables in the

SYSTEM_SECURITY_SCHEMA might be lost.