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

Planning Database Security and Recovery
HP NonStop SQL/MX Installation and Management Guide—544536-007
5-16
Operations That Impact TMF 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.)
Fastcopy Invalidates online
dumps for the target
tables and target
indexes.
Make online dumps of the
target object after the
fastcopy operation to
ensure TMF file recovery
protection. (This includes
dumps of the table’s
partitions, and 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.