DB2 CONNECT / DB2CONNCT / 970 - DB2

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()

**************************************************************** 
* USERS AFFECTED:                                              * 
* Windows                                                      * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 Fixpack 10                               * 
****************************************************************

The problem does not occur when IDAA QUERY ACCELERATION = NONE 
is set.

First fixed in DB2 V9.7 Fixpack 10

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

24.03.2014
11.11.2014
11.11.2014

9.7.FP10