DB2 - Problembeschreibung
Problem IT08600 | Status: Geschlossen |
DB2 BLU QUERY MIGHT CRASH INSTANCE DUE TO INSUFFICIENT AGENT_STACK_SZ | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problembeschreibung: | |
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 ... | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * See SYSROUTE APARs to see where this APAR is addressed * **************************************************************** | |
Local-Fix: | |
Increase AGENT_STACK_SZ size | |
Lösung | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 28.04.2015 09.05.2017 09.05.2017 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.5.0.7 |