File Utility Programming (FUP) Reference Manual

FUP Commands
File Utility Program (FUP) Reference Manual523323-015
2-65
Commands Related to CREATE
Commands Related to CREATE
DEALLOCATE
Deallocates any file extents beyond the one that includes the end-of-file (EOF) address
of the specified disk files. This command applies only to Enscribe files.
fileset-list
is a list of files whose unused extents (beyond the EOF extent) are to be
deallocated. If a file has the CLEARONPURGE option set, the data is physically
deleted from the deallocated extents. You can specify qualified-fileset for
this fileset-list.
PARTONLY
specifies the deallocation of any unused extents for all the primary or secondary
partitions of partitioned files in fileset-list. If you reference a primary partition
name, only the extents are deallocated from the primary partition. If you omit
PARTONLY, extents are deallocated only for entire partitioned files, the primary
partition must be specified in fileset-list, and it is an error to reference a
secondary partition in fileset-list. PARTONLY has no effect on
nonpartitioned files.
DEALLOCATE Guidelines
DP2 does not let unused extents of audit-trail files be deallocated. Audit-trail files
are identified by file code 134. Any attempt to deallocate unused extents of audit-
trail files are rejected with file-system error 2 (operation not allowed on this type of
file). To let FUP continue after receiving such errors, use the FUP ALLOW
ERRORS command.
DEALLOCATE works only with SQL files that are SQL object files. On other SQL
files, you must use SQLCI ALTER instead.
If you specify the CLEARONPURGE option (with the SECURE command) for a
file, a subsequent DEALLOCATE command physically clears the data from the
deallocated extents of the file.
COMMAND Function Page
ALTER Modifies attributes of a file 2-10
RESET Resets default file attributes or CONFIG[URE] options 2-164
SET Sets default file attributes 2-177
SHOW Displays default file attributes or CONFIG[URE] options 2-194
DEALLOCATE fileset-list [ , PARTONLY ]