User guide

This command procedure will setup some environmental elements and then execute a JAVA

command to start the server. A discrete dispatcher process will be set up by the

SQL/Services START DISPATCHER command and the JAVA command will be run under

this process context.

The RDBJDBC_STARTSRV command procedure will try to locate and execute any specific

setup command procedures you may have designated for its use. This is done prior to the

procedure executing the JAVA command that will ultimately start the server instance.

The PORT_ID is used to determine the name of an Open VMS DCL command procedure

that may be invoked containing your system and environmental setup procedures. The file

specification of the command procedure is determined using the following precedence:

1. If the logical name RDB$JDBC_SQSCMD_<port> exists then it is translated to

provide the command procedure file specification

2. If the logical name does not exist the dispatcher will try to locate and execute the

file rdb$jdbc_com:rdbjdbc_sqs_onStartup.com.

Logical name not defined and file rdb$jdbc_com:rdbjdbc_sqs_onStartup.com does exist:

%SHOW-S-NOTRAN, no translation for logical name RDB$JDBC_SQSCMD_1888

$ MCR SQLSRV_MANAGE71

SQLSRV> CREATE DISPATCHER JDBC_DISP NETWORK_PORT TCPIP PORT_ID 1888

PROTOCOL JDBC;

The file

RDB$JDBC_COM:RDBJDBC_SQS_ONSTARTUP.COM

will be executed.

Example

Logical name defined:

$ DEFINE/SYSTEM RDB$JDBC_SQSCMD_1888 RDB$JDBC_COM:MY_SRV1888_ONSTART.COM

$ MCR SQLSRV_MANAGE71

SQLSRV> CREATE DISPATCHER JDBC_DISP NETWORK_PORT TCPIP PORT_ID 1888

PROTOCOL JDBC;

The file

RDB$JDBC_COM:MY_SRV1888_ONSTART.COM

will be executed.

7.1.2.3 Determining the server configuration file

3. If this file does not exists the dispatcher will try to locate and execute the file

rdb$jdbc_home:rdbjdbc_sqs_onStartup.com

Example

$ show log RDB$JDBC_SQSCMD_1888

SQLSRV> CONNECT SERVER;