CACHESIZE bind option
The CACHESIZE option determines the size (in bytes) of the authorization cache acquired in the EDM pool for the plan.
| CACHESIZE |
|
On: BIND and REBIND PLAN |
At run time, the authorization cache stores user IDs authorized
to run. Consulting the cache can avoid a catalog lookup for checking
authorization to run the plan.
- decimal-value
- The size of the cache can range from 0 to 4096. Nonzero values that are not multiples of 256 round to the next highest multiple of 256. CACHESIZE(0) specifies creating no cache when the plan runs.
Defaults:
| Process | Default value |
|---|---|
| BIND PLAN | Value of AUTHCACH subsystem parameter |
| BIND PACKAGE | N/A |
| REBIND PLAN | Existing value |
| REBIND PACKAGE | N/A |
Catalog record: Column CACHESIZE of table SYSPLAN.