News

Latest versions	fixlist
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Have problems? - contact us.
Register for free
Contact form

DB2 - Problem description

Problem IC80013	Status: Closed
DECLARE GLOBAL TEMPORARY TABLE WITH REPLACE OPTION MIGHT CAUSE DOUBLE FREE IN XA ENVIRONMENT.
product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
In XA connection, declare global temporary table WITH REPLACE option might cause double free as below: 2010-10-18-23.47.52.225880+120 I1182384A1848 LEVEL: Severe PID : 1421654 TID : 25962 PROC : db2sysc 0 INSTANCE: db2inst NODE : 000 DB : SAMPLE APPHDL : 0-262 APPID: 192.168.1.1.4032.1010182147 AUTHID : DB2INST EDUID : 25962 EDUNAME: db2agent (SAMPLE) 0 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 0x07000000e0208020 DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes 0x07000000E0208008 : FAB0 7000 000E 0200 0000 0000 0000 0000 ..p............. 0x07000000E0208018 : 0700 0000 E020 80A8 ..... .. DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes 0x07000000E0208020 : 0000 0000 0000 0040 0000 0000 0000 0000 .......@........ 0x07000000E0208030 : 0000 0010 0000 0D00 0000 0000 0000 0000 ................ 0x07000000E0208040 : 0100 0000 0000 0000 DB2C AFE8 0000 0038 .........,.....8 CALLSTCK: [0] 0x0900000012970948 pdLog + 0xD4 [1] 0x090000000F360D64 @79@sqloDiagnoseFreeBlockFailure__FP8SMemFBlk + 0x150 [2] 0x0900000012AC53FC sqlofmblkEx + 0x90 [3] 0x090000000EB15B78 sqlrl_userTempDrop__FP8sqlrr_cbP19sqlrl_userTempEntryPUciT3T4UsT 7T4 + 0xC30 [4] 0x0900000010D7F0B0 sqlrl_userTempDropAll__FP8sqlrr_cbP16sqlr_usertemp_cb + 0x1C4 [5] 0x0900000010D7E8A8 sqlrl_userTempDropAll__FP8sqlrr_cbP16sqlr_usertemp_cb@glueB8A + 0x74 [6] 0x09000000105F9AF8 sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9b + 0x200 [7] 0x090000001270EA94 sqlrxend__FP8sqlrr_cbP15SQLXA_CALL_INFOi + 0x638 [8] 0x0900000012727868 sqlrr_xend__FP14db2UCinterface + 0x1D0 [9] 0x0900000010AC5D54 sqljsSyncEnd__FP14db2UCinterface + 0x5F8 2010-10-18-23.47.52.234609+120 I1184233A461 LEVEL: Severe PID : 1421654 TID : 25962 PROC : db2sysc 0 INSTANCE: db2inst NODE : 000 DB : SAMPLE APPHDL : 0-262 APPID: 192.168.1.1.4032.1010182147 AUTHID : DB2INST EDUID : 25962 EDUNAME: db2agent (SAMPLE) 0 FUNCTION: DB2 UDB, SQO Memory Management, sqloDiagnoseFreeBlockFailure, probe:30 DATA #1 : String, 12 bytes Double free. This problem happens only in v9.7 fp3.
Problem Summary:
**************************************************************** * USERS AFFECTED: * * Users who use DGTT WITH REPLACE on XA connections. * **************************************************************** * PROBLEM DESCRIPTION: * * n XA connection, declare global temporary table WITH REPLACE * * option might cause double free as below: * * * * 2010-10-18-23.47.52.225880+120 I1182384A1848 LEVEL: * * Severe * * PID : 1421654 TID : 25962 PROC : * * db2sysc * * 0 * * INSTANCE: db2inst NODE : 000 DB : * * SAMPLE * * APPHDL : 0-262 APPID: * * 192.168.1.1.4032.1010182147 * * AUTHID : DB2INST * * EDUID : 25962 EDUNAME: db2agent (SAMPLE) 0 * * 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 * * 0x07000000e0208020 * * DATA #3 : Block header, PD_TYPE_BLK_HEADER, 24 bytes * * 0x07000000E0208008 : FAB0 7000 000E 0200 0000 0000 0000 0000 * * ..p............. * * 0x07000000E0208018 : 0700 0000 E020 80A8 * * ..... .. * * DATA #4 : Data header, PD_TYPE_BLK_DATA_HEAD, 48 bytes * * 0x07000000E0208020 : 0000 0000 0000 0040 0000 0000 0000 0000 * * .......@........ * * 0x07000000E0208030 : 0000 0010 0000 0D00 0000 0000 0000 0000 * * ................ * * 0x07000000E0208040 : 0100 0000 0000 0000 DB2C AFE8 0000 0038 * * .........,.....8 * * CALLSTCK: * * [0] 0x0900000012970948 pdLog + 0xD4 * * [1] 0x090000000F360D64 * * @79@sqloDiagnoseFreeBlockFailure__FP8SMemFBlk + 0x150 * * [2] 0x0900000012AC53FC sqlofmblkEx + 0x90 * * [3] 0x090000000EB15B78 * * sqlrl_userTempDrop__FP8sqlrr_cbP19sqlrl_userTempEntryPUciT3T * * 4UsT * * 7T4 * * + 0xC30 * * [4] 0x0900000010D7F0B0 * * sqlrl_userTempDropAll__FP8sqlrr_cbP16sqlr_usertemp_cb + * * 0x1C4 * * [5] 0x0900000010D7E8A8 * * sqlrl_userTempDropAll__FP8sqlrr_cbP16sqlr_usertemp_cb@glueB8 * * A + * * 0x74 * * [6] 0x09000000105F9AF8 * * sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9b + 0x200 * * [7] 0x090000001270EA94 * * sqlrxend__FP8sqlrr_cbP15SQLXA_CALL_INFOi + 0x638 * * [8] 0x0900000012727868 sqlrr_xend__FP14db2UCinterface + * * 0x1D0 * * [9] 0x0900000010AC5D54 sqljsSyncEnd__FP14db2UCinterface + * * 0x5F8 * * * * 2010-10-18-23.47.52.234609+120 I1184233A461 LEVEL: * * Severe * * PID : 1421654 TID : 25962 PROC : * * db2sysc * * 0 * * INSTANCE: db2inst NODE : 000 DB : * * SAMPLE * * APPHDL : 0-262 APPID: * * 192.168.1.1.4032.1010182147 * * AUTHID : DB2INST * * EDUID : 25962 EDUNAME: db2agent (SAMPLE) 0 * * FUNCTION: DB2 UDB, SQO Memory Management, * * sqloDiagnoseFreeBlockFailure, probe:30 * * DATA #1 : String, 12 bytes * * Double free. * * * * This problem happens only in v9.7 fp3/3a. * **************************************************************** * RECOMMENDATION: * * Please upgrade to V9.7 FixPack 4 or later. * ****************************************************************
Local Fix:

Solution
This problem is first fixed in V9.7 FixPack 4.
Workaround
not known / see Local fix
Timestamps
Date - problem reported : Date - problem closed : Date - last modified :	25.11.2011 11.06.2012 11.06.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP4
Problem solved according to the fixlist(s) of the following version(s)