|
Problem IC63984
|
Status: Closed |
Load in DPF with ASC filetype and RECLEN option and a DECIMAL partitioning column may trap. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| 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,
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
Problem fixed in DB2 V9.7 Fix Pack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.10.2009
16.02.2010
16.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
