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 IT02098 Status: Closed

DB2 CRASH DUE TO AN APPLICATION GETTING SQL09015 ONLY FOR SMP

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
DB2 crash occurred and the db2diag.log will show something like: 
 
2014-04-06-23.01.37.448092-240 I2462255488E623       LEVEL: 
Error 
PID     : 15827                TID : 46932089104704  PROC : 
db2sysc 10 
INSTANCE: db2inst1           NODE : 010            DB   : Sample 
APPHDL  : 1-53961              APPID: 
1.111.222.333.45687.1404070301 
AUTHID  : USER             HOSTNAME: test123 
EDUID   : 202689               EDUNAME: db2agntp (Sample) 10 
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, 
probe:9 
MESSAGE : Error in agent servicing application with PRODUCT 
SIGNATURE: 
DATA #1 : Hexdump, 8 bytes 
0x00000002088B851C : 5351 4C30 3930 3135 
SQL09015 
 
2014-04-06-23.01.37.448300-240 I2462256112E622       LEVEL: 
Error 
PID     : 15827                TID : 46932089104704  PROC : 
db2sysc 10 
INSTANCE: db2inst1           NODE : 010            DB   : Sample 
APPHDL  : 1-53961              APPID: 
1.111.222.333.45687.1404070301 
AUTHID  : USER             HOSTNAME: test123 
EDUID   : 202689               EDUNAME: db2agntp (Sample) 10 
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, 
probe:10 
MESSAGE : Error in agent servicing application with APPLICATION 
NAME: 
DATA #1 : Hexdump, 7 bytes 
0x00000002088B83F2 : 7065 726C 352E 38 
perl5.8 
 
Stack shows: 
 
Stack #1             Signal #11        Timestamp 
 
0        ossDumpStackTraceInternal 
1        ossDumpStackTraceV98 
2        OSSTrapFile::dumpEx 
3        sqlo_trce 
4        sqloEDUCodeTrapHandler 
5        __pthread_mutex_cond_lock 
6        sqlnxPlanActuals::getTableMetrics 
7        sqlnxPlanActuals::mergeData 
8        sqlricls_complex 
9        sqlra_close_section 
10       sqlrr_dss_router 
11       sqlrr_subagent_router 
12       sqleSubRequestRouter 
13       sqleProcessSubRequest 
14       sqeAgent::RunEDU 
15       sqzEDUObj::EDUDriver 
16       sqlzRunEDU 
17       sqloEDUEntry 
18       pthread_create@@GLIBC_2.2.5 
19       clone
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* See Error Description                                        * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* See Error Description                                        * 
****************************************************************
Local Fix:
N/A
Solution
See Error Description
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
28.05.2014
15.07.2015
09.11.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