PROGAUTH bind option
The PROGAUTH option specifies whether Db2 performs program authorization checking to determine whether Db2 can execute a plan.
| Command option | Option values | Used with |
|---|---|---|
| PROGAUTH |
|
- (DISABLE)
- Specifies that program authorization checking is not performed.
- PROGAUTH(ENABLE)
- Specifies that program authorization checking is performed. That
checking performs the following functions:
- Determines whether a program and plan combination is authorized to run.
If ENABLE is specified, a row must exist in table SYSIBM.DSNPROGAUTH for the plan that is specified in the BIND PLAN or REBIND PLAN statement. That row must also contain the name of a program that runs the plan. If the row is not correctly specified, Db2 returns a resource unavailable message when the program runs.
Default values for PROGAUTH
| Process | Default value |
|---|---|
| BIND PLAN | DISABLE |
| BIND PACKAGE | N/A |
| REBIND PLAN | Existing value |
| REBIND PACKAGE | N/A |
Catalog records for PROGAUTH
See the PROGAUTH column in SYSPLAN catalog table.