TMF Operations and Recovery Guide (G06.24+)

Managing SQL Objects
HP NonStop TMF Operations and Recovery Guide—522417-002
C-9
Impact of SQL Operations on Online Dumps
MOVE
(simple move)
Deletes the source
partition, thus
invalidating all of its
online dumps
Make a new online dump of
the target partition to retain
TMF file recovery protection.
MOVE
(one-way split)
Invalidates all online
dumps of the source
partition.
Make new online dumps of
the source partition and the
moved partition to retain TMF
file recovery protection.
MOVE
(two-way split)
Invalidates all online
dumps of the source
partition.
Make online dumps of the
new partitions to provide
TMF file recovery protection.
RENAME
(allowed in
SQL/MP only)
Invalidates all online
dumps of the renamed
object.
Make a new online dump of
the renamed object to keep
TMF file recovery protection
for it.
REUSE
PARTITION
Does not invalidate
any existing online
dumps of the partition.
Make a new online dump of
the reused partition to retain
TMF file recovery protection.
CREATE
INDEX
Without option 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
(allowed in
SQL/MX only)
Does not invalidate
any existing online
dumps.
After the population has been
completed, 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.
import
(allowed in
SQL/MX only)
-A option or
empty target
table.
Invalidates any online
dumps of the object
into which data was
imported.
Make a new online dump of
the object into which data
was imported.
MODIFY
INDEX and
MODIFY
TABLE
(allowed in
SQL/MX only)
ADD
PARTITION
Does not invalidate
online dumps of
existing partitions.
Make an online dump of the
new partition.
Table C-1. Impact of SQL Operations on TMF Online Dumps (page 2 of 3)
SQL
Statement Option Effect Recovery Strategy