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

DB2 CAN TRAP IN SQLRIGETNEXTINPUTDATAVALUE() WITH EVENT MONITORS
ACTIVE

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
With activated event monitors DB2 might trap with following 
stack: 
 
<StackTrace> 
##### Object: /opt/IBM/db2/V9.5/lib64/libdb2e.so.1 
__1cbAsqlriGetNextInputDataValue6FpnIsqlrr_cb_pnKsqlz_value_rl4_ 
v_(0x0,0xffffffff50bf5b58,0xffffffff50bf5b88,0xffffffff50bf5b80, 
0x1c0a0000,0x0) + 0x14c 
__1cSsqmGenActivityStmt6FpnOsqeApplication_pnTsqlrr_curr_activit 
y_pnNsqm_evmon_mgr_pnIsqlrr_cb_pnMsqmWttDvalue_bbpb9B9B9B_i_(0x7 
c00,0x100763fb7e0,0x2010ca038,0xffffffff6c1acc60,0xffffffff7bfeb 
463,0x1) + 0x22c4 
__1cNsqm_evmon_mgrQgenActivityEvent6MpnOsqeApplication_pnTsqlrr_ 
curr_activity_pnFsqlca_bbbpb77_i_(0x20064f2a0,0x200ff7200,0x32,0 
xb0,0xffffffff7cdb7c58,0x2010c9fe0) + 0x2cac 
__1cbAsqlrr_remove_curr_activity6FpnIsqlrr_cb_ippnTsqlrr_curr_ac 
tivity__i_(0xffffffff6c1acc60,0xffffffff50bf66d6,0xffffffff50bf6 
6e7,0x1000,0x200eb1560,0xffffffff7c9bb4e0) + 0x8f8 
__1cXsqlrr_activity_exe_stop6FpnIsqlrr_cb__i_(0xffffffff6c1acc60 
,0x1640,0x0,0x0,0x18900000,0x0) + 0xb1c 
__1cPsqlricls_simple6FpnIsqlrr_cb_il_i_(0x0,0xffffffff621833e8,0 
x200404200,0xffffffff6c1acc60,0xffffffff7c9bb4e0,0xffffffff62183 
360) + 0x1664 
__1cbBsqlrr_process_close_request6FpnIsqlrr_cb_iiii_i_(0xfffffff 
fffffff06,0x200402014,0xffffffff6c1acc60,0xffffffff62183360,0x14 
00,0xffffffff621833e8) + 0x2a8 
__1cRsqlrr_fetch_error6FpnIsqlrr_cb_pnOdb2UCinterface_pnPdb2UCCu 
rsorInfo_ii_i_(0xffffffff6c1acc60,0xffffffff6c6bfd80,0x16e8,0x20 
0dac8a0,0x16e8,0x0) + 0x6f0 
__1cKsqlrr_open6FpnOdb2UCinterface_pnPdb2UCCursorInfo__i_(0xffff 
ffff6c6bfd80,0xffffffff6c680148,0x0,0x1400,0xffffffff6c1acc60,0x 
ffffffff62183360) + 0xcec 
__1cQsqljs_ddm_opnqry6FpnOdb2UCinterface_pnNsqljDDMObject__i_(0x 
ffffffff6c6bfd80,0xffffffff7aa975f8,0x3,0xffffffff6c680ce0,0xfff 
fffff6c680148,0x0) + 0x26c 
__1cVsqljsParseRdbAccessed6FpnNsqljsDrdaAsCb_pnNsqljDDMObject_pn 
Odb2UCinterface__i_(0xffffffff6c680080,0xffffffff50bf7570,0xffff 
ffff6c6bfd80,0x200c,0x2000,0x4) + 0x2c4 
__1cKsqljsParse6FpnNsqljsDrdaAsCb_pnOdb2UCinterface__i_(0xffffff 
ff6c680080,0xffffffff6c6bfd80,0x0,0x0,0xffffffffffffffff,0x2000) 
+ 0x4bc 
__1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_ 
b_i_(0xffffffff6c6bfd80,0x200eb1560,0xa1658,0xffffffff7c9bb4e0,0 
xffffffff6c680080,0x200eb1dc4) + 0x97c 
__1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_ 
b_i_(0x200eb1560,0xffffffff6c6bf920,0x9f6d8,0xffffffff6c680080,0 
xffffffff6c6bfd80,0x0) + 0x1218 
__1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_(0xffffffff7c 
db7c58,0xffffffff7d4e5ce8,0x0,0xffffffff6c680080,0x200eb1560,0x0 
) + 0xa98 
__1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_(0x9f400,0x1, 
0xffffffff7d4e5ce8,0xa1658,0xffffffff6c6bf920,0xffffffff50bfff58 
) + 0x1b4 
__1cIsqeAgentGRunEDU6M_v_(0x200eb1560,0x0,0x18280400,0xffffffff7 
c9bb4e0,0xffffffff7d4e5ce8,0x4180) + 0x7b8 
__1cKsqlzRunEDU6FpcI_v_(0xffffffff50bfdd20,0x0,0xffffffff7cdcce5 
8,0xa1400,0x0,0x18d00000) + 0x64 
sqloEDUEntry(0xffffffff5cfeeb20,0xffffffff50bfff58,0xaf6fb6,0xff 
ffffff7d4e5d60,0x18780000,0xffffffff7c9bb4e0) + 0x3dc 
##### Object: /lib/sparcv9/libc.so.1 
_thr_slot_offset(0x0,0x0,0x0,0x0,0x0,0x0) + 0x484 
</StackTrace>
Problem Summary:
USERS AFFECTED: All 
 
PROBLEM DESCRIPTION: 
 
see ERROR DESCRIPTION 
 
PROBLEM SUMMARY: 
 
see ERROR DESCRIPTION
Local Fix:
deactivate event monitors
available fix packs:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
The complete fix for this problem first appears in DB2 UDB 
Version 9.5 FixPak 6.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
28.01.2010
14.05.2010
14.05.2010
Problem solved at the following versions (IBM BugInfos)
9.5.
Problem solved according to the fixlist(s) of the following version(s)