Terminating secondary subtransactions in the PTC state (&SYNCHRONIZE DISTRIBUTION)

For UDS-D

&SYNCHRONIZE DISTRIBUTION          

After an event such as a computer crash or a line failure, the database administrator uses &SYNCHRONIZE DISTRIBUTION to try to terminate all secondary subtransactions which are in the PTC condition, in order to reduce wait times for secondary subtransactions. Waiting periods may arise if the value of the DBH load parameter PP PTCSYNCH for the current session is set to WAIT.

To terminate a secondary subtransaction in the PTC state, the DBH of the primary subtransaction needs to be queried to determine whether the primary subtransaction was terminated with FINISH or with FINISH WITH CANCEL so that the secondary subtransaction can be terminated in the same mode.

If the configuration of the primary subtransaction is not accessible, all secondary subtransactions for which it is not possible to ascertain the condition of the primary subtransaction are immediately handled as defined by the PTCSYNCH value for the current session (see section “Monitoring secondary subtransactions in the PTC state”).

If &SYNCHRONIZE DISTRIBUTION is not specified, UDS-D reacts as defined by the PTCSYNCH value for the current session after a period governed by the PP CHCKTIME parameter.