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

Load in DPF with ASC filetype and RECLEN option and a DECIMAL
partitioning column may trap.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
A Load executed in a DPF environment, when using the ASC 
filetype with the RECLEN option specified (ie fixed length), and 
a partitioning column that is of DECIMAL type, may trap in 
sqloDiagnoseFreeBlockFailure() with memory corruption symptoms, 
such as: 
 
2009-03-11-08.45.25.098534-240 I1190876A1737      LEVEL: Severe 
PID     : XXXXXXX              TID  : 1           PROC : 
db2lpart XXX 
INSTANCE: XXXXXXX              NODE : XXX 
APPHDL  : XXX-XXX              APPID: *XXXX.XXXXXXX.XXXXXXXXXXXX 
AUTHID  : XXXXXXX 
FUNCTION: DB2 UDB, SQO Memory Management, 
sqloDiagnoseFreeBlockFailure, probe:10 
MESSAGE : Possible memory corruption detected. 
 
DATA #1 : ZRC, PD_TYPE_ZRC, 4 bytes 
0x820F0002 
 
DATA #2 : Corrupt block address, PD_TYPE_CORRUPT_BLK_PTR, 8 
bytes 
0x0000000110308780 
 
DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes 
0x0000000110308768 : 002C AFE8 0000 0010 5F4B B8F1 01D0 00EF 
.,......_K...... 
0x0000000110308778 : FAB0 0000 0011 0301 
........ 
 
DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes 
0x0000000110308780 : 0000 0000 0000 0000 0000 0001 1030 8820 
.............0. 
0x0000000110308790 : 0000 0000 0000 0000 0000 0000 0000 0000 
................ 
0x00000001103087A0 : 0000 0000 0000 0000 DB2C AFE8 0000 0040 
.........,.....@ 
 
CALLSTCK: 
  [0] 0x0900000004D9F988 
@49@sqloDiagnoseFreeBlockFailure__FP8SMemFBlk + 0x92C 
  [1] 0x0900000004D9EF90 
sqloDiagnoseFreeBlockFailure__FP8SMemFBlk@glue214 + 0x74 
  [2] 0x0900000004714744 sqlofmblkEx + 0x384 
  [3] 0x0900000003DB5120 iDeallocate__17sqluCSerializableFv + 
0x1EC 
  [4] 0x0900000004B19BC4 
iDeallocate__27sqlusCPartRequestDescriptorFv + 0x8 
  [5] 0x0900000004B1974C iCleanUp__18sqlusCPartSubAgentFv + 
0x47C 
  [6] 0x090000000512B9F0 
sqlusSubAgentRouter__FP20sqle_agent_privatecbi + 0x378 
  [7] 0x09000000043CAAC0 
sqleSubRequestRouter__FP13sqle_agent_cbPUiT2 + 0x6B0 
  [8] 0x09000000041B0AE0 
sqleProcessSubRequest__FP13sqle_agent_cb + 0x21C 
  [9] 0x0900000004473FD8 sqleRunAgent__FPcUi + 0x8E4
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* Customers executing Load in a DPF environment, when using    * 
* the ASC filetype with the RECLEN option specified (ie fixed  * 
* length), and a partitioning column that is of DECIMAL type   * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A Load executed in a DPF environment, when using the ASC     * 
*                                                              * 
* filetype with the RECLEN option specified (ie fixed length), * 
* and                                                          * 
* a partitioning column that is of DECIMAL type, may trap in   * 
*                                                              * 
* sqloDiagnoseFreeBlockFailure() with memory corruption        * 
* symptoms.                                                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 V9.7 FP1                                      * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows

Lösung
Problem fixed in DB2 V9.7 Fix Pack 1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
22.10.2009
16.02.2010
16.02.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP1
Problem behoben lt. FixList in der Version
9.7.0.1 FixList