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

DB2 LOOP IN SQLEML_UTL_TCP_READ_LINE

product:
DB2 FOR LUW / DB2FORLUW / A10 - 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                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW 10.1 Fix Pack 5                           * 
****************************************************************
Local Fix:
Solution
First fixed in DB2 LUW 10.1 Fix Pack 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.07.2014
13.07.2015
13.07.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.5 FixList