PACKAGE RELEASE COMMIT field (PKGREL_COMMIT subsystem parameter)
The PKGREL_COMMIT subsystem parameter specifies whether persistent Db2 threads release packages that are active on the thread at ROLLBACK or COMMIT, if certain Db2 operations are waiting for exclusive access to the package. This parameter is applicable to both local and distributed threads.
The value in this field is meaningful only for packages that are bound with the RELEASE(DEALLOCATE) bind option.
| Acceptable values: | YES, NO |
|---|---|
| Default: | YES |
| Update: | option 29 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM PKGREL_COMMIT |
- YES
- For packages that are bound with the RELEASE(DEALLOCATE) option, the following operations can proceed at COMMIT or ROLLBACK while the package is active and allocated for a persistent Db2 thread:
- BIND REPLACE PACKAGE and REBIND PACKAGE requests, including automatic rebind for online schema changes (DDL statements) for tables and indexes that are statically referenced by the package
- Online REORG operations that materialize pending definition changes for objects that are statically referenced by the package
YES is the default value.
- NO
- Db2 does not implicitly release an active package at COMMIT or ROLLBACK when it is activate and allocated for a persistent Db2 thread.