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 IC84167 Status: Closed

TRAP IN SQLBFIX WHEN RUNNING UPDATE STATEMENT WITH WHERE CURRENT OF CURSOR
(DEFINED AS WITH HOLD) CLAUSE ON A PARTITIONED TABLE

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
Instance may crash in the following codepath when running update 
statement with where current of cursor (defined as with hold) 
clause on a partitioned table. 
 
Here is a sample stacktrace for the EDU that trapped :- 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x0900000006D973D0 sqlbfix__FP11SQLB_FIX_CB - 0x5BC 
0x0900000006D96D1C @99@1@sqlbFixPage__FP11SQLB_FIX_CBiUiT2 + 
0x24 
0x0900000006D90F20 sqldFetchDirect__FP13SQLD_DFM_WORK - 0x468 
0x0900000006D3AA88 @101@sqldDirectFetch__FP8SQLD_CCB + 0x6C 
0x0900000006D3A980 
sqldRowFetch__FP8sqeAgentP8SQLD_CCBUlT3PP10SQLD_VALUEP8SQLZ_RIDT 
3P12SQLD_ID_LISTP9SQLP_LSN8 + 0x10 
0x0900000006DA9D4C sqlriFetch__FP8sqlrr_cbP9sqlri_taol + 0x28 
0x0900000007638E48 sqlriita__FP8sqlrr_cb + 0x8 
0x0900000006DA784C sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 
0x7E8 
0x0900000006DCEA50 sqlrr_process_execute_request__FP8sqlrr_cbi + 
0x358 
0x0900000006DE40AC sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo 
+ 0xFC 
0x0900000006DE88C0 
sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x514 
0x0900000006DE9120 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface - 0x44 
0x0900000006DE8F20 
sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface + 0x27C 
0x0900000006DEA668 @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0x180 
0x0900000006C3BB38 
@63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98 
0x0900000006C3B980 
@63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0 
0x0900000006C3B6E0 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0xD8 
0x0900000006C3DEF0 RunEDU__8sqeAgentFv + 0x124 
0x0900000006C36F48 EDUDriver__9sqzEDUObjFv + 0x78 
0x0900000006CF33F8 sqloEDUEntry + 0x57C 
</StackTrace>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* DB2 Users using partitioned table                            * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to DB2 Version 10.1.1 or higher                      * 
****************************************************************
Local Fix:
available fix packs:
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows

Solution
Problem was first fixed in DB2 Version 10 Fix Pack 1
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
13.06.2012
05.11.2012
05.11.2012
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.1 FixList
10.5.0.1 FixList