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 |
|