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

Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows

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