SQL/MP Installation and Management Guide

Installing SQL/MP
HP NonStop SQL/MP Installation and Management Guide—523353-004
2-13
Mixed-Version Network Considerations
Mixed-Version Network Considerations
SQL/MP processes run at a high PIN by default. However, a process that must access
objects on C-series nodes must not run at a high PIN. Therefore, these SQL/MP
processes must run at low PINs if they communicate with a process on a C-series
node (or any process that cannot respond to a high-PIN process):
•
FastSort (RECGEN, SORT, SORTGEN)
•
SQL catalog manager (SQLCAT)
•
SQL compiler (SQLCOMP)
•
SQL conversational interface (SQLCI)
•
SQL executor server processes (SQLESP)
•
SQL utilities (SQLUTIL)
•
SQLCI2
•
Collation compiler (NLCPCOMP)
There are several approaches for running SQL programs at low PINs, including these:
•
Setting the TACL HIGHPIN environment variable to OFF when running any SQL
program:
°
Arrange to have all TACL processes inherit a HIGHPIN OFF setting, either by
specifying SET HIGHPIN OFF in the initial TACL process (before starting all
other TACL processes on the node) or by placing a SET HIGHPIN OFF
command into the $SYSTEM.SYSTEM TACLCSTM file, executed by every
TACL process during logon.
°
Alternatively, specify HIGHPIN OFF as needed in TACL RUN commands or
SQLCI OBEY command files.
Remove the HIGHPIN commands when access to C-series nodes is no longer
needed.
•
Setting the HIGHPIN attribute to OFF in all object files by using the BIND CHANGE
command to change the HIGHPIN attribute for SQL program files after they have
been installed. The syntax is:
BIND CHANGE HIGHPIN OFF IN $SYSTEM.SYSTEM.<filename>
where <filename> is SQLCI, SQLCI2, SQLCAT, SQLUTIL, SQLCOMP, SQLESP,
RECGEN, and NLCPCOMP.
Before making this change, note the license flag setting for each file and relicense
any licensed files after changing the HIGHPIN attribute. If you use this approach,
continue to change the HIGHPIN setting after any subsequent installation of SQL
software until access to C-series nodes is no longer needed.