IBM Support

IT22945: SQLGETTYPEINFO RETURNS 255 FOR CHAR DATATYPE WHEN CONNECTION FROM V11 CLIENT TO V10.5 SERVER.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQLGetTypeInfo returns 255 for char datatype when connection
    from v11 client to v10.5 server.
    
    Recreate the issue with cli test script opt
    
    calldiag on
    quickc 1 1 aaa
    sqlallocstmt 1 1
    SQLGetTypeInfo 1 SQL_CHAR
    fetchall 1 1
    
    C:\Program Files\IBM\SQLLIB_01\BIN>db2 connect to aaa
    
       Database Connection Information
    
    Database server        = DB2/NT64 10.5.3
    SQL authorization ID   = IBM
    Local database alias   = AAA
    
    C:\Program Files\IBM\SQLLIB_01\BIN>db2cli < info.cli
    IBM DATABASE 2 Interactive CLI Sample Program
    (C) COPYRIGHT International Business Machines Corp. 1993,1996
    All Rights Reserved
    Licensed Materials - Property of IBM
    US Government Users Restricted Rights - Use, duplication or
    disclosure restricted by GSA ADP Schedule Contract with IBM
    Corp.
    > > SQLAllocEnv: rc = 0 (SQL_SUCCESS)
                 CLI henv = 1, Test Driver henv = 1
    SQLAllocConnect: rc = 0 (SQL_SUCCESS)
                 CLI hdbc = 1, Test Driver hdbc = 1
    SQLConnect: rc = 0 (SQL_SUCCESS)
    > SQLAllocStmt: rc = 0 (SQL_SUCCESS)
                  CLI hstmt = 1, Test Driver hstmt = 1
    > SQLGetTypeInfo: rc = 0 (SQL_SUCCESS)
    > FetchAll:  Columns: 19
      TYPE_NAME DATA_TYPE COLUMN_SIZE LITERAL_PREFIX LITERAL_SUFFIX
    CREATE_PARAMS NU
    LLABLE CASE_SENSITIVE SEARCHABLE UNSIGNED_ATTRIBUTE
    FIXED_PREC_SCALE AUTO_UNIQUE
    _VALUE LOCAL_TYPE_NAME MINIMUM_SCALE MAXIMUM_SCALE SQL_DATA_TYPE
    SQL_DATETIME_SU
    B NUM_PREC_RADIX INTERVAL_PRECISION
      CHAR, 1, 255, ', ', LENGTH, 1, 1, 3, -, 0, -, -, -, -, 1, -,
    -, -
    FetchAll: 1 rows fetched.
    >
    Memory count is 50
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher               *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 3 Fix Pack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT22945

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-10-26

  • Closed date

    2018-03-19

  • Last modified date

    2018-03-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 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 March 2018