SQL/MX 3.x Installation and Management Guide (H06.22+, J06.11+)

HP NonStop SQL/MX Installation and Management Guide—640325-001
4
6. Reviewing and Setting System Defaults
Creating RDF Backup Catalogs 5-22
Creating RDF Backup Schemas 5-22
Using Backup and Restore 2 to Create Offline RDF Backup Databases 5-23
Using Backup and Restore 2 for SQL/MX Database Recovery 5-27
Frequency of Backups 5-30
Backup Objects Hierarchy 5-31
SQL/MX Objects That Are Backed Up Explicitly 5-31
SQL/MX Objects That Are Backed Up Implicitly 5-33
SQL/MX Objects That Are Not Restored by BRCOM 5-34
Other Restrictions on Backup and Restore 2 Operations 5-34
Backing Up and Restoring OSS Program Files and SPJs 5-35
Using the RESTORE SHOWDDL ON Option to Re-Create Objects 5-36
5-36
6. Reviewing and Setting System Defaults
Setting and Updating System Defaults 6-1
Consequences of Inserting Rows Into the SYSTEM_DEFAULTS Table 6-2
System Default Settings to Review After Installing SQL/MX Release 3.x 6-2
Alternative Settings For Selected System Defaults 6-2
Settings Required to Achieve ANSI Compliance 6-8
7. Creating an SQL/MX Database
Accessing an SQL/MP Database From NonStop SQL/MX 7-2
Preparing to Create Your SQL/MX Database 7-2
SQL/MX Subvolume and File Naming Guidelines 7-2
SQL/MX Subvolume Naming Guidelines 7-3
SQL/MX Data File Naming Guidelines 7-3
Resource Forks 7-4
Designating Wild Cards in SQL/MX Schema Names 7-4
Using the LOCATION Clause 7-4
Using the Subvolume Option in the CREATE SCHEMA Statement 7-5
Correcting File Name Problems 7-6
Creating SQL/MX Metadata 7-6
Creating Catalogs 7-7
Catalog Naming 7-7
Rules for Creating and Dropping Catalogs 7-8
Examples for Creating a Catalog 7-8
Creating Catalogs for Single-Node and Distributed Systems 7-8
Reserved Catalogs 7-8
Creating Schemas 7-9