|
Problem IT02729
|
Status: Closed |
WITH DATA_ENCRYPT A QUERY MAY FAIL AND RETURN SQL0902C. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
When AUTHENTICATION on the database server is set to
DATA_ENCRYPT, any data transferred between the server and the
client is encrypted.
It was found that, with DATA_ENCRYPT DB2 LUW client sometimes
fails to parse the query result, and returns SQL0902C.
db2diag.log:
2014-06-12-02.47.07.163620+120 I2928367A587 LEVEL: Error
PID : 13107552 TID : 1 PROC : db2bp
INSTANCE: db2inst1 NODE : 019 DB :
SAMPLE
APPID : *N22.db2inst1.140612004707
HOSTNAME: Q4DE8PSAZDV
EDUID : 1
FUNCTION: DB2 UDB, database utilities, sqluCheckSqlca,
probe:2356
MESSAGE : SQL0902C A system error occurred. Subsequent SQL
statements cannot
be processed. IBM software support reason code: "9".
DATA #1 : String, 12 bytes
This issue is incomplete fix for IC91371. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All Platforms *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 LUW v10.5 Fixpack 4 or Higher. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in DB2 LUW v10.5 Fixpack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.06.2014
15.09.2014
15.09.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
