home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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 IT00568 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 / A50 - 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 Applications                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 10.5 Fixpack 4                                * 
****************************************************************
Local Fix:
The problem does not occur when IDAA QUERY ACCELERATION = NONE 
is set.
Solution
First fixed in DB2 10.5 Fixpack 4
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
24.03.2014
09.09.2014
09.09.2014
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.4 FixList