TMF Operations and Recovery Guide (G06.24+)

Managing SQL Objects
HP NonStop TMF Operations and Recovery Guide—522417-002
C-10
Impact of SQL Operations on Online Dumps
MOVE (simple
move of a
whole partition)
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.
REUSE Does not invalidate
any online dumps of
the reused partition.
Make a new online dump of
the reused partition to retain
TMF file recovery protection.
RESTORE Does not invalidate
any existing online
dumps.
Redo the online dumps of the
restored object to ensure
TMF file recovery protection.
Table C-1. Impact of SQL Operations on TMF Online Dumps (page 3 of 3)
SQL
Statement Option Effect Recovery Strategy