DB2 - Problem description
Problem IT18655 | Status: Closed |
-901 SQLERRMC: PROBE 020 IN SQLKTOPN(), MSG=TQ ALREADY OPEN | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
On DB2 DPF a Stored procedure execution can fail with the following on a remote node for a fetch request db2diag.log will have entries of this nature: FUNCTION: DB2 UDB, table Q services, sqlktopn, probe:20 MESSAGE : DIA0001E An internal error occurred. Report the following error code : "Line=00536, rc1=0x82170001, rc2=0x00000004, rc3=0x7fff4cd127a0, msg=TQ already open". EDUID : 317146 EDUNAME: db2agntp (FTDW) 61 FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, probe:300 DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes sqlcaid : SQLCA sqlcabc: 136 sqlcode: -901 sqlerrml: 44 sqlerrmc: probe 020 in sqlktopn(), msg=TQ already open sqlerrp : SQLRI50E sqlerrd : (1) 0x82170001 (2) 0x00000001 (3) 0x00000000 (4) 0x00000000 (5) 0xFFFFEA92 (6) 0x0000003D sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: Stacks will include: sqlriReceiveDss sqlrr_dss_router sqlrr_subagent_router sqleSubRequestRoute sqleProcessSubRequest example: -----FUNC-ADDR---- ------FUNCTION + OFFSET------ 0x00007FFFF1D6157F ossDumpStackTraceEx + 0x01ef (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2osse.so.1) 0x00007FFFF1D5C33E _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2osse.so.1) 0x00007FFFF4AFBB63 sqlo_trce + 0x03fb (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF4B44912 sqloDumpDiagInfoHandler + 0x00e0 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF79CD7E0 address: 0x00007FFFF79CD7E0 ; dladdress: 0x00007FFFF79BE000 ; offset in lib: 0x000000000000F7E0 ; (/lib64/libpthread.so.0) 0x00007FFFF79CA97C pthread_kill + 0x002c (/lib64/libpthread.so.0) 0x00007FFFF4B43D11 sqloDumpEDU + 0x0045 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF3D75FEB _Z15sqldDumpContextP9sqeBsuEduiiiiiPKcPvi + 0x068f (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF3593B02 _Z15sqlrr_dump_ffdcP8sqlrr_cbii + 0x0572 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF37B7B50 _Z13sqlzeDumpFFDCP8sqeAgentjP5sqlcai + 0x0020 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF37B7237 _Z11sqlzeMapZrcP8sqeAgentjmjP5sqlcaiPK12sqlzeContextb + 0x046 3 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF35C0018 _Z11sqlrrMapZrcP8sqlrr_cbjmi + 0x0038 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF4EE37A6 _Z15sqlriReceiveDssP8sqlrr_cbP16sqlkdRqstRplyFmtPl + 0x0530 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF4D20627 _Z16sqlrr_dss_routerP8sqlrr_cb + 0x027f (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF4D22A9D _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0e53 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF3EB5B59 _Z20sqleSubRequestRouterP8sqeAgentPjS1_ + 0x0679 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF3EB65C8 _Z21sqleProcessSubRequestP8sqeAgent + 0x00a6 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF30B2ECB _ZN8sqeAgent6RunEDUEv + 0x0641 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF37B7F00 _ZN9sqzEDUObj9EDUDriverEv + 0x00a6 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF37B7E57 _Z10sqlzRunEDUPcj + 0x0009 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF35164DC sqloEDUEntry + 0x02f4 (/var/ibmdb2/nypxt680/sqllib/lib64/libdb2e.so.1) 0x00007FFFF79C5AA1 address: 0x00007FFFF79C5AA1 ; dladdress: 0x00007FFFF79BE000 ; offset in lib: 0x0000000000007AA1 ; (/lib64/libpthread.so.0) 0x00007FFFF1113AAD clone + 0x006d (/lib64/libc.so.6) or traps with Stack: ====================== 0x00007FFFF1DD4CFB ossDumpStackTraceEx + 0x01ef 0x00007FFFF1DCFABA _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm + 0x00cc 0x00007FFFF4B29B2F sqlo_trce + 0x03fb 0x00007FFFF4B72925 sqloEDUCodeTrapHandler + 0x0265 0x00007FFFF79CE7E0 address: 0x00007FFFF79CE7E0 ; dladdress: 0x00007FFFF79BF000 ; offset in lib: 0x000000000000F7E0 ; 0x00007FFFF40923AE _Z8sqlktopnP8sqeAgentP9sqlri_taoP9SQLE_KRCB + 0x047e 0x00007FFFF59174ED _Z8sqlriopnP8sqlrr_cbP9sqlri_taoPi + 0x0b01 0x00007FFFF4F0CF3B _Z15sqlriReceiveDssP8sqlrr_cbP16sqlkdRqstRplyFmtPl + 0x063d 0x00007FFFF4D4BCAF _Z16sqlrr_dss_routerP8sqlrr_cb + 0x027f 0x00007FFFF4D4E21A _Z21sqlrr_subagent_routerP8sqeAgentP12SQLE_DB2RA_T + 0x0f48 0x00007FFFF3EF77B9 _Z20sqleSubRequestRouterP8sqeAgentPjS1_ + 0x0679 0x00007FFFF3EF8228 _Z21sqleProcessSubRequestP8sqeAgent + 0x00a6 0x00007FFFF3119DE7 _ZN8sqeAgent6RunEDUEv + 0x0649 0x00007FFFF380ADB8 _ZN9sqzEDUObj9EDUDriverEv + 0x00a6 0x00007FFFF380AD0F _Z10sqlzRunEDUPcj + 0x0009 0x00007FFFF35723C4 sqloEDUEntry + 0x02f4 0x00007FFFF79C6AA1 address: 0x00007FFFF79C6AA1 ; dladdress: 0x00007FFFF79BF000 ; offset in lib: 0x0000000000007AA1 ; 0x00007FFFF118793D clone + 0x006d | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 10.5 Fix Pack 9 or higher * **************************************************************** | |
Local Fix: | |
db2set APM_THROTTLE=25 | |
Solution | |
First fixed in Db2 10.5 Fix Pack 9 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.01.2017 29.09.2017 29.09.2017 |
Problem solved at the following versions (IBM BugInfos) | |
9.0. | |
Problem solved according to the fixlist(s) of the following version(s) |