home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IT02727 Status: Geschlossen

WITH DATA_ENCRYPT A QUERY MAY FAIL AND RETURN SQL0902C.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to  DB2 LUW v9.7 Fixpack 10 or Later.                * 
****************************************************************
Local-Fix:
Lösung
First fixed in DB2 LUW v9.7 Fixpack 10.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.06.2014
17.11.2014
17.11.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP10
Problem behoben lt. FixList in der Version
9.7.0.10 FixList