Stopping the Batch Job/Started Task TCP/IP Listener
To stop the Adabas SQL Gateway TCP/IP Listener gracefully, use one of the following procedures:
Important:
Stopping the Adabas SQL Gateway TCP/IP Listener program CNXRUNA causes its started task or batch job to exit. When CNXRUNA terminates, it halts all instances of the Adabas SQL Gateway server program (CNXADD0B), which run as sub-tasks in the same address space. A separate instance (subtask) of CNXADD0B is created for each CONNX client connection via ODBC, JDBC, OLE DB or .NET to the specified TCP/IP address + port. Therefore, stopping the CNXRUNA program severs any active CONNX connections to the CNXADD0B server subtasks.
Stop the Adabas SQL Gateway TCP/IP Listener with the /STOP operator console command
You must be authorized to issue operator console commands.
The CONNX top level 'broker' program (CNXSTART) must be the main program of job step CNXRUNA in procedure CNXADA. This is the default setting, which can be overridden at JCL-submission time by changing the symbolic parameter CNXSTART.
The environment variables CNXLISTENER and CNXOPERATORCOMMAND must be defined as follows in member CNXPARMS of the CONNX.**.CNTL partitioned data set:
=CNXLISTENER=CNXRUNA
=CNXOPERATORCOMMAND=1
Assume that batch job CNXADA is executing JCL procedure CNXADA from the CONNX.**.CNTL partitioned data set, and that four PC clients are currently connected to separate instances of the Adabas SQL Gateway TCP/IP server program. To stop the Adabas SQL Gateway TCP/IP Listener via an operator console command, enter /stop cnxada.
The CNXADA job terminates the CONNX TCP/IP Listener program (CNXRUNA), as well as all of its currently executing server program (CNXADD0B) subtask(s).
Stop the Adabas SQL Gateway TCP/IP Listener via the CNXSTOP REXX command
The CONNX top level 'broker' program (CNXSTART) must be the main program of job step CNXRUNA in procedure CNXADA. This is the default setting, which can be overridden at JCL-submission time by changing the symbolic parameter CNXSTART.
The environment variables CNXLISTENER and CNXOPERATORCOMMAND must be defined as follows in member CNXPARMS of the CONNX.**.CNTL partitioned data set:
=CNXLISTENER=CNXRUNA
=CNXOPERATORCOMMAND=0
To stop the TCP/IP Listener program CXNRUNA and end the job, use the CNXSTOP REXX command.
From the ISPF Command Shell (default option 6):
cnxstop port
or
exec 'connx.adabas.cntl(cnxstop)' port
Stop the Adabas SQL Gateway TCP/IP Listener by submitting batch job CNXSTOP from member CNXSTOPJ of the CONNX.**.CNTL partitioned data set
The CONNX top level 'broker' program (CNXSTART) must be the main program of job step CNXRUNA in procedure CNXADA. This is the default setting, which can be overridden at JCL-submission time by changing the symbolic parameter CNXSTART.
The environment variables CNXLISTENER and CNXOPERATORCOMMAND must be defined as follows in member CNXPARMS of the CONNX.**.CNTL partitioned data set:
=CNXLISTENER=CNXRUNA
=CNXOPERATORCOMMAND=0
To stop the TCP/IP Listener program and end the job, edit member CNXSTOPJ in the CONNX.**.CNTL partitioned data set, change the job card to match site-specific standards, and submit the job to a batch execution queue. Both jobs CNXADAJ and CNXSTOPJ should end with condition codes = 0:
The CNXADAJ job terminates the CONNX TCP/IP Listener program (CNXRUNA), as well as all of its currently executing server program (CNXAD0B) subtask(s).