IBM Support

IT25633: PMR37651,999,000 BOOL DATATYPE MISMATCH B/W MICROSOFT AND DB2 LUW ( DB2 ON CLOUD)

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Business Impact Level: This is POC and we are migrating .NET
    application from Netezza to IIAS
    Business Impact Description: Application migration is failing
    for BOOL datatypE
    
    Environment: IIAS version 1.0.8
    
    Mismatch of Boolean data type :
    MS data type is BOOL where as DB2 LUW type is has SQL_Boolean
    which is causing the problem. They are trying to connect via
    ODBC and when accessing boolean datatype, they are getting error
    unknown SQL type -16
    
    ============
    Bool types in DB2 are known as SQL_BOOLEAN(2 bytes length) and
    in microsoft ODBC specification, matching data type for BOOL is
    SQL_BIT(1 byte length).
    Since application is fetching describe information for bool type
    and DB2 server is returning SQL_BOOLEAN(2 bytes length), this
    does not map to SQL_BIT. as per ODBC standard, SQL_BOOLEAN is 16
    and SQL_BIT is -7.
    But we are DB2 compliant as DB2 expects SQL_BOOLEAN for Boolean
    type.
    https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com
    .ibm.db2.luw.apdv.cli.doc/doc/r0000526.html
    
    Either way, we need a mapping. We cannot go back and change
    server interpretation, however, we can provide patch in client
    to have correct mapping according to ODBC standard.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * DB2 ODBC users                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 11.1.4.4                              *
    ****************************************************************
    

Problem conclusion

  • Upgrade to DB2 version 11.1.4.4 or later.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT25633

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-07-10

  • Closed date

    2018-12-02

  • Last modified date

    2019-02-19

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

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

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"11.1","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
14 December 2020