Under rare scenarios, DB2 might abend for a query which
satisfies the following conditions:
1. The query has more than 30 inner joins
2. There are one or more optimizer mqts defined on the tables.
<Stack Trace>
-----FUNC-ADDR---- ------FUNCTION + OFFSET------
sqlnq_mch::find_qun_mappings
sqlnr_subsume_derived_match
sqlnr_subsume_match
sqlnr_matchmaker
sqlnr_compute_matchinfo
sqlnr_optprep
sqlnr_optprep_action
sqlnr_comp
sqlnr_seq
sqlnr_rcc
sqlnr_exe
sqlnn_cmpl
</StackTrace>
The following messages will be written to the db2diag.log
2011-08-22-10.53.35.331275-240 I183347E496 LEVEL: Event
PID : 17926 TID : 183135889760 PROC :
db2sysc 0
INSTANCE: nypit076 NODE : 000 DB : EMPDB
APPHDL : 0-13 APPID: *LOCAL.DB2.110821094136
AUTHID : MSDB2
EDUID : 66 EDUNAME: db2stmm (EMPDB) 0
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam,
probe:20
CHANGE : STMM CFG DB EMPDB: "Pckcachesz" From: "12161"
<automatic> To: "12321" <automatic>
2011-08-22-10.54.37.596076-240 I183844E618 LEVEL: Error
PID : 17926 TID : 207597070688 PROC :
db2sysc 0
INSTANCE: nypit076 NODE : 000 DB : EMPDB
APPHDL : 0-6242 APPID:
10.184.103.47.6084.110822141846
AUTHID : PHST1933
EDUID : 233 EDUNAME: db2agent (EMPDB) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_intd_call,
probe:200
MESSAGE : Out sqlz_value
DATA #1 : Hexdump, 24 bytes
0x0000002F56FF8DA8 : 1301 4000 0108 0000 A006 0000 0000 0000
..@.............
0x0000002F56FF8DB8 : 4000 0000 0000 0000
@.......
2011-08-22-10.54.37.596289-240 I184463E618 LEVEL: Error
PID : 17926 TID : 207597070688 PROC :
db2sysc 0
INSTANCE: nypit076 NODE : 000 DB : EMPDB
APPHDL : 0-6242 APPID:
10.184.103.47.6084.110822141846
AUTHID : PHST1933
EDUID : 233 EDUNAME: db2agent (EMPDB) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_intd_call,
probe:200
MESSAGE : Out sqlz_value
DATA #1 : Hexdump, 24 bytes
0x0000002F56FF8CA8 : 1301 4000 0108 0000 A005 0000 0000 0000
..@.............
0x0000002F56FF8CB8 : 4000 0000 0000 0000
@.......
2011-08-22-10.54.37.596374-240 I185082E618 LEVEL: Error
PID : 17926 TID : 207597070688 PROC :
db2sysc 0
INSTANCE: nypit076 NODE : 000 DB : EMPDB
APPHDL : 0-6242 APPID:
10.184.103.47.6084.110822141846
AUTHID : PHST1933
EDUID : 233 EDUNAME: db2agent (EMPDB) 0
FUNCTION: DB2 UDB, access plan manager, sqlra_intd_call,
probe:200
MESSAGE : Out sqlz_value
DATA #1 : Hexdump, 24 bytes
0x0000002F56FF8BA8 : 1301 4000 0108 B804 A004 0000 0000 0000
..@.............
0x0000002F56FF8BB8 : 4000 0000 0000 0000
@.......
2011-08-22-11.38.42.370399-240 I185701E567 LEVEL: Error
PID : 17926 TID : 208133941600 PROC :
db2sysc 0
INSTANCE: nypit076 NODE : 000 DB : EMPDB
APPHDL : 0-6426 APPID:
172.23.255.60.56837.11082215383
AUTHID : RFZHOU
EDUID : 140 EDUNAME: db2agent (EMPDB) 0
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh,
probe:1
MESSAGE : Error in agent servicing application with coor_node:
DATA #1 : Hexdump, 2 bytes
0x000000307580F592 : 0000 |
