This statement suspends admission of any further transactions.
Scope of validity
DBH and SESDCN administration
See also
The RESUME-TRANSACTION-ADMISSION administration statement on "RESUME-TRANSACTION-ADMISSION"
Function
You can use the HOLD-TRANSACTION-ADMISSION administration statement to suspend processing of transactions and thus prevent new transactions being admitted.
Application programs affected by this suspension of transaction processing learn of it when a transaction is started. An SQL program by means of the appropriate SQLSTATE, and a CALL DML program by means of the status 9K.
If requests with open transactions still exist when the administration statement is issued, SESAM/SQL displays them in tabular form.
In DBH administration, but not SESDCN administration, you can cause transaction processing to be suspended only once the DBH is transaction free.
This is the case when all transactions have been committed or rolled back. SESAM/SQL outputs a message indicating this to the administration program, which then continues its work.
You can permit the resumption of transaction processing by means of the RESUME-TRANSACTION-ADMISSION administration statement.
HOLD-TRANSACTION-ADMISSION |
WAIT-EVENT = *NONE / *TRANSACTION-FREE-STATE |
Operands
WAIT-EVENT =
Specifies whether or not the transaction-free state must be reached before transaction processing can be suspended.
WAIT-EVENT = *NONE
This is the default. Transaction processing is suspended regardless of whether the DBH is transaction free.
WAIT-EVENT = *TRANSACTION-FREE-STATE
Transaction processing is not suspended until the DBH is transaction free. This operand is only permitted in DBH administration. It is not permitted in SESDCN administration.
Administration command in ISP format and at the CALL DML interface
Two administration commands fulfill the function of the HOLD-TRANSACTION-ADMISSION administration statement:
HOLD-TA (for DBH administration) or HOLD,TA (for SESDCN administration)
WAIT,HOLD.
The HOLD-TA administration command is permitted for DBH administration and HOLD,TA for SESDCN administration. HOLD,TA has the same function as the
HOLD-TRANSACTION-ADMISSION administration statement with the operand WAIT-EVENT = *NONE.
HOLD-TA
HOLD,TA
The WAIT,HOLD administration command is permitted only in DBH administration and can only be issued via the CALL DML interface.
It has the same function as the HOLD-TRANSACTION-ADMISSION administration statement with the operand WAIT-EVENT = *TRANSACTION-FREE-STATE.
WAIT,HOLD