PM82999: NEW FUNCTION: SUPPORT EVALUNC AT STATEMENT LEVEL VIA CLI

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

Closed as new function.

Error description

New function: Support EVALUNC at statement level via CLI.

Local fix

N/A

Problem summary

****************************************************************
* USERS AFFECTED: All DB2 10 Users *
****************************************************************
* PROBLEM DESCRIPTION: With Zparm EVALUNC in effect, *
* when some applications query *
* non-UTS rows, uncommitted deleted *
* rows were skipped. If those *
* uncommitted deleted rows were *
* rolled back, the application *
* would not be able to return them *
* back to the user. *
****************************************************************
* RECOMMENDATION: *
****************************************************************
System zparm EVALUNC controls whether predicate
evaluation is to be allowed on uncommitted data.
When zparm EVALUNC was set to YES, Data that did
not satisfy the predicate during evaluation but
then, because of undo processing (ROLLBACK or
statement failure), reverted to a state that did
satisfy the predicate was missing from the answer
set. Since EVALUNC is a system option, individual
query statement is not able to turn it off.