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

Obtain the fix for this APAR.

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