Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT06315 Status: Closed

ATS MAY RANDOMLY HANG WHEN MANY JOBS ARE SCHEDULED IN IT TO RUN.

product:
DB2 FOR LUW / DB2FORLUW / A10 - 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:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* upgrade to db2 10.5 fp5                                      * 
****************************************************************
Local Fix:
Solution
Fixed in db2 10.1 fp5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.01.2015
13.07.2015
13.07.2015
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.1.0.5 FixList