IBM Support

PM68447: ABEND0C4 RC0038 DSNXGRDS.DSNXOEX1+22DE ON QUERY WITH CTE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ABEND0C4 RC38 DSNXGRDS.DSNXOEX1+22DE when running a complex
    query which contains CTE (Common Table Expression).
    
    Additional Keywords: SQLCTE
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 and DB2 10 for z/OS users of       *
    *                 SQL statements that reference to             *
    *                 view or table expressions and SET            *
    *                 function.                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION: ABEND0C4 RC0038 in                      *
    *                      DSNXGRDS.DSNXOEX1:22DE                  *
    *                      may occur for an SQL statement          *
    *                      that satisfies the following            *
    *                      conditions:                             *
    *                      1. The statement references to a        *
    *                      table expression or view                *
    *                      2. The table expression or view         *
    *                      is merged.                              *
    *                      3. The table expression or view column  *
    *                      appears in a predicate and is an        *
    *                      argument of a SET function.             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    ABEND0C4 RC0038 in
    DSNXGRDS.DSNXOEX1:22DE may occur for an SQL statement
    that satisfies the following conditions:
    1. The statement references to a table expression or view
    2. The table expression or view is merged.
    3. The table expression or view column appears in a
    predicate and is an argument of a SET function.
    
    For Example,
    
    SELECT * FROM (SELECT MAX(COL1)
                     FROM  (SELECT 2 AS COL1 FROM SYSIBM.SYSDUMMY1
                            )T1(COL1)
                   )T2(COL1) WHERE T2.COL1 > 10;
    
    The SELECT statement above may cause an abend since the
    column T2.COL1 in the predicate is not merged correctly.
    

Problem conclusion

  • DB2 was fixed to merge the table expression or view that
    contains a SET function correctly.
    
    Additional Keywords: SQLVIEW SQLTABLEEXPR
                         SQLSETFUNCTION
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM68447

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-09

  • Closed date

    2012-10-08

  • Last modified date

    2012-11-01

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

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

    UK82408 UK82409

Modules/Macros

  • DSNXOEX1 DSNXOMTX
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UK82408

       UP12/10/24 P F210

  • R910 PSY UK82409

       UP12/10/24 P F210

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.1","Edition":"","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
01 November 2012