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.
    

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 number

    PM82999

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-18

  • Closed date

    2013-04-23

  • Last modified date

    2013-06-04

  • 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM82999

Modified date:

2013-06-04

Translate my page

Machine Translation

Content navigation