IBM Support

PI10167: NEW FUNCTION ON DB2 10 FOR Z/OS

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • New function for DB2 10 for z/OS
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 10 for z/OS who use         *
    *                 IBM DB2 Analytics Accelerator that will      *
    *                 use the new MEDIAN function.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR provides the new function     *
    *                      MEDIAN for execution only on an         *
    *                      accelerator.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR provides the new function MEDIAN for execution only on
    an accelerator.
    
    For a static SQL query that will use the new function above,
    BIND the package for the query after applying the PTF.
    
    Keywords
    IDAAV3R1/K IDAAV4R1/K SQLMEDIAN
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI10167

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function

  • Submitted date

    2014-01-22

  • Closed date

    2014-05-05

  • Last modified date

    2014-06-03

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

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

    UI17678

Modules/Macros

  • DSNXOBFA DSNXOBF3 DSNXODML DSNXODTR DSNXOD1  DSNXOEX1 DSNXOFN2
    DSNXOIN  DSNXOLTD DSNXONZA DSNXONZO DSNXONZQ DSNXOOS1 DSNXORFN
    DSNXOVD
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI17678

       UP14/05/20 P F405

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: A10

Reference #: PI10167

Modified date: 03 June 2014


Translate this page: