SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Planning Database Security and Recovery
HP NonStop SQL/MX Installation and Management Guide—523723-004
5-16
Operations That Impact TMF Online Dumps
Table 5-1 summarizes SQL/MX operations that can invalidate online dumps.
Table 5-1. SQL/MX Operations That Impact TMF Online Dumps (page 1 of 2)
Operation Option Effect Recovery Strategy
CREATE INDEX POPULATE
(or no option
specified)
Does not invalidate any
existing online dumps.
Make online dumps of all
partitions of the new index
to provide TMF file
recovery protection.
NO
POPULATE
Does not invalidate any
existing online dumps.
After the population has
been completed through a
separate POPULATE
INDEX command, make
new online dumps of the
new index to provide TMF
file recovery protection.
DUP Does not invalidate any
existing online dumps.
Make online dumps of the
target object after the DUP
operation to ensure TMF
file recovery protection.
(This includes dumps of
the table’s partitions, plus
dumps of partitions
associated with dependent
indexes.)
FIXUP utility -a=on Turns on the audit bit
for the named file. Does
not invalidate any online
dumps.
Make a new online dump
for all the affected files to
provide TMF file recovery
protection.
-a=off Turns off the audit bit
for the named file,
invalidates all online
dumps of the partition.
Online dumps are not
needed until the file’s audit
bit is turned on.
IMPORT utility Turns off the audit bit
for an empty table that
does not have any
dependent indexes,
invalidates online
dumps of all partitions
of this table.
Make new online dumps
for all partitions of the
affected table.
MODIFY utility
(MODIFY INDEX
and MODIFY
TABLE)
ADD
(split range
partition)
(add hash
partition)
Does not invalidate
online dumps of existing
partitions.
Make an online dump of
the new partition to retain
TMF file recovery
protection.