DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to DB2 version 10.1 fixpack 6 or later.              *
****************************************************************

db2set APM_THROTTLE=25

not known / see Local fix

forerunner  : 
follow-up : IT18654 IT18655 IT18656 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

16.08.2016
31.01.2017
31.01.2017