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

16 NonStop SQL/MX and RDF
RDF supports replication of NonStop SQL/MX user tables (file code 550) and indexes (file code
552). These operations are supported in much the same way as they are with NonStop SQL/MP,
and the same types of data and DDL operations are replicated.
This chapter describes these operations:
• “Including and Excluding SQL/MX Objects”
• “Summary of ANSI Object Types”
• “Obtaining ANSI Object Names From Updater Event Messages” (page 296)
• “Creating NonStop SQL/MX Primary and Backup Databases From Scratch” (page 296)
• “Creating a NonStop SQL/MX Backup Database From an Existing Primary Database”
(page 299)
• “Online Database Synchronization With NonStop SQL/MX Objects” (page 301)
• “Offline Synchronization for a Single Partition” (page 303)
• “Correcting Incorrect NonStop SQL/MX Name Mapping” (page 305)
• “Consideration for Creating Backup Tables” (page 305)
• “Restoring to a Specific Location” (page 306)
• “Comparing NonStop SQL/MX Tables” (page 308)
Given the way the name mapping works between NonStop SQL/MX objects and their underlying
Guardian file names, there are special considerations when setting up NonStop SQL/MX objects
to be replicated by RDF. This chapter describes those issues.
The command interface for NonStop SQL/MX is MXCI.
Including and Excluding SQL/MX Objects
By default, RDF provides volume-level protection, wherein changes to all audited files and tables
on each protected primary system data volume are replicated to an associated backup system
data volume.
RDF also supports subvolume- and file-level replication. To use this capability, you use INCLUDE
and EXCLUDE clauses when configuring updaters to identify specific database objects you want
replicated or not replicated. INCLUDE and EXCLUDE clauses require the use of Guardian names.
If you have an ANSI-named NonStop SQL/MX object that you want to include or exclude, you
first must get the underlying Guardian name by using the MXGNAMES utility or the MXCI
SHOWDLL command. The use of INCLUDE and EXCLUDE clauses is described in Chapter 11
(page 261).
Summary of ANSI Object Types
Table 16-1 identifies the ANSI object types used by NonStop SQL/MX and their two-character
ANSI name space identifiers.
Table 16-1 ANSI Object Types and Their ANSI Space Name Identifiers
ANSI Name Space IdentifierANSI Object Type
CNConstraint
IXIndex
ILInsert Update Delete
Lock
MDModule
RLRange Lock
Including and Excluding SQL/MX Objects 295