User guide

A server name is required as it may be used by the server start up procedure to locate
properties from its configuration file. The name used will determine various characteristics of
the started server.
In addition the server name will be used as the OpenVMS process name and will determine
the naming of any associated executors if the server is a Multi-Process server.
The PORT_ID is used to determine the name of the Oracle JDBC for Rdb server using the
following precedence:
1. If the logical name RDB$JDBC_SQSNAM_<port> exists then it is translated to
provide the server name
2. If the logical name does not exist the server name will be SQS<port>
Example
1
Logical name not defined:
$ show log RDB$JDBC_SQSNAM_1888
%SHOW-S-NOTRAN, no translation for logical name RDB$JDBC_SQSNAM_1888
SQLSRV> CONNECT SERVER;
SQLSRV> CREATE DISPATCHER JDBC_DISP NETWORK_PORT TCPIP PORT_ID 1888
PROTOCOL JDBC;
Example 2
$ DEFINE/SYSTEM RDB$JDBC_SQSNAM_1888 MY_POOL_SRV
SQLSRV> CONNECT SERVER;
SQLSRV> CREATE DISPATCHER JDBC_DISP NETWORK_PORT TCPIP PORT_ID 1888
PROTOCOL JDBC;
During the invocation of a JDBC server, the following DCL command procedure is executed:
RDB$JDBC_HOME:RDBJDBC_STARTSRV.COM
The server name is also used in creating log and temporary files during the running of the
server.
$ MCR SQLSRV_MANAGE71
This will create a server named SQS1888.
Logical name defined:
$ MCR SQLSRV_MANAGE71
This will create a server named MY_POOL_SRV.
7.1.2.2 Determining extra DCL commands for use during start-up
This is the standard startup command procedure used by Oracle JDBC for Rdb and was
created for you during the installation of the Oracle JDBC for Rdb product.
98