PM75358: ODBC DRIVER DOE NOT RETURN PROPER DATATYPE FOR TIMESTAMP CAUSING MQB BROKER TO REPORT UNSUPPORTED DATATYPE ERROR

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Intermittent errors occur in the MQBroker Environment:
    BIP2324E MQP3BRK IFT31 67 UNSUPPORTED DATATYPE '11' FETCHED FROM
    DATABASE TABLE COLUMN 'TXN_TMSTMP'. :
    ImbOdbcDynamicResultSet(536)
    
    Error detected, rethrowing. Unsupported SQL type. ': :   MP
    
    SQLDescribeCol returns: dataType, colSize ' , 11, 26 instead of
    93,26
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of DB2 10 for z/OS ODBC/CLI.       *
    ****************************************************************
    * PROBLEM DESCRIPTION: SQLDescribeCol() incorrectly returns    *
    *                      ODBC 2.0 datetime values while the      *
    *                      environment attribute                   *
    *                      SQL_ATTR_ODBC_VERSION is set to         *
    *                      SQL_OV_ODBC3.                           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When environment attribute SQL_ATTR_ODBC_VERSION is set to
    SQL_OV_ODBC3, calling SQLDescribeCol() for a datetime column
    may return an ODBC 2.0 datetime value when running in a
    multi-threaded environment and another thread simultaneously
    tries to execute SQLGetTypeInfo() with a data type of
    SQL_DATE, SQL_TIME, or SQL_TIMESTAMP
    

Problem conclusion

  • Code has been changed so that SQLDescribeCol() returns correct
    datetime values when SQL_ATTR_ODBC_VERSION = SQL_OV_ODBC3.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM75358

  • Reported component name

    DB2 ODBC/JDBC/S

  • Reported component ID

    5740XYR02

  • Reported release

    A17

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    YesHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-10-18

  • Closed date

    2013-01-18

  • Last modified date

    2013-02-11

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

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

    UK91051

Modules/Macros

  •    DSNAOCLI DSNAOC0Q DSNAOC13 DSNAOC14 DSNAOC15
    DSNAOG0Q DSNAOG13 DSNAOG14 DSNAOG15 DSNAOSDK
    

Fix information

  • Fixed component name

    DB2 ODBC/JDBC/S

  • Fixed component ID

    5740XYR02

Applicable component levels

  • RA17 PSY UK91051

       UP13/01/29 P F301

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS
SQLJ/JDBC

Software version:

A17

Reference #:

PM75358

Modified date:

2013-02-11

Translate my page

Machine Translation

Content navigation