Previous Topic: OPEN/CLOSE EfficiencyNext Topic: Plan Locks


Automatic Unit of Recovery End

The SQLOPTION Multi-User startup option can be used to automatically close CICS and DLI units of recovery that are left open. For more information on SQLOPTION, see the CA Datacom/DB Database and System Administration Guide.

Note: A unit of recovery will not be ended if it is still active in the Multi-User Facility (such as when waiting on a plan lock).

If an ISOLEVEL=U application with an open cursor exists for longer than the limit specified in the SQLOPTION Multi-User startup option, the application will receive a -135 SQLCODE (INVALID CURSOR STATE) when it tries to continue scrolling.

Units of recovery that are automatically timed out are not reported.