SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
C-153
Examples—CREATE SYSTEM CATALOG

The security defined for the CATALOGS table is the default security for the super
ID. Use ALTER TABLE to alter the security as needed to grant other users
authority to read and write to the table to create catalogs.

If you execute CREATE SYSTEM CATALOG when a system catalog already exists
on the node, SQLCI reports an error.

If SMF is installed on your node, there are two ways to place the set of catalog
tables on a single physical volume:

Specify a direct volume and subvolume for catalog-name

Specify a virtual volume and subvolume for catalog-name and a physical
volume that belongs to the virtual volume in PHYSVOL. Do not include the
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.
Examples—CREATE SYSTEM CATALOG

This example creates a system catalog on $SYSTEM.SQL:
CREATE SYSTEM CATALOG;

This example creates a system catalog $VOL.SUBVOL. The CATALOGS table
resides on $VOL.SQL, but the other catalog tables and indexes reside on
$VOL.SUBVOL:
CREATE SYSTEM CATALOG $VOL.SUBVOL;