SQL/MX 2.x Installation and Management Guide (G06.24+, H06.03+)

Adding, Altering, and Dropping SQL/MX Database

Objects

HP NonStop SQL/MX Installation and Management Guide—523723-004

9-4

Adding Catalogs

To add a catalog, use the CREATE CATALOG statement.

A catalog is owned by the user ID that created it, although catalog ownership does not

imply authorization over schemas or objects in that catalog. Each of the schemas

described in a catalog has an owner. A catalog can contain multiple schemas, each

possibly owned by a different user. A catalog cannot contain other catalogs.

Any user on a node can create a catalog on that node and create a schema in the

catalog. Any user can drop an empty catalog, regardless of who the catalog owner is.

Catalog names beginning with NONSTOP_SQLMX_ are reserved for system metadata

and you are not allowed to create or to drop catalogs with these reserved names.

For more information, see the SQL/MX Reference Manual.

Steps for Adding a Catalog

1. Start an MXCI session. Enter a LOG command to initiate a log file for statements

and commands entered in this session. Keep the log for your records.

2. Determine a name for the catalog you want to add.

3. Ensure your catalog name is unique among existing catalog names on your node.

4. Check whether or not your catalog name is unique across all the nodes in your

Expand network (if applicable).

5. Choose a location for the metadata tables for the catalog. You must choose an

audited, non-SMF DAM disk volume.

6. Enter the CREATE CATALOG statement.

For more information and examples of creating catalogs, see Creating Catalogs

page 7-6.

Note. Once you have created (registered) your catalog on your node, you will be unable

to register any catalog with the same name from another node (for example, to be able to

access objects in the other catalog from your node).