Specifying T for the SQL Preprocessor's PLNCLOSE= option (to close the access plan at unit of recovery end) causes any opened tables to be closed, except when another unit of recovery is currently accessing the table.
If the table is the last table open for an area, the area is "physically" closed, that is to say it is closed by the operating system. We recommend that tables frequently accessed with PLNCLOSE=T be opened in a non-SQL User Requirements Table to avoid this overhead. This User Requirements Table need never be used, but it will keep the areas open.
Note: Plan binding uses the CA Datacom Datadictionary, the Schema Information Tables (SIT), and the Optimizer message table (SYSMSG) areas. Binding executes faster if there is a User Requirements Table that holds those areas open. The Temporary Table Manager (TTM) area should also be held open because it too may be used during the execution of binding.
|
Copyright © 2014 CA.
All rights reserved.
|
|