APRETAINDUP bind option
The APRETAINDUP option determines whether or not Db2 retains an old package copy when access paths of the old copy are identical to the incoming copy.
| Command option | Option values | Used with |
|---|---|---|
| APRETAINDUP |
|
Note:
- The APRETAINDUP bind option is not valid for REBIND of packages for advanced triggers.
This option only applies when PLANMGMT(BASIC) or PLANMGMT(EXTENDED) are in effect.
Option descriptions for APRETAINDUP
- APRETAINDUP(YES)
- Db2 retains an old package copy
- APRETAINDUP(NO)
- Db2 does not retain an old package copy
Default values for APRETAINDUP
| Process | Default value |
|---|---|
| BIND PLAN | N/A |
| BIND PACKAGE | N/A |
| REBIND PLAN | N/A |
| REBIND PACKAGE | YES |
| REBIND TRIGGER PACKAGE | YES |