SQL/MP Installation and Management Guide

Creating a Database
HP NonStop SQL/MP Installation and Management Guide—523353-004
5-4
Requirements for Catalogs
Only IXINDE01 is a unique index.
The SQL/MP Reference Manual presents a detailed description of each catalog table.
Requirements for Catalogs
A system that includes SQL/MP can have one or more catalogs to describe an SQL
database.
Following are the location-related requirements for SQL/MP catalogs on a system:
•
All SQL objects on a system must be described in a catalog on the same system.
•
Each system that includes SQL/MP must have at least one catalog.
•
Each volume containing a catalog must be enabled and audited by the TMF
subsystem, because catalogs are collections of audited SQL tables.
•
Each audited volume on a system can have one or more catalogs or no catalogs.
Each catalog on a volume can describe objects on that volume or on another
volume on the same system.
•
A single subvolume can have only one catalog. Each catalog has the same name
as the subvolume that contains the catalog.
For example, the full name of a catalog on the system \SYS1, volume $VOL1, and
subvolume SUBVOL1 is \SYS1.$VOL1.SUBVOL1.
•
Catalog tables cannot be partitioned.
Each system that uses SQL/MP has a catalog called the system catalog that contains
information about all the catalogs on the system. The system catalog is like any other
catalog, with these exceptions:
•
The system catalog is established during the installation of SQL/MP. For more
information, see Installing SQL/MP on page 2-2.
•
The system catalog contains an additional table, CATALOGS, which is the system
directory of catalogs.
•
To obtain the name of a local or remote system catalog, use the GET CATALOG
OF SYSTEM statement. (For more information, see the SQL/MP Reference
Manual or SQLCI online help.)
PROGRAMS IXPROG01 GROUPID, USERID
TABLES IXTABL01 GROUPID, USERID
USAGES IXUSAG01 USINGOBJNAME, USINGOBJTYPE
Table Name Index Name Index Columns (page 2 of 2)