|
Problem IT02727
|
Status: Closed |
WITH DATA_ENCRYPT A QUERY MAY FAIL AND RETURN SQL0902C. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - 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 v9.7 Fixpack 10 or Later. *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in DB2 LUW v9.7 Fixpack 10. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 23.06.2014
17.11.2014
17.11.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
