EXPLAIN PROCESSING field (ABEXP subsystem parameter)
The ABEXP subsystem parameter controls whether EXPLAIN processing is to occur during an automatic rebind.
| Acceptable values: | YES, NO |
|---|---|
| Default: | YES |
| Update: | option 24 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM ABEXP |
- YES
- EXPLAIN processing occurs during the automatic rebind of a plan or package when the bind option EXPLAIN(YES) is specified. If the PLAN_TABLE does not exist, the automatic rebind continues, but generates no EXPLAIN output. EXPLAIN processing does not occur during the automatic rebind of plans or packages with the bind option EXPLAIN(NO).
- NO
- EXPLAIN processing does not occur during the automatic rebind of a plan or package.