Fixes are available
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
When an incorrectly huge memory pool is asked, DB2 attempts to create it rather than returning an error. This can lead to an exhaustion in the memory resource in the box. This problem occurs only in a rare event, where the DB2 component needing a memory pool incorrectly calculates the amount they need. So far, the only known such scenario is when runstats was run with quantiles and freqvalues values more than twenty thousand. n/a n/a
Local fix
Refrain from running runstats with very high freqvalues and quantiles.
Problem summary
**************************************************************** * USERS AFFECTED: * * ALL. However, so far, the symptom is only seen by those * * running RUNSTATS command with very large (e.g. over 20,000) * * quantiles and/or freqvalues. * **************************************************************** * PROBLEM DESCRIPTION: * * Same as ERROR DESCRIPTION * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 9.5 Fix pack 5 or later. * ****************************************************************
Problem conclusion
First fixed in DB2 9.5 Fix pack 5.
Temporary fix
Comments
APAR Information
APAR number
IC63179
Reported component name
DB2 FOR LUW
Reported component ID
DB2FORLUW
Reported release
970
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-09-14
Closed date
2010-02-21
Last modified date
2010-02-21
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
DB2 FOR LUW
Fixed component ID
DB2FORLUW
Applicable component levels
R950 PSY
UP
Document Information
Modified date:
15 September 2021