QSYS2.QIBM_SQL_NO_RLA_CANCEL environment variable

The SQL Cancel support includes logic to insure that Db2 for i programs are active on the stack of the initial thread in the target job for the cancel request. Applications that use native database I/O can observe cases where the cancel request is processed and a record level access (RLA) operation ends with MSGCPF5257 followed by MSGCPF9999.

An environment variable can be used by the customer to direct Db2 for i to avoid canceling RLA access operations. Upon the first cancel request for a specific job, the environment variable QIBM_SQL_NO_RLA_CANCEL will be accessed. If the environment variable exists, the cancel request will not be honored when RLA is the only database work on-going within the initial thread at the time the cancel request is received.

The environment variable is SQL Cancel operational switch. The variable can be created at the job or system level. Creating it once at the system level will affect how SQL Cancels are processed for all jobs.

ADDENVVAR ENVVAR(QIBM_SQL_NO_RLA_CANCEL)
or
ADDENVVAR ENVVAR(QIBM_SQL_NO_RLA_CANCEL) LEVEL(*SYS)