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

Obtain the fix for this APAR.

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 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.