DB2 - Problem description
Problem IT09342 | Status: Closed |
CRASH IN SQEWLPRIORITYSCHEDQUEUE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
The problem is caused by the earlier FCMCTL heap error. The error will lead to a null pointer situation due to incorrect cleanup steps. So the next time when database is activated it will hit the trap due to the null pointer. The db2diag.log messages related FCMCTL will look similar to following : 2015-05-30-17.38.55.069514-300 I64544261E650 LEVEL: Error PID : 10919 TID : 46926686840576 PROC : db2sysc 0 INSTANCE: db2inst1 NODE : 000 DB : MYDB APPHDL : 0-28396 APPID: <app-id> AUTHID : user1 HOSTNAME: host1 EDUID : 130283 EDUNAME: db2agent (MYDB) 0 FUNCTION: DB2 UDB, base sys utilities, sqeServiceClassManager::PopulateServiceClassesFrom, probe:20 RETCODE : ZRC=0x8B0F0049=-1961951159=SQLO_NOMEM_FCM_CTL_HEAP "No memory available in 'FCMCTL Heap'" DIA8300C A memory heap error has occurred. 2015-05-30-17.38.55.069955-300 I64544912E607 LEVEL: Error PID : 10919 TID : 46926686840576 PROC : db2sysc 0 INSTANCE: db1inst1 NODE : 000 DB : MYDB APPHDL : 0-28396 APPID: <app-id> AUTHID : user1 HOSTNAME: host1 EDUID : 130283 EDUNAME: db2agent (CWMP01) 0 FUNCTION: DB2 UDB, WLM, sqlrwPopulateCatWLMCbs, probe:40 RETCODE : ZRC=0x8B0F0049=-1961951159=SQLO_NOMEM_FCM_CTL_HEAP "No memory available in 'FCMCTL Heap'" DIA8300C A memory heap error has occurred. Then the FODC trap happens with following stack : 0x00002AAAAE8E379C _ZN23sqeWLPrioritySchedQueue21RegisterPriorityClassEtmllmlPvP18S QLE_SERVICE_CLASS + 0x02fc (/db2/idwhp01/home/sqllib/lib64/libdb2e.so.1) 0x00002AAAAE8DD38A _ZN15sqeWLDispatcher25RegisterExecPriorityClassEtmllmlP18SQLE_SE RVICE_CLASS + 0x032a (/db2/idwhp01/home/sqllib/lib64/libdb2e.so.1) 0x00002AAAAE92F7E6 _ZN22sqeServiceClassManager33PopulateServiceClassesFromCatalogEP 8sqlrr_cb + 0x0d36 (/db2/idwhp01/home/sqllib/lib64/libdb2e.so.1) 0x00002AAAAF8B8D25 _Z22sqlrwPopulateCatWLMCbsP8sqlrr_cbb + 0x0095 (/db2/idwhp01/home/sqllib/lib64/libdb2e.so.1) 0x00002AAAAF8221C4 _Z15sqlrr_appl_initP8sqeAgentP5sqlca + 0x36a4 (/db2/idwhp01/home/sqllib/lib64/libdb2e.so.1) 0x00002AAAAE8B8BD9 _ZN14sqeApplication20InitEngineComponentsEcP8sqeAgentP8SQLE_BWAP 5sqlcaP22SQLESRSU_STATUS_VECTORc + 0x06b9 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Users can upgrade to DB2 Version 10.5 fix pack 7 or higher * * to avoid this defect * **************************************************************** | |
Local Fix: | |
Solution | |
First fixed in DB2 Version 10.5 fix pack 7 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 08.06.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 |