FUP Commands
File Utility Program (FUP) Reference Manual—523323-014
2-178
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 lets you specify any number in the range of 1 through 15 for
sec-partition-num, FUP changes it to a standard DP2 number that starts
at zero when the file is created.
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:
0:maximum [ PAGE[S] ]
specifies the extent size in pages (2,048-byte units). Possible values are:
Note. Example 2-6, DETAIL Format for SQL Tables and Indexes and for Enscribe and
OSS Files, on page 2-100 shows the DP2 number as listed in the INFO DETAIL
command.
Format 1 Format 2
0:65,535 [ PAGE[S] ] 0:512,000,000 [ PAGE[S] ]