RDF System Management Manual for H-Series and J-Series RVUs (RDF 1.9)

16 NonStop SQL/MX and RDF...................................................................................323
Including and Excluding SQL/MX Objects.........................................................................................323
Creating NonStop SQL/MX Primary and Backup Databases.............................................................323
Creating a NonStop SQL/MX Backup Database From an Existing Primary Database......................326
Online Database Synchronization With NonStop SQL/MX Objects..................................................328
Creating the Fuzzy Copy on the Primary System.........................................................................328
Creating the Fuzzy Copy on the Backup System..........................................................................330
Offline Synchronization for a Single Partition....................................................................................330
Directly From the Primary to the Backup......................................................................................330
Indirectly From the Primary to the Backup By Way of a Temporary File.....................................331
Backup Partition Does Not Already Exist.....................................................................................331
Online Synchronization for a Single Partition....................................................................................331
Correcting Incorrect NonStop SQL/MX Name Mapping...................................................................332
Primary and Backup ANSI Catalog Are the Same........................................................................332
Primary and Backup ANSI Schema Names Are Not the Same.....................................................332
Schema Subvolume Names Are Not the Same..............................................................................332
Guardian Filename Is Incorrect for Partition.................................................................................332
Consideration for Creating Backup Tables.........................................................................................333
Restoring to a Specific Location..........................................................................................................333
Example.........................................................................................................................................333
Comparing NonStop SQL/MX Tables.................................................................................................335
17 Zero Lost Transactions (ZLT).....................................................................................337
How It Works......................................................................................................................................337
Using CommitHoldMode...................................................................................................................340
Hardware Setup..................................................................................................................................340
Assigning CPUs on the Standby System............................................................................................340
RDF Configuration Attributes............................................................................................................341
RDF Remote Mirror Configuration...............................................................................................341
RDF Remote Standby Configuration.............................................................................................341
RDF Configuration Record Validation..........................................................................................341
Extractor Audit-Trail Configuration..............................................................................................341
ALTER RDF Remote Mirror Configuration...................................................................................342
ZLT Takeover Operations...................................................................................................................342
Phase 1 (ZLT Processing)...............................................................................................................342
The Audit-Fixup Process..........................................................................................................343
Phase 2 (Takeover Processing).......................................................................................................343
ZLT Events.....................................................................................................................................343
Error Conditions............................................................................................................................343
STATUS RDF..................................................................................................................................343
RDFCOM INFO and SHOW Commands......................................................................................344
Old Audit-Trail Files......................................................................................................................344
Recovering the Primary System After an RDF ZLT Takeover............................................................344
ZLT and RDF Networks......................................................................................................................346
STOP TMF Operations........................................................................................................................346
During Normal Operations...........................................................................................................346
During ZLT Takeover Processing..................................................................................................346
SQL Shared Access DDL Operations..................................................................................................347
A RDF Commands Quick Reference............................................................................349
RDFCOM Run Syntax.........................................................................................................................349
RDFCOM Commands Quick Reference.............................................................................................349
ADD...............................................................................................................................................349
Table of Contents 17