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

DB2 LOOP IN SQLEML_UTL_TCP_READ_LINE

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
System experienced a loop in sqleml_utl_tcp_read_line when 
called by a trigger using UTL_SMTP. 
 
The following Stack Trace was collected at the time of the 
problem: 
<StackTrace> 
##### Object: /lib/sparcv9/libc.so.1 
_so_recv(0xfffffffe9f880998,0xfffffffe007d6a40,0xfffffffe9f8809b 
8,0xfffffffe9f888970,0xfffffffe007daa38,0xfffffffe007d6a38) + 
0xc 
##### Object: /opt/IBM/db2/V9.7/bin/routine/db2modlib 
sqleml_utl_tcp_read_line(0xfffffffe9f880998,0xfffffffe007d6a40,0 
xfffffffe9f8809b8,0xfffffffe9f888970,0xfffffffe007daa38,0xffffff 
fe007d6a38) + 0x31c 
##### Object: /opt/IBM/db2/V9.7/lib64/libdb2e.so.1 
sqloInvokeFnArgs(0xffffffff13c25610,0xfffffffe9f8801a4,0xfffffff 
e9f888a08,0x0,0x0,0xffffffff6968e6e7) + 0x118 
__1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf 
_b_i_(0xffffffff6968e3c0,0xfffffffe007dcfa4,0x9,0xfffffffeb24245 
a8,0xfffffffe9e21b940,0xfffffffeb24245a8)+ 0x92c 
__1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff6968e3c0,0 
x108305c,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 
0x3c4 
__1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x1728,0x 
0,0x0,0xffffffff7c91dfa0) + 0x524 
__1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff 
ffff6968ec18,0xfffffffe9e21b940,0xc9e08,0x2000,0x1400) + 0x668 
__1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 
81823e4,0x1400,0xffffffff695f3880,0xfffffffe9e21b940,0xf60,0xd) 
+ 0x2ec4 
__1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff 
eb1c10090,0xfffffffeb1c12cd0,0x1,0xfffffffeb1c12cd0,0x0,0xffffff 
ff695f3880) + 0x454 
__1cKpvmPackageOexecuteSection6MpnFsqlca_Ib_i_(0xfffffffe007dea3 
0,0xfffffffebc300638,0x2000,0xfffffffe007dea40,0x0,0x0) + 0x64c 
__1cDPVMDrun6M_i_(0x2800c2,0xfffffffe007de730,0xffffffff7c91dfa0 
,0xfffffffffffffe51,0x0,0x1) + 0xe74 
pvm_entry(0x4,0x4000,0xfffffffe007de730,0x0,0xfffffffebc300638,0 
xffffffff7b5286a8) + 0x488 
sqloInvokeFnArgs(0xffffffff77ba0e90,0x2,0xfffffffe007e05d0,0x2,0 
x4,0xffffffff7b8aa6e6) + 0x5c 
__1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf 
_b_i_(0xffffffff694e5830,0xfffffffe007e10a4,0xfffffffda5580080,0 
xfffffffeb1c1b7e0,0xfffffffe9e21b940,0xfffffffeb1c1b7e0) + 0xf74 
__1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff694e5830,0 
x8,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 
__1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x3000,0x 
8000000,0x0,0xffffffff7c91dfa0) + 0x524 
__1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff 
ffff694e5f48,0xfffffffe9e21b940,0xc9e08,0x2000,0x1400) + 0x668 
__1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 
81823e4,0x1400,0xffffffff695f3520,0xfffffffe9e21b940,0xf60,0xd) 
+ 0x2ec4 
__1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff 
eb2350090,0xfffffffeb2352cd0,0x1,0xfffffffeb2352cd0,0x0,0xffffff 
ff695f3520) + 0x454 
__1cKpvmPackageOexecuteSection6MpnFsqlca_Ib_i_(0xfffffffe007e2b3 
0,0xfffffffeb049f078,0x2000,0xfffffffe007e2b40,0x0,0x0) + 0x64c 
__1cDPVMDrun6M_i_(0x2800c2,0xfffffffe007e2830,0xffffffff7c91dfa0 
,0xfffffffffffffe51,0x0,0x1) + 0xe74 
pvm_entry(0x4,0x4000,0xfffffffe007e2830,0x0,0xfffffffeb049f078,0 
xffffffff7b5286a8) + 0x488 
sqloInvokeFnArgs(0xffffffff77ba0e90,0x2,0xfffffffe007e46d0,0x4,0 
x4,0xffffffff7b8aa6e6) + 0x5c 
__1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf 
_b_i_(0xffffffff694fe7a0,0xfffffffe007e51a4,0xffffffff345fce20,0 
xfffffffeb235b7e0,0xfffffffe9e21b940,0xfffffffeb235b7e0) + 0xf74 
__1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff694fe7a0,0 
x8,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 
__1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x3000,0x 
8000000,0x0,0xffffffff7c91dfa0) + 0x524 
__1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff 
ffff694fefc0,0xfffffffe9e21b940,0xc9e08,0x2000,0x1400) + 0x668 
__1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 
81823e4,0x1400,0xffffffff695f2b00,0xfffffffe9e21b940,0xf60,0xd) 
+ 0x2ec4 
__1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff 
eb1ec0090,0xfffffffeb1ec2cd0,0x1,0xfffffffeb1ec2cd0,0x0,0xffffff 
ff695f2b00) + 0x454 
__1cKpvmPackageOexecuteSection6MpnFsqlca_Ib_i_(0xfffffffe007e6c3 
0,0xfffffffeb04edc38,0x2000,0xfffffffe007e6c40,0x0,0x0) + 0x64c 
__1cDPVMDrun6M_i_(0x2800c2,0xfffffffe007e6930,0xffffffff7c91dfa0 
,0xfffffffffffffe51,0x0,0x1) + 0xe74 
pvm_entry(0x4,0x4000,0xfffffffe007e6930,0x0,0xfffffffeb04edc38,0 
xffffffff7b5286a8) + 0x488 
sqloInvokeFnArgs(0xffffffff77ba0e90,0x2,0xfffffffe007e87d0,0x4,0 
x4,0xffffffff7b8aa6e6) + 0x5c 
__1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf 
_b_i_(0xffffffff6825a9b0,0xfffffffe007e92a4,0xffffffff344e33a0,0 
xfffffffeb1ecb7e0,0xfffffffe9e21b940,0xfffffffeb1ecb7e0) + 0xf74 
__1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff6825a9b0,0 
x8,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 
__1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x3000,0x 
8000000,0x0,0xffffffff7c91dfa0) + 0x524 
__1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff 
ffff6825b018,0xfffffffe9e21b940,0xc9e08,0x2000,0x1400) + 0x668 
__1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 
81823e4,0x1400,0xffffffff695f2220,0xfffffffe9e21b940,0xf60,0xd) 
+ 0x2ec4 
__1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff 
eb2040090,0xfffffffeb2042cd0,0x1,0xfffffffeb2042cd0,0x0,0xffffff 
ff695f2220) + 0x454 
__1cKpvmPackageOexecuteSection6MpnFsqlca_Ib_i_(0xfffffffe007ead3 
0,0xfffffffe9fca8ff8,0x2000,0xfffffffe007ead40,0x0,0x0) + 0x64c 
__1cDPVMDrun6M_i_(0x2800c2,0xfffffffe007eaa30,0xffffffff7c91dfa0 
,0xfffffffffffffe51,0x0,0x1) + 0xe74 
pvm_entry(0x4,0x4000,0xfffffffe007eaa30,0x0,0xfffffffe9fca8ff8,0 
xffffffff7b5286a8) + 0x488 
sqloInvokeFnArgs(0xffffffff77ba0e90,0x2,0xfffffffe007ec8d0,0x4,0 
x4,0xffffffff7b8aa6e6) + 0x5c 
__1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf 
_b_i_(0xffffffff62922ac8,0xfffffffe007ed3a4,0xffffffff342c0a40,0 
xfffffffeb204b7e0,0xfffffffe9e21b940,0xfffffffeb204b7e0) + 0xf74 
__1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff62922ac8,0 
x8,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 
__1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x3000,0x 
8000000,0x0,0xffffffff7c91dfa0) + 0x524 
__1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff 
ffff62923188,0xfffffffe9e21b940,0xc9e08,0x2000,0x1400) + 0x668 
__1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 
81823e4,0x1400,0xffffffff6818eba0,0xfffffffe9e21b940,0xf60,0xd) 
+ 0x2ec4 
__1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff 
e9ee0baa0,0xfffffffe9ee0e6e0,0x1,0xfffffffe9ee0e6e0,0x0,0xffffff 
ff6818eba0) + 0x454 
__1cKpvmPackageOexecuteSection6MpnFsqlca_Ib_i_(0xfffffffe007eee3 
0,0xfffffffeb04eae18,0x2000,0xfffffffe007eee40,0x0,0x0) + 0x64c 
__1cDPVMDrun6M_i_(0x2800c2,0xfffffffe007eeb30,0xffffffff7c91dfa0 
,0xfffffffffffffe51,0x0,0x1) + 0xe74 
pvm_entry(0x4,0x0,0xfffffffe007eeb30,0x0,0xfffffffeb04eae18,0xff 
ffffff7b5286a8) + 0x488 
sqloInvokeFnArgs(0xffffffff77ba0e90,0x2,0xfffffffe007f09d0,0x4,0 
x4,0xffffffff7b8aa6e6) + 0x5c 
__1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf 
_b_i_(0xffffffff69670730,0xfffffffe007f14a4,0xffffffff341c6f80,0 
xfffffffe9ee171f0,0xfffffffe9e21b940,0xfffffffe9ee171f0) + 0xf74 
__1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff69670730,0 
x8,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 
__1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x3000,0x 
8000000,0x0,0xffffffff7c91dfa0) + 0x524 
__1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff 
ffff69670f50,0xfffffffe9e21b940,0xc9e08,0x2000,0x1400) + 0x668 
__1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 
81823e4,0x1400,0xffffffff6818b760,0xfffffffe9e21b940,0xf60,0xd) 
+ 0x2ec4 
__1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff 
e9ee001d8,0xfffffffe9ee02e18,0x1,0xfffffffe9ee02e18,0x0,0xffffff 
ff6818b760) + 0x454 
__1cKpvmPackageOexecuteSection6MpnFsqlca_Ib_i_(0xfffffffe007f2f3 
0,0xfffffffe9fc60638,0x2000,0xfffffffe007f2f40,0x0,0x0) + 0x64c 
__1cDPVMDrun6M_i_(0x2800c2,0xfffffffe007f2c30,0xffffffff7c91dfa0 
,0xfffffffffffffe51,0x0,0x1) + 0xe74 
pvm_entry(0x4,0x1400,0xfffffffe007f2c30,0x0,0xfffffffe9fc60638,0 
xffffffff7b5286a8) + 0x488 
sqloInvokeFnArgs(0xffffffff77ba0e90,0x2,0xfffffffe007f4ad0,0x4,0 
x0,0xc6400) + 0x5c 
__1cTsqlriInvokerTrusted6FpnKsqlri_ufob_pnVsqlriRoutineErrorIntf 
_b_i_(0xffffffff6854aa40,0xfffffffe007f55a4,0xfffffffda5b35348,0 
xfffffffe9ee0b928,0xfffffffe9e21b940,0xfffffffe9ee0b928) + 0xf74 
__1cSsqlriInvokeInvoker6FpnKsqlri_ufob_b_i_(0xffffffff6854aa40,0 
x8,0xfffffffe007fff30,0x1,0x1b800000,0xffffffff7c91dfa0) + 0x3c4 
__1cJsqlricall6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0x0,0x0,0x800 
0000,0x0,0xffffffff7c91dfa0) + 0x524 
__1cTsqlriExecThreadFunc6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0xffff 
fffe9e21b940,0xffffffff6854b260,0x2,0xfffffffe9e21d0d8,0x0,0xfff 
ffffe9e21d0c8) + 0x2c 
__1cIsqlricse6FpnIsqlrr_cb__i_(0x1778,0xfffffffe9e21b940,0xfffff 
fff6854a990,0xffffffff6854a9c0,0x1788,0x9c00) + 0x1f4 
__1cTsqlriExecThreadFunc6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0xffff 
fffe9e21b940,0xffffffff6854a940,0xfffffffda5b357d8,0xfffffffe9e2 
1d0d8,0xffffffff6854b4e0,0xfffffffe9e21d0c8) + 0x2c 
__1cIsqlrival6FpnIsqlrr_cb__i_(0x1778,0xfffffffe9e21b940,0x1788, 
0xffffffff68547e20,0x9c00,0xffffffff7e7d4ad0) + 0x1d4 
__1cTsqlriExecThreadFunc6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0xffff 
fffe9e21b940,0xffffffff6854a918,0x1778,0xfffffffe9e21d0d8,0xffff 
ffff6854b5f8,0xfffffffe9e21d0c8) + 0x2c 
__1cIsqlriftr6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0xffffffff6854 
a7d0,0x1788,0xc6300,0xffffffff6854a778,0x1400) + 0x1a4 
__1cTsqlriExecThreadFunc6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0xffff 
fffe9e21b940,0xffffffff6854a778,0xfffffffe9e21d0c8,0xfffffffe9e2 
1d0d8,0xffffffff6854bad8,0xfffffffe9e21d0c8) + 0x2c 
__1cIsqlrievl6FpnIsqlrr_cb__i_(0x3f4910,0xfffffffe9e21b940,0x0,0 
x1400,0xffffffff6854b878,0xffffffff6854a320) + 0xfdc 
__1cTsqlriExecThreadFunc6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0xffff 
fffe9e21b940,0xffffffff6854b840,0x3,0xfffffffe9e21d0d8,0xfffffff 
f6854bc18,0xfffffffe9e21d0c8) + 0x2c 
__1cIsqlricse6FpnIsqlrr_cb__i_(0x1778,0xfffffffe9e21b940,0xfffff 
fff68548a40,0xffffffff68548a70,0x1788,0x9c00) + 0x1f4 
__1cTsqlriExecThreadFunc6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0xffff 
fffe9e21b940,0xffffffff685489f0,0x1778,0xfffffffe9e21d0d8,0xffff 
ffff6854bd10,0xfffffffe9e21d0c8) + 0x2c 
__1cIsqlriftr6FpnIsqlrr_cb__i_(0xfffffffe9e21b940,0xffffffff6854 
89f0,0x1788,0xc6300,0xffffffff685489c0,0x1400) + 0x1a4 
__1cPsqlriSectInvoke6FpnIsqlrr_cb_pnMsqlri_opparm__i_(0x0,0xffff 
ffff685489c0,0xfffffffe9e21b940,0x1788,0x1798,0x1400) + 0x6cc 
__1cbDsqlrr_process_execute_request6FpnIsqlrr_cb_ib_i_(0x1011101 
81823e4,0x1400,0xffffffff6818a9a0,0xfffffffe9e21b940,0xe7c,0x4) 
+ 0x2ec4 
__1cNsqlrr_execute6FpnOdb2UCinterface_pnJUCstpInfo__i_(0xfffffff 
e9f65af20,0x0,0x0,0x0,0x0,0xffffffff6818a9a0) + 0x454 
__1cTsqljs_ddm_excsqlstt6FpnOdb2UCinterface_pnNsqljDDMObject__i_ 
(0xfffffffe9f65af20,0xfffffffeb2c207c8,0xffffffff7d57fce8,0x0,0x 
1,0xfffffffeb2c20080) + 0x884 
__1cVsqljsParseRdbAccessed6FpnNsqljsDrdaAsCb_pnNsqljDDMObject_pn 
Odb2UCinterface__i_(0xfffffffeb2c20080,0xfffffffe007f7598,0xffff 
fffe9f65af20,0x200b,0x2000,0x0) + 0x280 
__1cKsqljsParse6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_pnIsqeAgent_ 
b_i_(0xfffffffeb2c20e08,0xfffffffe9f65af20,0x2028561a0,0xfffffff 
eb2c20e08,0x202859e68,0xfffffffeb2c20080)+ 0x71c 
__1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_ 
b_i_(0xfffffffe9f65af20,0x2028561a0,0xffffffff7d4f00c8,0xfffffff 
e007fff30,0xfffffffeb2c20080,0x0) + 0x81c 
__1cWsqljsSetupDrdaAsForApp6FpnNsqljsDrdaAsCb_pnOdb2UCinterface_ 
b_i_(0x2028561a0,0xfffffffe9fc576a0,0x1400,0xfffffffe9f65af20,0x 
0,0xfffffffeb2c20080) + 0x1d2c 
__1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_(0x20120f580, 
0xfffffffe007fff30,0x1,0x8300000000000000,0xfffffffe9fc576a0,0xf 
fffffff7c91dfa0) + 0xe20 
__1cRsqljsDrdaAsDriver6FpnSSQdDLCC_INITSTRUCT_T__i_(0x20120f580, 
0xffffffffffffffff,0x5800,0xfffffffe9fc57220,0xfffffffe9fc57220, 
0xfffffffe007fff30) + 0x1c0 
__1cIsqeAgentGRunEDU6M_v_(0x2028561a0,0x1400,0xffffffff7b59285f, 
0x18280400,0xffffffff7c91dfa0,0xffffffff7e3bb6d8) + 0x860 
__1cKsqlzRunEDU6FpcI_v_(0xfffffffe007fdd20,0xffffffff781439b8,0x 
1bef9ec,0x18d00000,0x0,0xffffffff7c91dfa0) + 0xd4 
sqloEDUEntry(0xffffffff5affaf90,0xfffffffe007fff30,0x8,0xfffffff 
f7e3bb750,0x18780000,0x0) + 0x3d4##### Object: 
/lib/sparcv9/libc.so.1 
_thr_slot_offset(0x0,0x0,0x0,0x0,0x0,0x0) + 0x488 
</StackTrace>
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All DB2 Users                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 and Fix Pack 10                   * 
****************************************************************
Local Fix:
Solution
Problem was first fixed in the DB2 Version 9.7 and Fix Pack 10
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.07.2014
10.11.2014
10.11.2014
Problem solved at the following versions (IBM BugInfos)
9.7.
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.10 FixList