SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Contents

HP NonStop SQL/MX Installation and Management Guide—544536-007

5. Planning Database Security and

Recovery (continued)

5. Planning Database Security and Recovery (continued)

Guidelines for Configuring TMF 5-13

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-32

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

Rollback of DP2 Large Block 5-37

Fixup of Tables with Referential Integrity Constraints 5-38

6. Reviewing and Setting System Defaults

Setting and Updating System Defaults 6-1

Consequences of Inserting Rows Into the SYSTEM_DEFAULTS Table 6-2

New System Defaults for SQL/MX Release 2.0 6-3

New System Default for SQL/MX Release 2.1 6-5

New System Default for SQL/MX Release 2.3.3 6-6

System Default Settings to Review After Installing SQL/MX Release 2.x 6-7

Alternative Settings For Selected System Defaults 6-7

Settings Required to Achieve ANSI Compliance 6-13

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