SQL/MP Installation and Management Guide

Installing SQL/MP
HP NonStop SQL/MP Installation and Management Guide—523353-004
2-4
Initializing SQL/MP
For configuration information, see Guidelines for Configuring TMF on page 4-13.
Initializing SQL/MP
Before you can use SQL/MP for the first time, or when reinstalling the product, you
must request initialization of SQL/MP by using the CREATE SYSTEM CATALOG and
INITIALIZE SQL commands. The SQL/MP Reference Manual describes the syntax of
these SQLCI commands.
SQL initialization involves creating the system catalog, SQL compiling the SQLCI2
program as a valid SQL program, then registering the program in the system catalog.
The SQLCI2 program, when in execution, serves as a backend process for SQLCI.
The system catalog is like any other catalog, except it contains an additional table,
CATALOGS, which is the system directory of catalogs. The CATALOGS table must
reside on a subvolume named SQL.
By default, the system catalog resides on the subvolume $SYSTEM.SQL; however,
you can specify another volume and subvolume in the CREATE SYSTEM CATALOG
command. If the system catalog is not on the subvolume SQL, the CATALOGS table is
placed on the same volume as the system catalog, but on a subvolume named SQL.
For information about locating and securing catalogs, see Creating Catalogs on
page 5-1.
Initialization Steps
To initialize SQL/MP, follow these steps:
1. Check that the TMF subsystem is configured correctly and started.
2. Check that the $SYSTEM.SYSTEM.ZZSQLCI2 file exists on the node and save a
copy. This temporary file, which contains the SQLCI2 program, is copied onto the
disk by the INSTALL program.
3. Log on as the local super ID. The super ID is required to run the CREATE
SYSTEM CATALOG and INITIALIZE SQL commands in Step 5 and Step 6 on page
2-6.
4. Start the SQLCI program. At the command interpreter prompt, enter the program
name:
23> SQLCI
5. If you are installing SQL for the first time on this node, create the system catalog. If
you are reinstalling it, you can skip this step.
Note. As a basic rule, HP recommends you save a copy of the
$SYSTEM.SYSTEM.ZZSQLCI2 (SQLCI2) program at all times. After the SQL initialization
is complete (Step 6), the temporary copy (ZZSQLCI2) is renamed and becomes the
permanent SQLCI2 program. If a subsequent SQL initialization is attempted or if the
SQLCI2 program is corrupted or purged, the saved copy provides a backup.