SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

C-132

CREATE CATALOG Statement

CREATE CATALOG is a DDL statement that creates a new catalog. Each new catalog

includes a complete set of catalog tables and indexes. For information about the

contents of a catalog, see Catalogs on page C-8.

catalog

is the name of the Guardian subvolume to contain the catalog (or an equivalent

DEFINE) and is also the name of the new catalog. The volume on which the

subvolume resides must be audited by the TMF subsystem and catalog must be

a unique catalog name on that volume. If SMF is installed on your node, the

volume on which the subvolume resides can be a virtual or direct volume. You

cannot specify any $*.ZYS*. subvolumes for catalog.

If SMF is installed on your node and the default volume is a virtual volume, SQL

places the set of catalog tables on the virtual volume. If the default volume is a

direct volume, the catalog tables reside on the physical volume as direct files not

managed by SMF.

If you omit catalog, SQL uses the current default catalog.

SECURE "rwep"

specifies security for the new catalog. If you omit the SECURE clause, SQL uses

the default security of the user who creates the catalog. (For more information, see

Security on page S-11.)

PHYSVOL volume-name

If SMF is installed on your node, specifies a physical volume on which to place the

set of catalog tables. This option overrides SMF features. volume-name can be

either the name of 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 and subvolume for

catalog. volume-name must belong to the virtual volume you specify.

CREATE CATALOG [ catalog ] [ SECURE "rwep" ]

[ PHYSVOL volume-name ] [ attribute-spec ]

attribute-spec is:

{ EXTENT { (pri-ext-size[,sec-ext-size]) }

{ ext-size }

{ MAXEXTENTS integer }

Note. The attribute-spec option is supported on systems running J06.05 and later J-

series RVUs or H06.16 and later H-series RVUs.