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.
| APRETAINDUP |
|
On: REBIND PACKAGE, and REBIND TRIGGER PACKAGE |
This option only applies when PLANMGMT(BASIC) or PLANMGMT(EXTENDED) are in effect.
- ( YES )
- DB2 retains an old package copy
- ( NO )
- DB2 does not retain an old package copy
Defaults:
| Process | Default value |
|---|---|
| BIND PLAN | N/A |
| BIND PACKAGE | N/A |
| REBIND PLAN | N/A |
| REBIND PACKAGE | YES |
| REBIND TRIGGER PACKAGE | YES |
