SQL Considerations › SQL Plan Options Special Topics › Plan Locks

Plan Locks

Plan Locks

A plan cannot be rebound when in use. If (for a CICS application) R is specified for the SQL Preprocessor's PLNCLOSE= option, the plan remains in use until the SQL User Requirements Table is closed.

To determine which plans are being used, you can use CA Datacom/DB Utility's (DBUTLTY) COMM ALTER option as follows:

►►─ COMM OPTION=ALTER,TRACE=TRACEGLOBAL ──────────────────────────────────────►◄

This writes a report of all open plans (plus various other information about the state of the SQL subsystem) to the CA Datacom/DB Statistics and Diagnostics Area (PXX) when the SQL User Requirements Table is closed. Print the report using CA Datacom/DB Utility's (DBUTLTY) REPORT AREA=PXX option with FULL or TRACE specified for the DUMPS= keyword.

To turn off this option, use CA Datacom/DB Utility's (DBUTLTY) COMM ALTER option:

►►─ COMM OPTION=ALTER,TRACE=NONE ─────────────────────────────────────────────►◄

Note: For more information about using the CA Datacom/DB Utility (DBUTLTY), see the CA Datacom/DB DBUTLTY Reference Guide.