SQL/MP Installation and Management Guide

Adding, Altering, Removing, and Renaming
Database Objects
HP NonStop SQL/MP Installation and Management Guide—523353-004
7-24
Splitting, Moving, and Merging Partitions
UNRECLAIMED FREESPACE (F) and INCOMPLETE SQLDDL
OPERATION (D) Flags
A split partition, merge partition, or move partition boundary operation can cause these
flags to be set:
•
UNRECLAIMED FREESPACE (F) indicates that an SQL object contains unusable
space. This flag is set as follows:
°
For the source partition after a move boundary or one-way split operation using
the WITH SHARED ACCESS option completes successfully. Move boundary
operations perform a special partial PURGEDATA request to eliminate the data
from the source partition copied to the target partition. The UNRECLAIMED
FREESPACE flag indicates that space must be deallocated in the partition.
Applications can continue to read and update the table or index, even though
the UNRECLAIMED FREESPACE flag is set, but subsequent ALTER
operations and BACKUP, DUP, or move operations might fail.
To reclaim the space, issue a FUP RELOAD operation for the source partition.
After the UNRECLAIMED FREESPACE flag is reset, you can stop the FUP
RELOAD operation if desired and resume normal activity on the table or index.
(The FUP RELOAD operation reclaims free space first. If you do not stop the
FUP RELOAD operation, it continues with a file reorganization step.) For more
information about stopping a FUP RELOAD operation, see Suspending a
Reorganization Operation on page 8-4.
°
For the target partition, if a move boundary request fails after data is loaded
into the target partition. In this situation, there is free space in the target
partition.
To reclaim the space, issue a FUP RELOAD operation for the target partition
before rerunning the ALTER operation.
•
INCOMPLETE SQLDDL OPERATION (D) indicates one of these two situations:
°
A move partition boundary or merge partition operation using the WITH
SHARED ACCESS option is in progress. The INCOMPLETE SQLDDL
OPERATION flag is set for the target partition during the operation and is reset
when the operation completes successfully.
°
If a merge partition or move partition boundary operation does not complete
successfully because of a processor failure or another reason, the
INCOMPLETE SQLDDL OPERATION flag remains set. In this instance, the
object might contain invalid data and be in a corrupted state.
To recover from this situation, issue an ALTER statement with the RECOVER
INCOMPLETE SQLDDL OPERATION option. After recovering the table or
index, check the UNRECLAIMED FREESPACE flag to see if a FUP RELOAD
operation is needed. Avoid using the object while the INCOMPLETE SQLDDL
OPERATION flag is set; the data cannot be assumed to be accurate.