RDF/IMP, IMPX, and ZLT System Management Manual

Preparing the RDF Environment
HP NonStop RDF/IMP, IMPX, and ZLT System Management Manual—524388-002
2-9
Designing Transactions for RDF Protection
•
Database operations not replicated by RDF
The subsections that follow explain these restrictions.
Replicating Database Operations
Database administrators preparing to work with RDF should be aware of
considerations concerning:
•
NonStop SQL/MP Data Definition Language (DDL) operations
•
Enscribe file-label modifications
•
Purge operations
•
Partitioned files
•
Temporary disk files
NonStop SQL/MP DDL Operations
Although RDF replicates NonStop SQL/MP Data Manipulation Language (DML)
operations, it does not replicate NonStop 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 NonStop SQL/MP DDL
operations include:
User programs cannot create audited NonStop 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 NonStop SQL/MP DDL operations in an
RDF environment are described under NonStop 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 NonStop 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.
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