SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-144
INITIALIZE SQL Statement
INITIALIZE SQL Statement
Considerations for INITIALIZE SQL
Examples of INITIALIZE SQL
The INITIALIZE SQL statement prepares a node to run NonStop SQL/MX.
INITIALIZE SQL is an SQL/MX extension.
The INITIALIZE SQL statement creates the SQL/MX user metadata (UMD) tables and
system metadata (SMD) tables in the system volume configured during installation.
If the volume is not audited, INITIALIZE SQL cannot execute. You cannot perform any
database requests until SQL is initialized. If SQL is already initialized, INITIALIZE SQL
returns an error.
Considerations for INITIALIZE SQL
INITIALIZE SQL is normally performed automatically by the script that installs
NonStop SQL/MX. You will probably never manually perform an INITIALIZE SQL
statement but it is described here for reference.
Authorization and Availability Requirements
The super ID becomes the owner of the SQL/MX user metadata (UMD) tables and
system metadata (SMD) tables. The PUBLIC user has GRANT PUBLIC SELECT
access on all of these tables.
Examples of INITIALIZE SQL
•
This example initializes SQL on the local node:
INITIALIZE SQL;
INITIALIZE SQL