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 |