RDF System Management Manual

Table Of Contents
Installing and Configuring RDF
HP NonStop RDF System Management Manual524388-003
3-2
Stopping the Software
2. Prepare your NonStop SQL/MP tables and Enscribe files for RDF protection as
follows:
a. Separate the tables to be protected by RDF from the tables not to be
protected. (This step is recommended but not required.)
b. Set audit compression (the AUDITCOMPRESS file attribute) on for all tables
and files to be protected by RDF. Note that audit compression on is the
creation default for NonStop SQL/MP tables and indexes. Although not
required by RDF, audit compression will enhance RDF performance.
Stopping the Software
After you stop all applications protected by TMF, stop TMF itself by issuing a STOP
TMF command through the TMFCOM interactive interface. (You only need to stop your
applications and TMF if you are going to use the TIMESTAMP parameter of the INIT
RDF command or if you are going to omit the timestamp parameter in all forms). For
information about issuing this and other TMFCOM commands, see the HP NonStop
TMF Reference Manual.
Preparing the Tables and Files
Now prepare your tables and files.
Separating NonStop SQL/MP or NonStop SQL/MX Tables
It is recommended that you avoid registering NonStop SQL/MP or NonStop SQL/MX
tables protected by RDF in the same catalogs as tables that are not protected by RDF.
Separating protected tables from unprotected ones simplifies the comparison of
primary system catalogs with backup system catalogs.
Compressing Audit Data for Tables and Files
Although not required by RDF, using the AUDITCOMPRESS file attribute will enhance
RDF performance. TMF compresses the audit data generated for NonStop SQL/MP
and NonStop SQL/MX tables and Enscribe files for which AUDITCOMPRESS is on.
For applications involving updates of only a few bytes to large existing rows or records,
this audit compression greatly reduces both the amount of audit information the
extractor must read and send to the receiver and the corresponding amount of RDF
traffic on the communications line.
For NonStop SQL/MP and NonStop SQL/MX tables and indexes, AUDITCOMPRESS
is the default. If the value has been changed to NO AUDITCOMPRESS for a table,
you can use an ALTER TABLE command, entered through the NonStop SQL/MP or
NonStop SQL/MX conversational interface, to reset the default value:
ALTER TABLE table-name AUDITCOMPRESS;