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 |
