SQL/MP Installation and Management Guide

Installing SQL/MP
HP NonStop SQL/MP Installation and Management Guide—523353-004
2-6
Initializing SQL/MP
6. Initialize SQL/MP by entering this command at the SQLCI prompt:
>> INITIALIZE SQL;
During the installation of the SQL/MP system software, the INSTALL program
places the new SQLCI2 program on the $SYSTEM.SYSTEM subvolume in the file
named ZZSQLCI2. SQLCI2 is the process through which the SQL/MP
conversational interface (SQLCI) communicates with the SQL/MP executor to
request various functions.
The SQL initialization process requested in this step drops the older version of
SQLCI2 if it exists on the system, renames the ZZSQLCI2 file to SQLCI2, SQL
compiles the program in $SYSTEM.SYSTEM.SQLCI2, and registers the program
in the PROGRAMS table of the system catalog. To run SQL statements from
SQLCI, SQLCI2 must be a valid, registered SQL program.
The INITIALIZE command performs the installation operations automatically. You
can request these operations directly, however, by entering commands at the
command interpreter prompt (for installation on $SYSTEM.SYSTEM):
24> PURGE $SYSTEM.SYSTEM.SQLCI2 (if you are reinstalling SQL)
25> RENAME $SYSTEM.SYSTEM.ZZSQLCI2, $SYSTEM.SYSTEM.SQLCI2
26> SQLCOMP/IN SQLCI2/ CATALOG system-catalog
In the SQLCOMP command, system-catalog is the Guardian name of the
system catalog.
7. Terminate SQLCI and create a backup copy of the collation compiler, which is in
the $SYSTEM.SYSTEM.NLCPCOMP file:
>> EXIT;
26> FUP DUP $SYSTEM.SYSTEM.NLCPCOMP, &
26> & $VOLBK.SUBVBK.NLCPCOBK, SOURCEDATE
(The collation compiler translates character processing rules specified in a source
file into an internal format.)
8. Use the SQLCOMP command to SQL compile the collation compiler:
27> SQLCOMP /IN $SYSTEM.SYSTEM.NLCPCOMP,NOWAIT/ CATALOG
$VOL1.SQL
In this command, $VOL1.SQL is the subvolume where the system catalog resides
9. If you are installing SQL for the first time on this node, set the appropriate security
string for the system catalog. You can use the ALTER CATALOG statement to alter
the owner ID and security string of all the system catalog tables at once. Then, you
Note. You must SQL compile the collation compiler manually anytime you install a
software product revision (SPR) to the T6570 - National Language Character Processing
product.