PM91243: ABEND0C4 RC00000010 AT DSNSLD1 .DSNSVBK UK77823 OFFSET100A WHEN USING EXPLAIN FOR A QUERY.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND0C4 RC00000010 occurred at DSNSLD1.DSNSVBK UK77823
  when running Explain:
  EXPLAIN PLAN SET QUERYNO = 1 FOR SELECT EMPNO, FIRSTNME, SALARY
  FROM FINAL TABLE ( MERGE INTO EMP AS EMP2 USING ( VALUES(
  '999999', 'TAKER' ,77777)) AS T (EMPNO, FIRSTNME, SALARY)
  ON (EMP2.FIRSTNME = T.FIRSTNME) WHEN MATCHED THEN UPDATE
  SET SALARY = EMP2.SALARY + 5000WHEN NOT MATCHED THEN INSERT
  (EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,SALARY)VALUES (
  '999999','TAKER',' ','SUZUKY','E9V',77777));
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS, DB2 10 for z/OS and      *
  *                 DB2 11 for z/OS users of a query referencing *
  *                 a partition-by-growth table.                 *
  ****************************************************************
  * PROBLEM DESCRIPTION: An ABEND0C4 RC00000010 at               *
  *                      DSNSLD1.DSNSVBK may occur when running  *
  *                      a query referencing a                   *
  *                      partition-by-growth table. After the    *
  *                      abend, DB2 may also be brought down.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  An ABEND0C4 RC00000010 at DSNSLD1 .DSNSVBK may occur when
  running a query referencing a partition-by-growth table. After
  the abend, DB2 may also be brought down.
  
  It is because when running such query, a storage overlay may
  occur due to wrongly referencing an array index when retrieving/
  updating data for a partition-by-growth table. If the storage
  overlay happens at the critical storage control block
  information area, it can further bring down DB2.
  
  Following is an example of a failing query:
  
  EXPLAIN PLAN SET QUERYNO = 1 FOR
  SELECT EMPNO, FIRSTNME, SALARY
    FROM FINAL TABLE
    ( MERGE INTO EMP AS EMP2
      USING ( VALUES ('123456', 'ABCDE' ,11111))
      AS T (EMPNO, FIRSTNME, SALARY)
      ON (EMP2.FIRSTNME = T.FIRSTNME)
      WHEN MATCHED THEN UPDATE
      SET SALARY = EMP2.SALARY + 100
      WHEN NOT MATCHED THEN INSERT
      (EMPNO,FIRSTNME,MIDINIT,LASTNAME,WORKDEPT,SALARY)
      VALUES ('123456','ABCDE',' ','WXYZ','ABC',11111)
    );
  

Problem conclusion

• DB2 is modified to reference the correct array index to prevent
  a storage overlay.
  
  Additional Keywords: SQLSTORAGE DB2OVRLAY/K PBG UTS ABEND0C4
                       RC00000010
  

Temporary fix

• *********
  * HIPER *
  *********
  

Comments

APAR Information

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

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

  UK96548 UK96549 UK96550

Modules/Macros

• DSNXOCN  DSNXOLCM DSNXOLM1 DSNXOTPL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK96548

     UP13/08/24 P F308 ½

• RB10 PSY UK96549

     UP13/08/24 P F308 ½

• R910 PSY UK96550

     UP13/08/24 P F308 ½

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.