DB2 FOR LUW / DB2FORLUW / B10 - DB2

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

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

n/a

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
 

First fixed in Db2 11.1 Mod 3 Fix Pack 3

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

26.10.2017
19.03.2018
19.03.2018