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

ENOMEM ERROR ON DB2ACD PROCESS COULD LEAD TO NON-FATAL ASSERTION FAILED

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
If db2acd process hit a ENOMEM issue,  NON-FATAL ASSERTION 
FAILED messages might be dumped in db2diag.log, for example: 
 
2012-03-09-01.30.03.287000+540 I1224328F464      LEVEL: Severe 
PID    : 2764                TID  : 3052        PROC : 
db2fmp64.exe 
INSTANCE: DB2INST1        NODE : 000 
APPID  : *LOCAL.DB2.120308170015 
FUNCTION: DB2 UDB, global services, sqlzAssertFailed, probe:10 
DATA #1 : String, 157 bytes 
NON-FATAL ASSERTION FAILED!!! 
ASSERTION EXPRESSION: Invalid block eye-catcher (0xDEAD055E) 
found at: 
SOURCE FILENAME: ../include/atmStats.h 
LINE NUMBER: 210 
 
There can be multiple reasons for the underlying out of memory 
condition.  One common reason is that the db2acd memory 
requirement exceeds the data ulimit of the userid which 
performed the db2start operation.  In the example above, the 
ossErrorMemoryAnalysis probe indicates the db2acd process was 
running with a data ulimit of 128MB.  It is likely that the out 
of memory condition experienced by db2acd will not occur if the 
instance is restarted by an userid with sufficient data ulimit. 
 
Depending on the operating system involved, the diaglog messages 
above might differ, and the facilities to control resource 
limits might also differ.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade DB2 UDB version 9.1 fix pack 12.                     * 
****************************************************************
Local Fix:
On operating systems which support user resource limits, restart 
the DB2 instance from a user account whose data ulimit is 
sufficient, such as unlimited.
Solution
Problem was first fixed in DB2 UDB Version 9.1 Fix Pack 12.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
25.03.2012
02.08.2012
02.08.2012
Problem solved at the following versions (IBM BugInfos)
9.1.FP12
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.12 FixList