Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

Terminating the session or administration (CLOSE)

&pagelevel(4)&pagelevel

CLOSE {RUN-UNITS | CALLS | ADMINISTRATION}          

The CLOSE command terminates a session or the DCAM administration normally (see section "Clearing a connection to the UDS/SQL configuration (DISCONNECT-CONFIGURATION)" in  chapter "UDSADM statements").

RUN-UNITS

Initiates the normal termination procedure:

All active transactions can continue working normally, but the DBH will not allow any new transactions (status code 151).

When all transactions have finished, the master task terminates all server tasks. The master task then closes the session with the following message:

%UDS0758 NUMBER OF DML-STATEMENTS AND I/O COUNTERS PER DATABASE
%UDS0213 UDS NORMAL SYSTEM TERMINATION

Transactions in the STOP condition are activated automatically (see the STOP command in chapter "Stopping the execution of transactions (STOP)").

The number of DML statements per database and the number of input and output operations per database are output to SYSOUT at the following opportunities:

  • When the database is dropped (DROP DB)

  • As soon as the DBH has been terminated

CALLS

Effects fast termination of a session:

The DBH rolls back all open transactions (status code 122, SQL code -1700). Any attempt to start a transaction is rejected with status code 151 or 122 (SQL code -1820 or -1700).

Note on UDS-D

A rollback is not performed if the transaction is in the PTC condition. For CLOSE CALLS to take effect, transactions in the PTC condition must be terminated individually (see section "Terminating the PTC state" ).

ADMINISTRATION

The current administration via DCAM is terminated. Administration via DCAM can be started again if the need arises.