RDF/IMP and IMPX System Management Manual (RDF 1.3+)

Preparing the RDF Environment
Compaq NonStop™ RDF/IMP and IMPX System Management Manual—522204-001
2-8
Designing Transactions for RDF Protection
SQL/MP DDL Operations
Although RDF replicates SQL/MP Data Manipulation Language (DML) operations, it
does not replicate SQL/MP Data Definition Language (DDL) operations except for
PURGEDATA. Excluding PURGEDATA, the database administrator needs to perform
all other DDL operations manually on the backup system as well as on the primary
system. These other SQL/MP DDL operations include:
User programs cannot create audited SQL/MP tables and write to them without
coordinating table creation on the primary system with table creation on the backup
system.
Recommended procedures for performing SQL/MP DDL operations in an RDF
environment are described under SQL/MP Databases
in Section 6.
Enscribe File-Label Modifications
In general, RDF does not replicate Enscribe file-label modifications.
File-label modifications in Enscribe are similar to DDL operations in SQL/MP in that
the modifications do not manipulate the file itself. Instead, file-label modifications alter
attributes of the file, such as the file code, the security, the extent size, and the audit
setting.
The only file-label modifications that RDF replicates are the following:
Purge Operations
The two kinds of purge operations are PURGEDATA and PURGE. RDF replicates
PURGEDATA operations for both SQL tables and Enscribe files, but does not replicate
any PURGE operations.
ALTER CATALOG ALTER VIEW RENAME CREATE INDEX
ALTER INDEX CREATE CATALOG CREATE TABLE
ALTER TABLE CREATE CONSTRAINT CREATE VIEW
DROP CATALOG DROP INDEX DROP VIEW
DROP CONSTRAINT DROP TABLE UPDATE STATISTICS
CREATE To create an audited Enscribe file
ALTER MAXEXTENTS To increase the number of extents for an audited Enscribe
file
PURGEDATA To purge data from an audited Enscribe file