APAR status
Closed as fixed if next.
Error 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
Local fix
db2set APM_THROTTLE=25
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 10.1 fixpack 6 or later. * ****************************************************************
Problem conclusion
Temporary fix
Comments
APAR Information
APAR number
IT16614
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
970
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-08-16
Closed date
2017-01-31
Last modified date
2017-01-31
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R970 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
31 January 2017