Backup and Restore 2 Manual

Contents
Backup and Restore 2 Manual—522696-019
vii
Index
Index
Examples
Example 3-1. INFO CONFIG Command Display 3-2
Example 3-2. INFO JOB Command Display 3-2
Example 7-1. LISTONLY ON Display for OSS Objects 7-8
Example 7-2. LISTONLY DETAIL Display for OSS Objects 7-10
Example 7-3. LISTONLY Display for SQL/MX Objects 7-12
Example 7-4. LISTONLY ON Display with RESTOREDIR for OSS Objects 7-14
Example 8-1. Brief Job Status—Backup Job 8-2
Example 8-2. Brief Job Status—Backcopy Job (H-series Only) 8-2
Example 8-3. Detail Job Status—Backup Job 8-4
Example 8-4. Detail Job Status—Backcopy Job (H-series only) 8-5
Figures
Figure 1-1. Object Hierarchy of the Supported SQL/MX Objects 1-8
Tables
Table 1-1. Restore of Views, Stored procedures, Triggers, and Referential Integrity
Constraints 1-13
Table 3-1. Values for Configuration Options 3-1
Table 4-1. Escape Sequences 4-4
Table 4-2. DEFINEs 4-6
Table 5-1. LISTALL Job Option and OUT Job Option 5-18
Table 6-1. DEFINE Attribute Exceptions for the Backup Command 6-6
Table 6-2. Run Option Exceptions for the BACKUP Command 6-7
Table 6-3.
SQL/MX Filters 6-17
Table 6-4. Backup Job Options 6-20
Table 6-5. Database Structure on Disk 6-45
Table 6-6.
Catalog and Subordinate Objects 6-47
Table 6-7.
Schema and Subordinate Objects Backed Up 6-48
Table 6-8. Table and Subordinate Objects Backed Up 6-48
Table 6-9.
Table Backed Up Including All Table Partitions and Indexes 6-49
Table 6-10.
Individual Table Partitions Backed Up 6-50
Table 6-11.
Indexes Excluded From Backup 6-51
Table 7-1.
Restoring to a Different Target 7-15
Table 7-2. DEFINE Attribute Exceptions for the RESTORE Command 7-17
Table 7-3.
Run Option Exceptions for the RESTORE Command 7-18
Table 7-4.
SQL/MX Filters 7-28
Table 7-5. RESTORE Job Options 7-31