SQL/MP Installation and Management Guide

Installing SQL/MP
HP NonStop SQL/MP Installation and Management Guide—523353-004
2-7
Initializing SQL/MP
can use ALTER TABLE statements to resecure the CATALOGS, USAGES,
TRANSIDS, and PROGRAMS tables separately.
>> ALTER CATALOG system-catalog SECURE "NG--";
>> ALTER TABLE system-catalog.CATALOGS SECURE "NA--";
For more information, see Securing the System Catalog on page 5-10.
10. Verify that these programs are secured for execute access on your node:
$SYSTEM.SYSTEM.SQLCI
$SYSTEM.SYSTEM.SQLCI2
$SYSTEM.SYSTEM.SQLCAT
$SYSTEM.SYSTEM.AUDSERV
$SYSTEM.SYSTEM.SQLCOMP
$SYSTEM.SYSTEM.SQLESP
$SYSTEM.SYSTEM.SQLESPMG
$SYSTEM.SYSTEM.SQLUTIL
$SYSTEM.SYSTEM.NLCPCOMP
$SYSTEM.SYSnn.RECGEN
$SYSTEM.SYSnn.SORTPROG
In the preceding list, nn represents two digits assigned during node generation
(SYSGEN operation).
Verify that this file is secured for read access on your node:
$SYSTEM.SYSTEM.SQLMSG
If your node is part of a network, check that the programs in the preceding list are
secured for network execute access and that the $SYSTEM.SYSTEM.SQLMSG
file is secured for network read access.
11. Verify that these Guardian utilities and SQL/MP components are licensed so that
they can access SQL/MP objects. The INSTALL process, when completed
normally, performs the licensing of these programs (automatically or manually):
$SYSTEM.SYSTEM.SQLCOMP
$SYSTEM.SYSTEM.SQLUTIL
$SYSTEM.SYSTEM.SQLCAT
$SYSTEM.SYSTEM.AUDSERV
$SYSTEM.SYSnn.BACKUP
$SYSTEM.SYSnn.DSAP
$SYSTEM.SYSnn.FUP
$SYSTEM.SYSnn.FILCHECK
$SYSTEM.SYSnn.PUP
$SYSTEM.SYSnn.SCF
$SYSTEM.SYSnn.RESTORE
$SYSTEM.SYSnn.SORTPROG
In the preceding list, nn represents two digits assigned during system generation
(SYSGEN operation).
Note. SQLCI2 and NLCPCOMP must have both read and execute access.