File Utility Programming (FUP) Reference Manual
FUP Commands
File Utility Program (FUP) Reference Manual—523323-015
2-184
SET Parameters for Partitioned Files
PART ( sec-partition-num , [\node.]$volume
[ , pri-extent-size [ , [ sec-extent-size ]
[ , partial-key-value ] ] ] )
PART
sets secondary partition specifications for partitioned files. Specify each secondary
partition separately.
sec-partition-num , \node.$volume
names the volume where this secondary partition is to reside. Specify
sec-partition-num as an integer from 1 through 15 to designate the
secondary partition. For a Format 2 key sequenced file, specify
sec-partition-num as an integer from 1 through 63 to designate the
secondary partition. Specify node and volume as the names of the node and
volume to contain the partition. The file name and the subvolume of the
primary partition are specified when the file is created.
Although FUP allows to specify any number ranging from of 1 through 63 for
sec-partition-num, FUP changes it to a standard DP2 number that starts
at zero when the file is created.
For a Format 2 key-sequenced file, specify sec-partition-num as an
integer from 1 through 127 to designate the secondary partition.
pri-extent-size , sec-extent-size
sets the primary and secondary extent sizes. The default value for
pri-extent-size is one page (2,048 bytes). If you specify a value of zero or
do not specify a value, sec-extent-size defaults to the
pri-extent-size value. When altering files, you cannot define primary or
secondary extents as zero pages.
For partitioned unstructured files where one or more partitions reside on a disk
drive in a disk drive enclosure, DP2 has additional restrictions. You must
specify both the pri-extent-size and the sec-extent-size so that they
can be explicitly divisible by 14. DP2 does not automatically round the size up.
You can specify these values for pri-extent-size and
sec-extent-size:
Note. Example 2-6, DETAIL Format for SQL Tables and Indexes and for Enscribe and
OSS Files, on page 2-105 shows the DP2 number as listed in the INFO DETAIL
command.