SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
P-34
Considerations—PURGE
If SMF is installed on your node, qualified-fileset-list cannot specify any
objects or files on a $*.ZYS*. subvolume.
ALLOWERRORS [ ON | OFF | num ]
specifies the action if errors occur:
If you omit the ALLOWERRORS clause completely, the default is
ALLOWERRORS OFF. If you specify ALLOWERRORS but do not specify an
option, the default is ALLOWERRORS ON.
If a system error causes a user-defined TMF transaction containing the PURGE
command to be rolled back, execution of the PURGE is terminated regardless of
the ALLOWERRORS setting.
[ NO ] LISTALL
specifies whether you want PURGE to display the name of each dropped object in
this form:
object-type $volume.subvol.name PURGED
object-type is COLLATION, FILE, INDEX, PROGRAM, SVIEW, PVIEW, or
TABLE.
LISTALL is the default. If you specify NO LISTALL, PURGE suppresses the display
of confirmations.
SHADOWSONLY
specifies that you want to purge shadow labels within
qualified-fileset-list, but not other objects or files. If you omit
SHADOWSONLY, PURGE does not purge shadow labels. SHADOWSONLY is not
allowed within a user-defined TMF transaction.
Considerations—PURGE

PURGE requires authority to purge objects or files being purged and authority to
read and write to all catalogs that describe objects affected by the purge.
To purge an index, you also must be the generalized owner of the underlying table
and all partitions of that table must be available.
To purge a table, all partitions, indexes, views, and SQL program files that depend
on the table must be available. When you purge any partition of a table, SQL also
purges all other partitions of the table, all constraints defined on the table, all
ON Attempt to purge all specified files and objects regardless of how many
errors are encountered
OFF Stop the purge operation after the first error is encountered
num Purge all specified files and objects until the number of errors
encountered exceeds the value of num