RDF System Management Manual for H-Series RVUs (RDF 1.8)

Switching Disks on Updater UPDATEVOLUMES.............................................................................145
Online Remirroring of Updater SUBVOLUMES................................................................................145
6 Maintaining the Databases......................................................................................147
Understanding Database States..........................................................................................................147
Backing Up Altered Database Structures...........................................................................................149
NonStop SQL/MP or NonStop SQL/MX Databases......................................................................149
Catalog Changes.......................................................................................................................150
DDL Operations.......................................................................................................................150
DDL Operations Guidelines...............................................................................................150
DDL Operation Example....................................................................................................150
Multiple Indexes on a Single Base Table.............................................................................151
Partition Key Changes..............................................................................................................152
Table Purges.............................................................................................................................152
Enscribe Databases........................................................................................................................152
Resynchronizing Databases................................................................................................................153
Resynchronizing Entire Databases Offline....................................................................................153
Resynchronizing Individual Volumes Offline...............................................................................154
Resynchronizing Individual Tables or Files Offline......................................................................154
7 Online Database Synchronization...........................................................................155
Overview.............................................................................................................................................155
Synchronizing Entire Databases Online.............................................................................................155
Considerations When Synchronizing Entire Databases................................................................157
Duration and Preparation Issues..............................................................................................157
SYNCHDBTIME Issues............................................................................................................158
Enscribe Create Records......................................................................................................158
Stop-RDF-Updater Records................................................................................................158
TMF Shutdown Records.....................................................................................................158
CREATE/LOAD Issues.............................................................................................................158
General Considerations for Enscribe Files..........................................................................159
Special Consideration for Enscribe Files.............................................................................159
General Considerations for NonStop SQL/MP Tables........................................................159
Enscribe Queue File Issues.......................................................................................................160
Different NonStop SQL/MP Product Versions.........................................................................160
Moving Duplicated Tables and Files to the Backup System....................................................160
Example of Synchronizing An Entire Database Online................................................................161
Synchronizing Selected Database Portions Online.............................................................................163
Overview........................................................................................................................................163
Example #1 – Staged Synchronization of an Entire Database..................................................163
Example #2 – Synchronization of an Individual Volume.........................................................163
Example #3 – Synchronization of an Individual File or Partition on a Volume.......................163
Partial Database Synchronization Issues.......................................................................................164
Enscribe Files Without Partitions.............................................................................................164
Key-Sequenced and Relative Files......................................................................................164
Entry-Sequenced and Unstructured Files...........................................................................164
Enscribe Files With Partitions...................................................................................................164
Key-Sequenced Files...........................................................................................................164
Relative Files.......................................................................................................................165
Entry-Sequenced and Unstructured Files...........................................................................165
NonStop SQL/MP Tables Without Partitions...........................................................................165
Key-Sequenced Tables With SYSKEY.................................................................................165
Key-Sequenced Tables Without SYSKEY and Relative Tables............................................165
8 Table of Contents