SQL/MP Installation and Management Guide

Adding, Altering, Removing, and Renaming
Database Objects
HP NonStop SQL/MP Installation and Management Guide—523353-004
7-25
Splitting, Moving, and Merging Partitions
Operational Considerations Related to F and D Flags
If an SQL object has the UNRECLAIMED FREESPACE or INCOMPLETE SQLDDL
OPERATION flag set, reset the flag as described previously before backing up,
moving, or duplicating the object. Otherwise, these situations occur:
•
If you attempt to use SQLCI DUP on an object that has either flag set, SQL returns
an error.
•
If you attempt to use BACKUP on an object with the UNRECLAIMED FREESPACE
flag set, SQL returns a warning and backs up the object.
A subsequent RESTORE of the object generates a warning, and SQL restores the
object without the UNRECLAIMED FREESPACE flag set.
Use the FILCHECK utility to determine if unreclaimed free space exists in the
object. If the object has unreclaimed free space, use one of these actions to
correct the problem:
°
Create a new SQL object similar to the one with unreclaimed free space and
use the SQL COPY or LOAD command to load data from the defective object.
°
Use the SQLCI ALTER TABLE <name> PARTONLY MOVE statement to create
a new partition for the data.
•
If you attempt to use BACKUP for the primary partition of an object or for a
secondary partition (using the PARTONLY attribute), and the INCOMPLETE
SQLDDL OPERATION flag is set for the object, one of this occurs:
°
If the IGNORE option is not specified, SQL returns an error and does not back
up the object.
°
If the IGNORE option is specified, SQL returns a warning and backs up the
object.
A subsequent RESTORE of the object operates as follows:
°
If the IGNORE option is not specified, SQL returns an error and does not
restore the object.
°
If the IGNORE option is specified, SQL returns a warning and restores the
object. The newly-restored object does not have the INCOMPLETE SQL DDL
OPERATION flag set. At this point, there is no way to determine whether this
flag had been set.
Caution. Do not run FUP RELOAD to recover the free space in the object; you might cause a
processor to fail.
Note. In the current version of software, if you attempt to use BACKUP for an entire
partitioned table or index and a secondary partition has the INCOMPLETE SQLDDL
OPERATION flag set, SQL backs up (and restores, if requested) the entire table or index
regardless of the flag setting.