IBM Support

PM79378: ABEND0C4 RC00000011 DSNSLD1 DSNSVBK +121C OFFSET121C ABEND04E RC00E20002 DSNXEFB DSNSVBK +1956 OFFSET1956

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABEND0C4 RC00000011 DSNSLD1 DSNSVBK +121C OFFSET121C or
    ABEND04E RC00E20002 DSNXEFB DSNSVBK +1956 OFFSET1956
    due to overlaid DVS block
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 10 for z/OS users of searched        *
    *                 UPDATE of a symmetric view.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND04E RC00E20002 can happen at       *
    *                      Location DSNXEFB.DSNSVBK OFFSET1956     *
    *                      when processing a searched UPDATE of    *
    *                      a symmetric view (a view defined using  *
    *                      WITH CHECK OPTION).                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    ABEND04E RC00E20002 can happen at Location DSNXEFB.DSNSVBK
    OFFSET1956 when processing a searched UPDATE of a symmetric view
    and the following conditions are met:
    1. The query package is bound on pre Version 10, then runs on
       Version 10.
    2. Index scan is used to fetch the rows qualifying for update.
    3. All rows qualifying for the update are materialized into
       the workfile prior to performing the update.
    
    The abend occurs during the symmetric view validation due to
    the access type difference (index scan used for fetching the
    rows, but actual update involves table scan of a workfile).
    This problem happens because DB2 doesn't set several internal
    variables correctly.
    
    The following query illustrates how this abend can occur.
    
    Define a symmetric view
    CREATE VIEW   SYSADM.VIEW1
     (C1, C2, C3, C4, C5, C6, C7, C8
     )
     AS SELECT ALL C1,C2,C3,C4,C5,C6,C7,C8
     FROM SYSADM.TB1
     WHERE C8 <= 'N' AND C5 <= C6
             WITH CASCADED CHECK OPTION ;
    
    Issue an update query.
    EXEC SQL UPDATE VIEW1 SET C6 = : H WHERE C3 = : H AND
    AND C7 = : H AND C5 = : H AND C5 + 999 MICROSECOND < : H ;
    
    Above abend can happen when processing this update query. Rebind
    the package on Version 10 can be a workaround for this problem.
    

Problem conclusion

  • DB2 has been changed to set the internal variables correctly.
    
    Additional keywords : SQLVIEW SQLUPDATE SQLSYMMETRICVIEWCHECK
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM79378

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-12-17

  • Closed date

    2013-02-25

  • Last modified date

    2013-04-02

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

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

    UK92000

Modules/Macros

  • DSNXRUP9
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK92000

       UP13/03/13 P F303

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
02 April 2013