NonStop SQL/MP Reference Manual

NonStop SQL/MP Reference Manual—142115
I-13
Considerations—INITIALIZE SQL
SQL/MP. The INITIALIZE SQL command is required whenever you install a new
release or interim modification to NonStop SQL/MP.
Considerations—INITIALIZE SQL
•
If NonStop SQL/MP has not been installed on your node previously, you must
create the system catalog prior to executing INITIALIZE SQL. (See CREATE
SYSTEM CATALOG Command on page C-142 for more information.)
For more information on preparing your node to run NonStop SQL/MP, see the
NonStop 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
Examples—INITIALIZE SQL
•
To prepare NonStop SQL/MP on your node for the first time, enter these commands:
>> CREATE SYSTEM CATALOG;
>> INITIALIZE SQL;
INITIALIZE SQL ;