NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
C-143
Considerations—CREATE SYSTEM CATALOG
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 rest of the system catalog. The CATALOGS table is described in the system
catalog, and the system catalog is registered in the CATALOGS table.
•
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 ServerWare 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
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
•
The following command creates a system catalog on $SYSTEM.SQL:
CREATE SYSTEM CATALOG;
•
The following command 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;
CREATE TABLE Statement
CREATE TABLE is a DDL statement that creates a table.
CREATE TABLE requires you to specify a table name and a description of each column
in the table, but allows you to specify many other attributes of the table as well. A
typical table definition also includes a description of the primary key or clustering key