IBM Support

PI22945: QUERY CONTAINING THE TIME FUNCTION MAY GET INCORROUT

A fix is available

Obtain the fix for this APAR.

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 / Xsystem

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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"DB2 for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 March 2024

Page Feedback