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 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 FixList