DB2 - Problembeschreibung
Problem IT06315 | Status: Geschlossen |
ATS MAY RANDOMLY HANG WHEN MANY JOBS ARE SCHEDULED IN IT TO RUN. | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problembeschreibung: | |
When Ats calls many job parallelly ,it may hang randomly at any job. Below errors are seen in diaglog: 2014-11-07-16.41.00.170010+480 I448654E629 LEVEL: Error PID : 5834 TID : 140048636831488 PROC : db2sysc 0 INSTANCE: db2inst NODE : 000 DB : Sample APPHDL : 0-2315 APPID: Local.db2 AUTHID : Sample HOSTNAME: test EDUID : 343 EDUNAME: db2agent (Sample) 0 FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:9 MESSAGE : Error in agent servicing application with PRODUCT SIGNATURE: DATA #1 : Hexdump, 8 bytes 0x000000020A69852C : 5351 4C31 3030 3134 SQL10014 2014-11-07-16.41.00.170067+480 I449284E627 LEVEL: Error PID : 5834 TID : 140048636831488 PROC : db2sysc 0 INSTANCE: db2inst NODE : 000 DB : Sample APPHDL : 0-2315 APPID: Local.db2 AUTHID : Sample HOSTNAME: test EDUID : 343 EDUNAME: db2agent (Sample) 0 FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:10 MESSAGE : Error in agent servicing application with APPLICATION NAME: DATA #1 : Hexdump, 6 bytes 0x000000020A698402 : 4442 3241 5453 DB2ATS 2014-11-07-16.41.00.308501+480 I449912E616 LEVEL: Severe PID : 5834 TID : 140048636831488 PROC : db2sysc 0 INSTANCE: db2inst NODE : 000 DB : Sample APPHDL : 0-2315 APPID: Local.db2 AUTHID : Sample HOSTNAME: test EDUID : 343 EDUNAME: db2agent (Sample) 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 Below are stacks found in trap file: _Z25ossDumpStackTraceInternalmR11OSSTrapFileiP7siginfoPvmm (/home/db2inst/sqllib/lib64/libdb2osse.so.1) ossDumpStackTraceV98 (/home/db2inst/sqllib/lib64/libdb2osse.so.1) _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm (/home/db2inst/sqllib/lib64/libdb2osse.so.1) sqlo_trce (/home/db2inst/sqllib/lib64/libdb2e.so.1) sqloEDUCodeTrapHandler (/home/db2inst/sqllib/lib64/libdb2e.so.1) 0x0000003E66C00000 ; offset in lib: 0x000000000000F710 ; (/lib64/libpthread.so.0) _Z32sqlraSessionERTGetCursorInfoByIDP8sqlrr_cbiPP18sqlraPSMCurso rInfo (/home/db2inst/sqllib/lib64/libdb2e.so.1) _Z15sqlricls_simpleP8sqlrr_cbil (/home/db2inst/sqllib/lib64/libdb2e.so.1) _Z19sqlra_close_sectionP8sqlrr_cbP25sqlra_sql_context_siblingiii iiii + 0x00e8 (/home/db2inst/sqllib/lib64/libdb2e.so.1) _Z41sqlra_close_sections_on_finalcmt_rollbackP8sqlrr_cb (/home/db2inst/sqllib/lib64/libdb2e.so.1) _Z20sqlra_close_sectionsP8sqlrr_cbjjb (/home/db2inst/sqllib/lib64/libdb2e.so.1) _Z15sqlrr_appl_termP8sqeAgentiP5sqlca (/home/db2inst/sqllib/lib64/libdb2e.so.1) _ZN14sqeApplication28TrustedSwitchUserTermUserEnvEP14db2UCinterf aceP8sqeAgent + 0x0217 (/home/db2inst/sqllib/lib64/libdb2e.so.1) _Z26sqleUCengTrustedSwitchUserP14db2UCinterface (/home/db2inst/sqllib/lib64/libdb2e.so.1) _Z22sqljsTrustedSwitchUserP14db2UCinterface (/home/db2inst/sqllib/lib64/libdb2e.so.1) _Z16sqljs_ddm_secchkP14db2UCinterfaceP13sqljDDMObject (/home/db2inst/sqllib/lib64/libdb2e.so.1) _Z21sqljsParseRdbAccessedP13sqljsDrdaAsCbP13sqljDDMObjectP14db2U Cinterface (/home/db2inst/sqllib/lib64/libdb2e.so.1) | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * All * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * upgrade to db2 10.5 fp5 * **************************************************************** | |
Local-Fix: | |
Lösung | |
Fixed in db2 10.1 fp5 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 05.01.2015 13.07.2015 13.07.2015 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
10.1.0.5 |