RDF System Management Manual for J-series and H-series RVUs (RDF 1.10)

Online Method of Resynchronizing the Primary Database.................................................139
Offline Method of Resynchronizing the Primary Database.................................................139
Reading the Backup Database (BROWSE versus STABLE Access)................................................140
Near Real Time Read Access to Updates on the Primary System.................................................140
Access to Backup Databases with Stable Access.......................................................................141
Stopping TMF on the Primary System..................................................................................141
Using the STOP RDF, DRAIN Command..............................................................................141
STOP UPDATE to a Timestamp...........................................................................................141
RDF and NonStop SQL DDL Operations..................................................................................142
Performing Nonshared Access DDL Operations....................................................................143
Performing Shared Access DDL Operations.........................................................................143
Network Configurations and Shared Access NonStop SQL DDL Operations........................144
RDF and NonStop SQL/MX Operations..................................................................................144
Backing Up Image Trail Files..................................................................................................144
TMF and Online Dumps on the Backup System.........................................................................145
Doing FUP RELOAD Operations With Updaters Running............................................................146
Exception File Optimization....................................................................................................146
Switching Disks on Updater UPDATEVOLUMES.........................................................................146
Online Remirroring of Updater SUBVOLUMES..........................................................................147
6 Maintaining the Databases......................................................................148
Understanding Database States..............................................................................................148
Making Changes to Database Structures.................................................................................150
NonStop SQL/MP or NonStop SQL/MX Databases.............................................................151
Catalog Changes........................................................................................................151
DDL Operations..........................................................................................................151
With Shared Access...............................................................................................151
Without Shared Access...........................................................................................152
Adding a New Column...........................................................................................152
Guidelines for Create Index and Alter Table Move Operations.....................................152
Example for CREATE INDEX With Shared Access.......................................................152
Multiple Indexes on a Single Base Table....................................................................153
Partition Key Changes..................................................................................................154
Table Purges...............................................................................................................154
Enscribe Databases..........................................................................................................154
The STOP TMF Method................................................................................................155
The STOP RDF DRAIN Method......................................................................................155
Resynchronizing Databases....................................................................................................155
Resynchronizing Entire Databases Offline............................................................................156
Resynchronizing Individual Volumes, Tables, and Files Offline................................................156
Resynchronizing Individual Tables or Files Offline.................................................................156
7 Online Database Synchronization.............................................................158
Overview............................................................................................................................158
Synchronizing Entire Databases Online...................................................................................159
Considerations When Synchronizing Entire Databases..........................................................160
Duration and Preparation Issues....................................................................................160
SYNCHDBTIME Issues..................................................................................................161
Enscribe Create Records..........................................................................................161
Stop-RDF-Updater Records.......................................................................................161
TMF Shutdown Records...........................................................................................162
CREATE/LOAD Issues (Step 4, Method 1).......................................................................162
General Considerations for Enscribe Files..................................................................162
Special Consideration for Enscribe Files.....................................................................162
General Considerations for NonStop SQL Tables........................................................163
Enscribe Queue File Issues............................................................................................163
8 Contents