DSNL302I option-name IS SET TO option-value

Explanation

A MODIFY DDF command has changed an option.

option-name

The name of the DDF processing option.

option-value

The new value of the named processing option.

When option-name is ACCTG the following values are possible:

COMMIT_WITH_NO_OPEN_RESOURCES

When this option is set back to its default setting, or if the setting was never changed, Db2 generates an accounting trace record when no open resource exists past a commit or rollback. If any of the following resources remain open and pending, Db2 does not generate an accounting trace record:

• Open WITH HOLD cursors
• Declared global temporary tables that are not dropped
• Unreleased LOB locators
• A commit processed by a stored procedure when running with 2-phase commit rules
• Allocated RELEASE DEALLOCATE packages (due to the -MODIFY DDF PKGREL(BNDOPT) option)
• Allocated KEEPDYNAMIC YES packages

However, if only one of the last two preceding resources types, but not both, are open after a commit or rollback, Db2 generates an accounting trace record occurrence after a commit or rollback.

ALLCOMMIT

When this option is set, Db2 generates an accounting trace record occurrence after any commit or rollback. However, Db2 still maintains the WLM enclave that was created by Db2, prior to the initial requested transaction which left open resources. Also, Db2 maintains information so that when the DBAT is terminated after completing the work requests from its client connection, it deletes the enclave and informs WLM of the transactions that were completed.

When option-name is PKGREL, the following values are possible:

BNDOPT

When a connection which has used a high-performance DBAT terminates, the high-performance DBAT is also be deallocated.

BNDPOOL

DDF processing is the as BNDOPT, with the following exception. When a connection that was used for a high-performance DBAT terminates, the high-performance DBAT is pooled. The pooled DBAT can then be used by another connection that presents a request to the subsystem.

COMMIT

Packages are always allocated under RELEASE(COMMIT) rules regardless of their package RELEASE bind option value.

When an access thread has completed a unit of work, and the DBAT can be pooled, DDF pools the DBAT, makes an accounting record, deletes the current WLM enclave, and inactivates the connection. Pooled access threads release all package allocation locks.

If the CMTSTAT subsystem parameter is set to ACTIVE, then the message will always indicate that PKGREL IS SET TO COMMIT, regardless of the value specified on the command.