PM35418: ABEND0C4 RC38 DUE TO ONE BYTE OVERLAY (X'D5')

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Multiple overlays can occur with this storage overaly.
  SMCOVERLAY
  ABEND04E-00E20029 DSNSVBK +0A30
  ABEND0C4-00000038 DSNXEFB +0886
  ABEND0C4-00000038 DSNXOTF +28BA
  ABEND0C4-00000038 DSNXOCU +0272
  ABEND0C4-00000010 DSNSVBK +101C
  ABEND0C4-00000010 DSNICMT2 +574A
  ABEND0C4-00000010 DSNIPSFI +0676
  ABEND0C4-00000010 DSNICMT2 +5784
  ABEND0C4-00000010 DSNICUBC +0EC4
  The CAT control block is overlaid, or the CUB, or the SPA, with
  a character N (hex X'D5').  This can also be seen in REG 4 or
  REG 5.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 9 for z/OS users of common table     *
  *                 expression with order by clause or           *
  *                 fetch first clause and GENERATED attribute   *
  *                 column.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND0C4 RC00000010 in                  *
  *                      DSNIDM .DSNICUBC+0EC could occur        *
  *                      when a sql statement satisfies the      *
  *                      following conditions:                   *
  *                      1. a common table expression is         *
  *                         referenced,                          *
  *                      2. an order by clause or fetch first    *
  *                         clause is referenced in the common   *
  *                         table expression,                    *
  *                      3. a column in common table expression  *
  *                         is from a base table column with     *
  *                         GENERATED attribute.                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ABEND0C4 RC00000010 in DSNIDM .DSNICUBC+0EC could occur
  when a sql statement satisfies the following conditions:
  1. a common table expression is referenced,
  2. an order by clause or fetch first clause is referenced in
     the common table expression,
  3. a column in common table expression is from a base table
     column with GENERATED attribute.
  The following example could recreate the problem:
  
  CREATE TABLE TT1
   (C1  INTEGER GENERATED ALWAYS AS IDENTITY,
    C2 INTEGER,
    C3 CHAR(5),
    C4 VARCHAR(10));
  
  CREATE VIEW VV1(C1, C2, C3, C4) AS
   (SELECT C1, C2, C1, C4 FROM TT1);
  
   WITH X1 AS (
     SELECT C1 FROM VV1
     WHERE C2 = 1
     ORDER BY  C3 DESC  FETCH FIRST 10 ROWS ONLY )
   SELECT C1
   FROM X1
   WITH UR FOR READ ONLY ;
  

Problem conclusion

• DB2 is updated to handle the above sql statement correctly.
  Additional Keywords: SQLORDERBY SQLCTE SQLFFNR
  

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:

  UK67660

Modules/Macros

• DSNXOMTX
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R910 PSY UK67660

     UP11/05/27 P F105

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.