PM75883: ABEND04E RC00C90101 DSNIDM .DSNOPUFF:5003 WHEN SELECT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00C90101 DSNIDM .DSNOPUFF:5003 when select.
  (D162986)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS users of                 *
  *                 LOB and UNION/UNION ALL.                     *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E at DSNIDM DSNOPUFF 5003        *
  *                      could occur for an SQL statement that   *
  *                      satisfies the following conditions:     *
  *                      1. The SQL statement contains a table   *
  *                      expression or references to a view.     *
  *                      2. The view or table expression         *
  *                      contains UNION/UNION ALL.               *
  *                      3. One branch of the UNION/UNION ALL    *
  *                      select list references to a LOB column  *
  *                      from a base table. The other branch of  *
  *                      the UNION/UNION ALL select list         *
  *                      references to a LOB column from a non   *
  *                      base table.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  ABEND04E at DSNIDM DSNOPUFF 5003 could occur for an SQL
  statement that satisfies the following conditions:
  1. The SQL statement contains a table expression or
  references to a view.
  2. The view or table expression contains UNION/UNION ALL.
  3. One branch of the UNION/UNION ALL select list references
  to a LOB column from a base table. The other branch of
  the UNION/UNION ALL select list references to a LOB column
  from a non base table.
  
  
  For Example,
  CREATE TABLE TEST.T1(C11 CLOB(10) INLINE LENGTH 0);
  
  CREATE TABLE TEST.T2(C21 CLOB (10) INLINE LENGTH 0);
  
  SELECT CY, RAND()
  FROM TABLE (
    SELECT C21, RAND() FROM TEST.T2
    UNION ALL
    SELECT COL1, RAND()
    FROM TABLE (SELECT C11, RAND()
              FROM TEST.T1
    ) AS TE1(COL1,COL2))TY(CY,CZ)
  ORDER BY 2;
  
  The abend may occur for the SELECT statement above because
  DB2 did not handle the LOB column in the UNION ALL correctly.
  

Problem conclusion

• DB2 was fixed to handle the LOB column in the UNION/UNION ALL
  correctly.
  
  Additional Keywords: SQLLOB SQLUNION SQLUNIONALL SQLVIEW SQLTBLX
                       ERQUAL5003
  

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:

  UK91308

Modules/Macros

•    DSNXOB2
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UK91308

     UP13/02/16 P F302

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.