SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

S-92

System Catalog

Each node on a network has one special catalog called the system catalog.

The system catalog contains the same tables as other catalogs on the node, but

includes one additional table, the CATALOGS table, that lists all catalogs on the node.

For more information, see CATALOGS Table on page C-11.

The system catalog is established during the installation of NonStop SQL/MP. By

default, it is located on volume $SYSTEM and subvolume SQL, although you can

specify a different volume and subvolume at installation time if necessary. (The

CATALOGS table is always located on subvolume SQL on the same volume as the

system catalog.)

These statements can operate on the system catalog:

ALTER CATALOG

CREATE SYSTEM CATALOG

DOWNGRADE SYSTEM CATALOG

DROP SYSTEM CATALOG

GET CATALOG OF SYSTEM (returns location)

GET VERSION OF CATALOG

UPGRADE SYSTEM CATALOG

However, the ALTER CATALOG statement does not affect the system catalog

CATALOGS table. You must alter that table with the ALTER TABLE statement.

If you have appropriate authorization, you can also use other SQL statements to

operate on individual tables within the system catalog. For more information, see

Catalogs

on page C-8.