IBM Support

PK92405: ABEND0C4 DSNXRCSF+08A2 USING COLUMN SCALAR FUNCTION. 09/07/27 PTF PECHANGE

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • ABEND0C4 in DSNXRCSF+8A2 at PTF level UK44120.  R4 and R5 are
    both X'40404040'.
    Note that is error is caused by UK44120.
    

Local fix

  • A REBIND will not fix this.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 9 for z/OS users of aggregate        *
    *                 or scalar functions and PK76100 / UK44120    *
    *                 is applied.                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: An ABEND0C4 at DSNXRCSF +08A2 may       *
    *                      occur when a query contains an          *
    *                      aggregate function or the MIN or MAX    *
    *                      scalar function and PK76100 is          *
    *                      applied.                                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    An ABEND0C4 at DSNXRCSF+08A2 may occur when a query contains
    an aggregate function or MIN/MAX scalar function and PK76100 is
    applied. The problem occurs because the internal structures
    are interpreted incorrectly.
    
    Following is an example of failing query:
    INSERT INTO T1 (C1, C2, ...)
    SELECT MAX('01', CHAR(DECIMAL(C1,2,0)-1)), C2, ...
      FROM TA
     WHERE ...
    

Problem conclusion

  • DB2 is fixed to interpret the aggregate function and the MIN/MAX
    scalar function correctly.
    
    Additional keywords: SQLSETFUNCTION SQLSCALAR SQLMIN
                         SQLMAX
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK92405

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    910

  • Status

    CLOSED PER

  • PE

    YesPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-07-27

  • Closed date

    2009-09-11

  • Last modified date

    2009-10-02

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

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

    UK50056

Modules/Macros

  • DSNXRCSF DSNXRGBJ DSNXRISF DSNXRSFJ DSNXRSFN
    DSNXRSGB DSNXRSJ
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • R910 PSY UK50056

       UP09/09/29 P F909

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.



Document information

More support for: DB2 for z/OS

Software version: 9.1

Reference #: PK92405

Modified date: 02 October 2009


Translate this page: