SQL/MX 3.2.1 Management Manual (H06.26+, J06.15+)

Types of Key-Sequenced File Access.....................................................................................32
Key-Sequenced Tree Structure..............................................................................................32
Planning Table and Index Partitioning........................................................................................34
Range Partitioning and Hash Partitioning..............................................................................34
Using Range Partitioning.....................................................................................................34
Using Hash Partitioning......................................................................................................34
Determining a Database Layout................................................................................................35
Using SQL/MX Tables........................................................................................................35
Using Views......................................................................................................................36
Determining When to Use Indexes.......................................................................................37
3 Planning Database Security and Recovery...................................................42
Planning Database Security.....................................................................................................42
Planning Guidelines...........................................................................................................42
Database Access and Security.............................................................................................43
OSS File and Directory Security...........................................................................................43
Safeguard Security.............................................................................................................44
Planning Database Recovery....................................................................................................45
Using Guardian Physical Names for SQL/MX Objects............................................................46
Database Recovery Guidelines............................................................................................46
Recovering Dropped Database Objects................................................................................47
Using TMF for Transaction Recovery, Database Consistency, and Database Recovery......................48
TMF Concepts...................................................................................................................48
Levels of Database Recovery With TMF.................................................................................49
NonStop SQL/MX Requirements for TMF..............................................................................50
Guidelines for Configuring TMF...........................................................................................50
Guidelines for Creating and Managing Online Dumps...........................................................51
Operations That Impact TMF Online Dumps..........................................................................52
Using the TMF DUMP FILES Command.................................................................................53
TMF Considerations in Using MXCI......................................................................................55
Using TMF In Recovery Operations.......................................................................................55
Using RDF to Set Up a Backup System.......................................................................................56
Using Guardian Physical Names for SQL/MX Objects............................................................57
Configuring Disk Volumes for RDF........................................................................................57
Creating RDF Backup Catalogs............................................................................................57
Creating RDF Backup Schemas............................................................................................57
Using Backup and Restore 2 to Create Offline RDF Backup Databases......................................58
Using Backup and Restore 2 for SQL/MX Database Recovery......................................................61
Frequency of Backups.........................................................................................................63
Backup Objects Hierarchy...................................................................................................64
SQL/MX Objects Backed Up Explicitly..................................................................................64
SQL/MX Objects Backed Up Implicitly..................................................................................65
SQL/MX Objects Not Restored by BRCOM...........................................................................66
Other Restrictions on Backup and Restore 2 Operations..........................................................66
Backing Up and Restoring OSS Program Files and SPJs...........................................................66
Using the RESTORE SHOWDDL ON Option to Re-Create Objects............................................67
4 Reviewing and Setting System Defaults........................................................68
Setting and Updating System Defaults.......................................................................................68
Consequences of Inserting Rows Into the SYSTEM_DEFAULTS Table................................................69
System Default Settings to Review After Installing Current Release of SQL/MX ................................69
Alternative Settings for Selected System Defaults.....................................................................69
Settings Required to Achieve ANSI Compliance.....................................................................72
5 Creating an SQL/MX Database.................................................................73
Preparing to Create Your SQL/MX Database.............................................................................73
4 Contents