DB2 - Problem description
Problem IT08161 | Status: Closed |
ATS MAY RANDOMLY HANG WHEN MANY JOBS ARE SCHEDULED IN IT TO RUN. | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
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 Summary: | |
**************************************************************** * USERS AFFECTED: * * Anyone who encounters the issue * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Please upgrade to db2_v105fp7 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 07.04.2015 21.01.2016 21.01.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) | |
10.5.0.7 |