CACHESIZE bind option
The CACHESIZE option determines the size (in bytes) of the authorization cache acquired in the EDM pool for the plan.
| Command option | Option values | Used with |
|---|---|---|
| CACHESIZE |
|
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.
- CACHESIZE(decimal-value)
- The size of the cache can range 0 - 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.
Default values for CACHESIZE
| Process | Default value |
|---|---|
| BIND PLAN |  4K |
| BIND PACKAGE | N/A |
| REBIND PLAN | Existing value |
| REBIND PACKAGE | N/A |
Catalog record for CACHESIZE
See the CACHESIZE column in SYSPLAN catalog table.