IBM Support

PI22945: QUERY CONTAINING THE TIME FUNCTION MAY GET INCORROUT

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A query having a WHERE clause comparing TIME(timestamp column)
    with a column created as TIME returned 0 rows when running on
    the accelerator.
    Without IDAA rows where selected for the same query.
    TIME format on accelerator includes microseconds, so needs to be
    truncated to compare with an DB2 on z/OS time format.
    .
    IDAAV4R1/K
    

Local fix

  • n.a.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 for z/OS who use            *
    *                 query acceleration.                          *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR fixes possible incorrect      *
    *                      output when a query with the TIME()     *
    *                      scalar function is executed on an       *
    *                      accelerator.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    This APAR fixes possible incorrect output when a query with the
    TIME() scalar function is executed on an accelerator when the
    expression is a timestamp data type. The hour, minute, second
    and fractional seconds are included in the result of TIME()
    when executed on an accelerator. The correct behavior for
    TIME() is to return the hour, minute, and second.
    
    Keywords:
    IDAAV3R1/K IDAAV4R1/K SQLINCORR SQLINCORROUT INCORROUT
    DB2INCORR/K SQLTIME
    

Problem conclusion

  • DB2 code is fixed to return the correct result.
    

Temporary fix

  • *********
    * HIPER *
    *********
    

Comments

  • ž**** PE14/12/04 FIX IN ERROR. SEE APAR PI29176  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PI22945

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-07-30

  • Closed date

    2014-10-02

  • Last modified date

    2014-12-05

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

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

    UI21946 UI21947

Modules/Macros

  •    DSNXONZA DSNXONZS
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI21946

       UP14/10/20 P F410

  • RB10 PSY UI21947

       UP14/10/20 P F410

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 #: PI22945

Modified date: 05 December 2014


Translate this page: