RDF System Management Manual for H-Series RVUs (RDF 1.8)
Table 16-1 ANSI Object Types and Their ANSI Space Name Identifiers (continued)
ANSI Name Space IdentifierANSI Object Type
RGRefresh Group
TATable
TTTemporary Trigger
Table
TRTrigger
URUser Defined Routine
Obtaining ANSI Object Names From Updater Event Messages
Updater event messages list Guardian filenames. If an updater generates an event against an
MX object (subvolume name starts with ZSD), you can obtain the ANSI name of the object by
issuing aFUP INFO guardian-name, DETAIL command.
Creating NonStop SQL/MX Primary and Backup Databases From Scratch
To create a NonStop SQL/MX primary and backup database from scratch, perform these steps:
1. Create the catalog on the primary system:
CREATE CATALOG catalog_name LOCATION optional_Guardian_location;
For example, if issued on the primary system this command creates a catalog named PCAT
on volume $DATA01 on the primary system:
CREATE CATALOG PCAT LOCATION $DATA01;
For the rest of this procedure assume that the name of the primary system is \PNODE, and
the name of the backup system is \BNODE.
2. Create the catalog on the backup system.
The catalog name must be different from that of the primary catalog.
For example, if issued on the backup system this command creates a catalog named BCAT
on volume $DATA01 on the backup system:
CREATE CATALOG BCAT LOCATION $DATA01;
3. If you want each catalog to be seen from both systems, register your primary and backup
catalogs.
To register the primary catalog on the backup system, issue a REGISTER CATALOG
command on the primary system.
To register the backup catalog on the primary system, issue a REGISTER CATALOG
command on the backup system.
The format of the REGISTER CATALOG command is:
REGISTER CATALOG catalog ON node.volume;
Where catalog is the local catalog, node is the remote system where you want the local
catalog registered, and volume is where the local catalog is to be registered on the remote
system.
For example, this command (if executed on the primary system) registers the primary catalog
on volume $DATA00 of the backup system:
REGISTER CATALOG pcat ON \bnode.$data00;
This command (if executed on the backup system) registers the backup catalog on volume
$DATA00 of the primary system:
REGISTER CATALOG bcat ON \pnode.$data00;
296 NonStop SQL/MX and RDF