IBM Support

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

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

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

Local fix

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

Problem summary

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

Problem conclusion

  • First fixed in DB2 V9.7 Fixpack 10
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT00566

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-03-24

  • Closed date

    2014-11-11

  • Last modified date

    2014-11-11

  • APAR is sysrouted FROM one or more of the following:

    IC99388

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IT00566

Modified date: 11 November 2014