home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC75130 Status: Closed

MAXIMUM LENGTH LIKE PATTERNS MAY ENCOUNTER MEMORY VIOLATIONS IN DBCS
ENVIRONMENTS

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
Memory violations can happen if 
1. Database is created with codepage that allows DBCS data 
types. 
2. Query is using a double byte like pattern that is 32672 bytes 
in size.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DBCS LIKE pattern users in V91 and V95                       * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Several scenarios using 32672 byte like patterns (maximum    * 
* allowed) may encounter memory violations, when used in       * 
* double byte character set environments.                      * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Install V95FP8 which contains the fix, or upgrade to V97,    * 
* which also contains the fix.                                 * 
****************************************************************
Local Fix:
available fix packs:
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

Solution
Fixed in V95 FP8.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
19.03.2011
27.06.2011
27.06.2011
Problem solved at the following versions (IBM BugInfos)
9.5.FP8,
9.7.
Problem solved according to the fixlist(s) of the following version(s)
9.5.0.8 FixList