DB2 FOR LUW / DB2FORLUW / A50 - DB2

DB2 BLU query might crash  instance due to insufficient 
agent_stack_sz 
 
 
Message in db2diag.log might look similar to the following: 
2015-03-19-10.10.11.538886-240 E647543A667          LEVEL: 
Severe 
PID     : 49021156             TID : 31020          PROC : 
db2sysc 0 
INSTANCE: db2ins               NODE : 000           DB   : LP1 
APPHDL  : 0-42337              APPID: xxx.xxx.xxx.xx 
AUTHID  : DB2INS               HOSTNAME: hostname 
EDUID   : 31020                EDUNAME: db2agent (LP1) 0 
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, 
probe:10 
MESSAGE : ADM0502C  The DB2 instance has terminated abnormally. 
To remedy this 
          problem, increase the AGENT_STACK_SZ DBM configuration 
parameter. 
          Contact IBM Support for further assistance. 
 
.. 
 
2015-03-19-10.10.13.331471-240 I672487A603          LEVEL: 
Severe 
PID     : 49021156             TID : 30402          PROC : 
db2sysc 0 
INSTANCE: db2ins               NODE : 000           DB   : LP1 
APPHDL  : 0-42403              APPID: xxx.xxx.xxx.xx 
AUTHID  : DB2INS               HOSTNAME: hostname 
EDUID   : 30402                EDUNAME: db2agent (LP1) 0 
FUNCTION: DB2 UDB, RAS/PD component, 
pdResilienceIsSafeToSustain, probe:800 
DATA #1 : String, 37 bytes 
Trap Sustainability Criteria Checking 
DATA #2 : Hex integer, 8 bytes 
0x0000000400001000 
DATA #3 : Boolean, 1 bytes 
true 
 
Example stacks: 
 
ibm_cde::query::Parser::deepCopyAsChild 
ibm_cde::query::Parser::deepCopyAsChild 
ibm_cde::query::Parser::deepCopyAsChild 
ibm_cde::query::Parser::deepCopyAsChild 
ibm_cde::query::Parser::deepCopyAsChild 
ibm_cde::query::Parser::deepCopyAsChild 
ibm_cde::query::Parser::deepCopyAsChild 
.. 
 
OR 
 
0x0900000026949798 
makeDerivedPred__Q3_7ibm_cde5query6ParserFPCQ3_7ibm_cde5query10S 
yntaxTreePCQ3_7ibm_cde4data13TableAccessorT2b + 0x8C 
0x0900000026949FEC 
makeDerivedPred__Q3_7ibm_cde5query6ParserFPCQ3_7ibm_cde5query10S 
yntaxTreePCQ3_7ibm_cde4data13TableAccessorT2b + 0x8E0 
0x0900000026949FEC 
makeDerivedPred__Q3_7ibm_cde5query6ParserFPCQ3_7ibm_cde5query10S 
yntaxTreePCQ3_7ibm_cde4data13TableAccessorT2b + 0x8E0 
0x0900000026949FEC 
makeDerivedPred__Q3_7ibm_cde5query6ParserFPCQ3_7ibm_cde5query10S 
yntaxTreePCQ3_7ibm_cde4data13TableAccessorT2b + 0x8E0 
0x0900000026949FEC 
makeDerivedPred__Q3_7ibm_cde5query6ParserFPCQ3_7ibm_cde5query10S 
yntaxTreePCQ3_7ibm_cde4data13TableAccessorT2b + 0x8E0 
0x0900000026949FEC 
makeDerivedPred__Q3_7ibm_cde5query6ParserFPCQ3_7ibm_cde5query10S 
yntaxTreePCQ3_7ibm_cde4data13TableAccessorT2b + 0x8E0 
0x0900000026949FEC 
makeDerivedPred__Q3_7ibm_cde5query6ParserFPCQ3_7ibm_cde5query10S 
yntaxTreePCQ3_7ibm_cde4data13TableAccessorT2b + 0x8E0 
0x0900000026949FEC 
makeDerivedPred__Q3_7ibm_cde5query6ParserFPCQ3_7ibm_cde5query10S 
yntaxTreePCQ3_7ibm_cde4data13TableAccessorT2b + 0x8E0 
...

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* See SYSROUTE APARs to see where this APAR is addressed       * 
****************************************************************

Increase AGENT_STACK_SZ size

not known / see Local fix

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

28.04.2015
09.05.2017
09.05.2017