PM75883: ABEND04E RC00C90101 DSNIDM .DSNOPUFF:5003 WHEN SELECT

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PM75883

  • 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-10-25

  • Closed date

    2013-01-31

  • Last modified date

    2013-03-04

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



Rate this page:

(0 users)Average rating

Document information


More support for:

DB2 for z/OS

Software version:

A10

Reference #:

PM75883

Modified date:

2013-03-04

Translate my page

Machine Translation

Content navigation