SQL/MP Installation and Management Guide

Contents
HP NonStop SQL/MP Installation and Management Guide—523353-004
iii
4. Planning Database Security and
Recovery (continued)
4. Planning Database Security and Recovery (continued)
Guidelines for Configuring TMF 4-13
Guidelines for Online Dumps 4-15
TMF Considerations in Using SQLCI 4-16
Backup Strategies 4-17
Daily Backups 4-19
Periodic Full Backups 4-20
Daily Timestamp Backups 4-20
Using the FROM CATALOG Option for SQL Objects 4-20
Backing Up Partitions 4-21
Backing Up Indexes 4-22
Backing Up Views 4-22
Backing Up Collations 4-23
Using Volume-Mode or File-Mode Backup 4-24
Using OBEY Command Files for Recovery 4-24
5. Creating a Database
Creating Catalogs 5-1
Catalog Tables 5-2
Requirements for Catalogs 5-4
Design Considerations 5-5
Performance Considerations 5-6
Creating a Catalog 5-6
Securing Catalog Tables 5-7
Securing the System Catalog 5-10
Creating Base Tables 5-10
Determining the Organization of the Physical File 5-11
Determining the Number of Records per Block 5-15
Additional Guidelines for Creating Tables 5-16
Creating Tables on a System That Uses SMF 5-18
Defining Columns 5-19
Creating Table Partitions 5-32
Securing a Base Table 5-37
Creating Views of Base Tables 5-38
Creating a Protection View 5-38
Creating a Shorthand View 5-40
View Security and Underlying Table Security 5-41
Creating Indexes on Base Tables 5-42
Creating an Index 5-42