SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-133
CREATE CATALOG Statement
attribute-spec
specifies physical file attributes for the file that holds catalog tables and indexes.
The following file attributes can be specified through the attribute-spec option:
EXTENT { (pri-ext-size [, sec-ext-size]) }
{ ext-size }
The various options allowed under ext-size, pri-ext-size, or sec-ext-
size are:
integer[ PAGE[S] ]
[ BYTE[S] ]
[ REC[S] ]
[ MEGABYTE[S] ]
[ GIGABYTE[S] ]
For Catalog tables, the default is 16 pages for the primary extent and 128
pages for each secondary extent.
For Catalog indexes, the default is 16 pages for the primary extent and 64
pages for each secondary extent.
The default unit type is PAGE.
For more information see, EXTENT File Attribute on page E-30
MAXEXTENTS num-extents
is an integer from 1 to 940 that specifies the maximum number of extents that
can be allocated.
The catalog tables and indexes are of Format 1 type.
For more information see, MAXEXTENTS File Attribute
on page M-2.
Note. The attribute-spec option is supported on systems running J06.05 and later J-
series RVUs, or H06.16 and later H-series RVUs.