Previous Topic: OPEN/CLOSE EfficiencyNext Topic: Plan Locks


Automatic Unit of Recovery End

Automatic Unit of Recovery End

The SQLOPTION MUF 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 MUF (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 MUF 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.