SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
E-30
EXTENT File Attribute
EXTENT File Attribute
EXTENT is a Guardian file attribute that sets the size of the extents (units of
contiguous disk space) that will be allocated for a file or a partition of a file. EXTENT
applies to key-sequenced, relative, and entry-sequenced tables and to indexes.
EXTENT is set when a file or partition is created. Each partition of a partitioned file has
its own EXTENT attribute that can differ from the EXTENT attribute for other partitions
of the file. You can specify a single extent size for each extent in the file or partition, or
you can specify one size for the primary (first) extent and another size for the
secondary extents.
The default is 16 pages for the primary extent and 64 pages for each secondary extent.
The default unit type is PAGE.
integer
is an integer that specifies the number of pages, bytes, recs, or megabytes in the
extent. The ranges allowed for Format 1 partitions are:
The ranges allowed for Format 2 partitions are:
A PAGE consists of 2048 bytes.
A MEGABYTE consists of 1,000,000 bytes. A GIGABYTE consists of
1,000,000,000 bytes.
EXTENT { ext-size }
{ ( pri-ext-size [, sec-ext-size ] ) }
ext-size, pri-ext-size, or sec-ext-size is:
integer [ PAGE[S] ]
[ BYTE[S] ]
[ REC[S] ]
[ MEGABYTE[S] ]
[ GIGABYE[S] ]
PAGES 0 to 65,535
BYTES 0 to 134,215,680
RECS 0 to 134,215,680
MEGABYTES 0 to 134
PAGES 0 to 512,000,000
BYTES 0 to 1,048,576,000,000
RECS 0 to 1,048,576,000,000
MEGABYTES 0 to 1,048,576
GIGABYTES 0 to 1,048