SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013
I-13
INITIALIZE SQL Command
INITIALIZE SQL Command
INITIALIZE SQL is an SQLCI command that allows a user with the local super ID to
ensure that SQL is using compatible components and to prepare a node to run
NonStop SQL/MP. The INITIALIZE SQL command is required whenever you install a
new NonStop SQL/MP PVU or software product revision (SPR).
Considerations—INITIALIZE SQL

If NonStop SQL/MP has not been installed on your node previously, you must
create the system catalog before executing INITIALIZE SQL. (For more
information, see CREATE SYSTEM CATALOG Command
on page C-152.)
For more information on preparing your node to run NonStop SQL/MP, see the
SQL/MP Installation and Management Guide.

INITIALIZE SQL purges any existing SQLCI2 file, renames the file ZZSQLCI2 to
SQLCI2, SQL-compiles SQLCI2, and registers the SQLCI2 program in the system
catalog by executing these commands:
PURGE $SYSTEM.SYSTEM.SQLCI2
RENAME $SYSTEM.SYSTEM.ZZSQLCI2, $SYSTEM.SYSTEM.SQLCI2
SQLCOMP /IN $SYSTEM.SYSTEM.SQLCI2/ CATALOG $SYSTEM.SQL
Example—INITIALIZE SQL
To prepare NonStop SQL/MP on your node for the first time, enter these commands:
>> CREATE SYSTEM CATALOG;
>> INITIALIZE SQL;
INITIALIZE SQL ;