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 IC75428 Status: Geschlossen

-902 MAY BE ENCOUNTERED WITH LIKE PATTERN USAGE INVOLVING SHORTER
(NON-LOB/NON-LONG) VALUES

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
-902 error may be experienced in certain LIKE usage scenarios, 
meeting the following conditions: 
 
1. LIKE pattern involving relatively small values (non-LOB, 
non-Long types) 
2. Single Byte Character Set (SBCS) to Double Byte Character Set 
(DBCS) conversion needs to take place during LIKE processing.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 V95/97 Like pattern users involving non-LOB/non-LONG     * 
* value that would require SBCS to DBCS conversion during      * 
* evaluation                                                   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* -902 may be returned during Like pattern processing when     * 
* non-LOB/non-LONG values are used, and SBCS to DBCS           * 
* conversion is required as well.                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to 95FP8 containing the fix.                         * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Upgrade to fixpack containing the code fix.
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC75440 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
30.03.2011
27.06.2011
27.06.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP8
Problem behoben lt. FixList in der Version
9.5.0.8 FixList