A fix is available
APAR status
Closed as program error.
Error description
DB2 might produce incorrect results when running queries with equality timestamp predicates Description: Under rare scenarios, DB2 might produce incorrect results if the following conditions are true: 1) The query contains two or more subselects and tables 2) Each of these have atleast one column of type TIMESTAMP with default precision 6 3) One or more of these columns are projected out from the select 4) The columns also contains an equality predicate with a string representation of timestamp eg. Select * from T1, (Select TS from T2 where T2.TS = '2015-01-01 00:00:00') as tmp where T1.TS = '2015-01-01 00:00:00' and tmp.TS = '2015-01-01 00:00:00'
Local fix
Workaround: 1) Turn on statement concentrator 2) Modify the query to introduce T1.TS = T2.TS predicate
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.1 Fix Pack 6 * ****************************************************************
Problem conclusion
First fixed in DB2 10.1 Fix Pack 6
Temporary fix
Comments
APAR Information
APAR number
IT13347
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
YesHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-01-22
Closed date
2017-03-02
Last modified date
2017-03-02
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
RA10 PSN UP
FIX
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 March 2017