SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-135
Examples—CREATE CATALOG

Specify a direct subvolume for catalog

Specify a virtual volume and subvolume for catalog and a physical volume
that belongs to the virtual volume in PHYSVOL. Do not include node name in
your volume name.
If you specify a virtual volume for catalog and omit the PHYSVOL option, SQL
can distribute catalog tables among multiple physical volumes in the virtual volume.

The version number of a new catalog is the version of NonStop SQL/MP on the
node where the catalog resides, even if you create the catalog from a node with a
different version number.
For example, if you issue CREATE CATALOG from a version 315 node but specify
a catalog subvolume on a version 1 node, the new catalog is a version 1 catalog.

The user specified EXTENT and MAXEXTENTS attributes apply for catalog tables
and indexes.

If the user specifies the EXTENT attribute with only primary extent value, then the
secondary extent value is also set with the same value as primary extent.

If the user specifies the EXTENT attribute but does not specify the MAXEXTENTS
attribute, then MAXEXTENTS will be calculated by SQL, based on the primary and
secondary extents value.

If the user specifies the EXTENT attribute and MAXEXTENTS attribute, then SQL
will check if the user specified MAXEXTENTS is lower than the maximum possible
extents based on the primary and secondary extents value. If it is lower, SQL
accepts the user specified MAXEXTENTS. If it is higher, an error is returned during
file creation.
Examples—CREATE CATALOG

This example creates a catalog named PERSNL on node \SYS1 and volume
$VOL1, with security “nunu”:
CREATE CATALOG \SYS1.$VOL1.PERSNL SECURE "nunu";

This SQLCI example uses ALTER DEFINE to set the CATALOG attribute of the
=_DEFAULTS DEFINE before creating a catalog. The new catalog is created on
\SYS1.$VOL.SALES.
ALTER DEFINE =_DEFAULTS, CATALOG \SYS1.$VOL.SALES;
CREATE CATALOG;

This example creates a catalog named PERSNL on node \SYS1 and volume
$VOL1, with EXTENT 100. MAXEXTENTS will be calculated by SQL:
CREATE CATALOG \SYS1.$VOL1.PERSNL EXTENT 100;