|
Problem IT04077
|
Status: Closed |
SQLERRD REPORTS -1 AT SQLCA UNEXPECTEDLY UNDER CODE CONVERSION |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Problem Reproducible steps:
1. Set client/application codepage to 1386
$ db2set DB2CODEPAGE=1386
2. Connect to a database in UTF-8 and get returned SQLCA
$ db2 -a "connect to utf8"
==>> will report -1 at sqlerrd (2) as below:
-----
SQLCA Information
sqlcaid : SQLCA sqlcabc: 136 sqlcode: 0 sqlerrml: 50
sqlerrmc: 86 1208 CHENSR UTF8 QDB2/LINUXX8664 7 7 0 1386 0
sqlerrp : SQL0905B
sqlerrd : (1) 3 (2) -1 (3) 0
(4) 1 (5) 1 (6) 0
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 00000
-----
Symptom:
sqlerrd reports -1 in SQLCA unexpectedly under code conversion
environment
Root cause:
DB2 incorrectly assign -1.
Condition of problem:
Only code conversion environment. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* DB2 UDB Version 9.7 *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.7 FixPack 11. *
**************************************************************** |
| Local Fix: |
|
| Solution |
Problem was first fixed in DB2 UDB Version 9.7 FixPack 11. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 28.08.2014
07.10.2015
07.10.2015 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP11
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.11
|
 |
