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

Contents

HP NonStop SQL/MX Installation and Management Guide—640325-001

6. Reviewing and Setting System Defaults

Guidelines for Creating and Managing Online Dumps 5-14

Operations That Impact TMF Online Dumps 5-15

Using the TMF DUMP FILES Command 5-17

TMF Considerations in Using MXCI 5-19

Using TMF In Recovery Operations 5-20

Using RDF to Set Up a Backup System 5-21

Using Guardian Physical Names for SQL/MX Objects 5-21

Configuring Disk Volumes for RDF 5-22

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