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 | |
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) |