File Utility Programming (FUP) Reference Manual
FUP Commands
File Utility Program (FUP) Reference Manual—523323-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 ]










