NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-142
CREATE SYSTEM CATALOG Command
CREATE INDEX statement starts a sort process that uses the specified subsort
processes:
>> ADD DEFINE =_SORT_DEFAULTS, CLASS SORT, SUBSORTS (=SS1,
+> =SS2, =SS3, =SS4);
>> ADD DEFINE, =SS1, CLASS SUBSORT, SCRATCH $VOL1;
>> ADD DEFINE, =SS2, CLASS SUBSORT, SCRATCH $VOL2;
>> ADD DEFINE, =SS3, CLASS SUBSORT, SCRATCH $VOL3;
>> ADD DEFINE, =SS4, CLASS SUBSORT, SCRATCH $VOL4;
>> CREATE INDEX AGEINDEX ON CUSTABLE (COL2);
CREATE SYSTEM CATALOG Command
CREATE SYSTEM CATALOG is an SQLCI command that allows the local super ID to
create the system catalog, including the SQL.CATALOGS table, when NonStop
SQL/MP is first installed on a node.
catalog-name
specifies the location of the system catalog on the local node.
catalog-name is the volume and subvolume name of the new system catalog (or
an equivalent CLASS CATALOG DEFINE). The volume you specify must be
audited. The subvolume name must be unique among catalog names on the volume.
The default catalog-name is $SYSTEM.SQL.
If ServerWare SMF is installed on your node, catalog-name can be either a
direct or virtual volume.
If you specify only a subvolume for catalog-name, SQL creates the set of
system catalog tables in the current default volume. If the default is a virtual
volume, the set of system catalog tables resides on the virtual volume. If the default
is a physical volume, the set of catalog tables resides on the physical volume as
direct files not managed by ServerWare SMF.
PHYSVOL volume-name
If ServerWare SMF is installed on your node, the PHYSVOL option directs SQL to
override ServerWare SMF and place the system catalog on the physical volume
volume-name. For volume-name, specify either a physical volume or
equivalent DEFINE.
This option is available only if you specify a virtual volume for catalog-name.
volume-name most belong to the virtual volume you specify.
CREATE SYSTEM CATALOG [ [ catalog-name ]
[ PHYSVOL volume-name ] ];