home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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