DB2 - Problem description
| Problem IT06574 | Status: Closed |
SQLERRD REPORTS -1 AT SQLCA UNEXPECTEDLY UNDER CODE CONVERSION | |
| product: | |
DB2 FOR LUW / DB2FORLUW / A50 - 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 10.5 * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Version 10.5 FixPack 7. * **************************************************************** | |
| Local Fix: | |
| Solution | |
Problem was first fixed in DB2 UDB Version 10.5 FixPack 7. | |
| Workaround | |
not known / see Local fix | |
| Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.01.2015 19.01.2016 19.01.2016 |
| Problem solved at the following versions (IBM BugInfos) | |
| Problem solved according to the fixlist(s) of the following version(s) | |
| 10.5.0.7 |
|