Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC99388 Status: Closed

DB2 .NET PROVIDER NOT PERFORMING CODE PAGE CONVERSION ON DATE, TIME,
TIMESTAMP FROM ZOS WHEN IDAA QUERY ACCELERATION ENABLED

product:
DB2 CONNECT / DB2CONNCT / A10 - DB2
Problem description:
This APAR is similar to the following APAR except in the IBM DB2 
.Net Provider IBM.Data.DB2 
 
IC88670: CLP & CLI NOT PERFORMING CODE PAGE CONVERSION ON DATE, 
TIME and TIMESTAMP VALUES FROM ZOS when IDAA Query Acceleration 
is enable 
 
Symptoms include: 
 
SET CURRENT QUERY ACCELERATION = ALL; 
SELECT * FROM SCHEMA.TABLE FETCH FIRST 100 ROWS ONLY; 
 
Stack trace: 
 
at IBM.Data.DB2Types.DB2TimeStamp..ctor(Int32 year, Int32 month, 
Int32 
day, Int32 hour, Int32 minute, Int32 second, Int64 fraction, 
Int32 
precision, Boolean bTException, Boolean WithTruncate) 
at IBM.Data.DB2.DB2DataBuffer.a(Byte* A_0, Int32 A_1, Int32 A_2) 
at IBM.Data.DB2.DB2DataBuffer.k(DB2DataWrapper A_0, DDEntry A_1) 
at IBM.Data.DB2.DB2DataBuffer.a(DB2DataWrapper A_0, DDEntry A_1) 
at 
IBM.Data.DB2.DB2DataBuffer.GetRowData(DB2DataWrapperCollection 
dataWrappers, DB2DataDescriptor outputDD) 
at IBM.Data.DB2.DB2DataReader.Read() 
 
Outer exception: 
 
 
IBM.Data.DB2.DB2Exception: ERROR [58005] [IBM][DB2.NET] SQL0902 
An 
unexpected exception has occurred in Process: 3108 Thread 24 
AppDomain: 
Name:program.exe 
There are no context policies. 
Function: DB2DataReader.Read() 
CallStack: at System.Environment.GetStackTrace(Exception e, 
Boolean 
needFileInfo) 
at System.Environment.get_StackTrace() 
at IBM.Data.DB2.DB2ConnPool.HandleUnknownErrors(String 
strFncMsg, 
Exception exception, Boolean bThrow) 
at IBM.Data.DB2.DB2DataReader.Read()
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Windows .Net users                                           * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V10.1 Fix Pack 5 or higher.                   * 
****************************************************************
Local Fix:
The problem does not occur when IDAA QUERY ACCELERATION = NONE 
is set.
Solution
First fixed in DB2 V10.1 Fix Pack 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.02.2014
30.07.2015
30.07.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.5 FixList