Latest versionsfixlist
11.1.0.6 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
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC69085 Status: Closed

REPORT SHMGET FAILURE IN DB2DIAG.LOG

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problem description:
Under a specific case, when SQL statements were failing due to 
SQLCODE -101, db2diag.log only reported "Out of memory failure 
for Statement Heap. The reason for the failure was due to 
Operating system call shmget failing with errno 28 (ENOSPC). 
 
shmget failure was not reported in the db2diag.log but captured 
by the db2trc. 
 
The Intent of this APAR is to report shmget failure in the 
db2diag.log as well to help improve serviceability.
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All users                                                    * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Under a specific case, when SQL statements were failing      * 
* dueto  SQLCODE -101, db2diag.log only reported "Out of       * 
* memoryfailure for Statement Heap. The reason for the failure * 
* wasdue to Operating system call shmget failing with errno    * 
* 28(ENOSPC).shmget failure was not reported in the            * 
* db2diag.log butcaptured by the db2trc.The Intent of this     * 
* APAR is to report shmget failure in thedb2diag.log as well   * 
* to help improve serviceability.                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Version 9.5 Fixpack 7 or later                    * 
****************************************************************
Local Fix:
Use db2trc to understand the reason for failure
available fix packs:
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem is First Fixed in Version 9.5 Fixpack 7
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC71068 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
08.06.2010
17.12.2010
17.12.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP7
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.7 FixList
9.5.0.7 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.