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

Obtain the fix for this APAR.

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.
  

Problem conclusion

Temporary fix

Comments

• DB2 provides the ability to override ZPARM EVALUNC for
  individual remote statements via IBM Data Server Driver
  for ODBC and CLI.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK93716

Modules/Macros

• DSNIACCH DSNIONX2 DSNIOST2 DSNIRNXT DSNIRPRE
  DSNISFRL DSNISFS  DSNISRID DSNKCKOP DSNKFLST DSNKFPRV DSNKFTCH
  DSNKINSL DSNKNXT2 DSNLXPRS DSNLXRSS DSNXERT2 DSNXOMI  DSNXOMS
  DSNXOUID
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK93716

     UP13/05/12 P F305

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.