DB2 FOR LUW / DB2FORLUW / 970 - DB2

It was determined that during heavy concurrent insert/update 
operations involving code page conversion into a unicode 
database that the malloc'ing of memory from the OS can become a 
bottleneck during the code page conversion process. 
 
environment: 
 
1. DB2 9.5 and up 
2. The database codepage is UTF. 
3. The application codepage is not. 
4. There are frequent and concurrent insert/update to the 
database. 
 
this was uncovered during a customer PMR with 50-100 concurrent 
import jobs against the same table.  After a certain point the 
percentage of time spent in ossLockGetConflict() reaches 75% 
trying to malloc and free memory.

Users Affected: Any doing heavy concurrent insert/update 
 
operations with code page conversion. 
Problem Description: During a heavy concurrent insert / update 
with code page conversion, perfomance can be affected by memory 
operations 
Problem Summary: see above.

DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Problem was first fixed in Version 9.7 FixPak 3

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

28.04.2010
07.10.2010
07.10.2010

9.7.