SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-152
CREATE SYSTEM CATALOG Command
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 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 SMF.
PHYSVOL volume-name
If SMF is installed on your node, the PHYSVOL option directs SQL to override
SMF and place the system catalog on the physical volume volume-name. For
volume-name, specify either a physical volume or equivalent DEFINE. Do not
include the node name in your volume name.
This option is available only if you specify a virtual volume for catalog-name.
volume-name most belong to the virtual volume you specify.
Considerations—CREATE SYSTEM CATALOG

Only the local super ID can create a system catalog.

The TMF subsystem must be operating when you execute CREATE SYSTEM
CATALOG.

SQL creates the CATALOGS table on a subvolume named SQL on the same
volume as the remainder of the system catalog. The CATALOGS table is described
in the system catalog, and the system catalog is registered in the CATALOGS
table.
CREATE SYSTEM CATALOG [ [ catalog-name ]
[ PHYSVOL volume-name ] ];