The crash details might look similar to following in the
db2daig.log :
015-03-17-19.44.05.665736-240 I60597975A1074 LEVEL: Error
PID : 7407 TID : 4397748709648PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MYDB
APPHDL : 0-40439 APPID: <>
AUTHID : <>
EDUID : 404 EDUNAME: db2agntp (MYDB) 0
FUNCTION: DB2 UDB, sort/list services, sqlsFetchNextTempRecord,
probe:499
MESSAGE : ZRC=0x80130003=-2146238461=SQLS_INTRP "Interrupt.
User Cancel."
DIA8003C The interrupt has been received.
DATA #1 : Codepath, 8 bytes
1
DATA #2 : ZRC, PD_TYPE_ZRC, 4 bytes
0x80130003
DATA #3 : SQLS_MBUFS, PD_TYPE_SQLS_MBUFS, 1464 bytes
....
2015-03-17-19.45.13.750990-240 I60607086A503 LEVEL: Severe
PID : 7407 TID : 4397786458384PROC :
db2sysc 0
INSTANCE: db2inst1 NODE : 000 DB : MYDB
APPHDL : 0-40267 APPID: <>
AUTHID : <>
EDUID : 28 EDUNAME: db2agent (MYDB) 0
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler,
probe:10
MESSAGE : DIA0505I Execution of a component signal handling
function has begun.
2015-03-17-19.45.13.751081-240 I60607590A229 LEVEL: Severe
PID:7407 TID:4397786458384 NODE:000 Title: **** DRDA ASCB ****
Dump File:
<>/sqllib/db2dump/FODC_Trap_2015-03-17-19.45.13.635462_0000/7407
.28.000.dump.bin
The stack trace will have following functions :
0x000003FFF97F9ECE _ZN11sqkfChannel15lockChannelArgsEPKci +
0x0056
(/apps/mtdbp7/sqllib/lib64/libdb2e.so.1)
0x000003FFF97F3FCA
_ZN11sqkfChannel13ReceiveBufferEPP10sqkfBufferi + 0x009e
(/apps/mtdbp7/sqllib/lib64/libdb2e.so.1)
0x000003FFF98301EA
_Z8sqlkqrcvP7sqlkqcbP8sqeAgentPiPP10sqkfBufferS3_ + 0x0236
(/apps/mtdbp7/sqllib/lib64/libdb2e.so.1)
0x000003FFF983B092 _Z8sqlktrcvP9sqlri_taoPi + 0x007a
(/apps/mtdbp7/sqllib/lib64/libdb2e.so.1)
0x000003FFF983DDB4
_Z18sqlkt_unpack_tupleP9sqlri_taoPiS1_P5sqlcaPjS4_ + 0x0660
(/apps/mtdbp7/sqllib/lib64/libdb2e.so.1)
0x000003FFF98369E0 _Z8sqlktftcP8sqeAgentP9sqlri_taoP5sqlcaPjS5_
+ 0x0574
(/apps/mtdbp7/sqllib/lib64/libdb2e.so.1)
0x000003FFFB0EC2E4 _Z8sqlritqaP8sqlrr_cb + 0x01c8
(/apps/mtdbp7/sqllib/lib64/libdb2e.so.1)
0x000003FFFB13423E _Z9sqlrihsjnP8sqlrr_cb + 0x0842
(/apps/mtdbp7/sqllib/lib64/libdb2e.so.1)
...
If a query is interrupted while running a plan similar to
following it can cause similar crash,
hsjn
/
union
+--------+--------+
blah
|
TQ
This is a regression from the APAR IT03187
INTRA_PARALLEL have to be ON to hit this issue. |
