|
Problem IT01328
|
Status: Closed |
INSTANCE ABEND IN DB2STMM WHEN EVALUATING SCALAR AGGREGATE OPERATORS. |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
In a rare timing scenario, it is possible for the db2stmm edu to
cause an instance abend.
The condition is that a scalar aggregate operation is in the
progress of cleaning up and it used exactly 32 sort heap pages.
At the same time, the db2stmm edu needs to be active and
evaluating sortheap usage by scalar aggregate operators.
As the db2stmm only runs every 180 seconds and the db2 agent
running the aggregate operation needs to be exactly at the
cleanup point, this is a very rare scenario.
The db2stmm call stack will look like :
stmmGetScalagTime
stmmCalculateTimeSavedByScalag
stmmGetTimeSavedFromActiveOperators
stmmReportBenefitFromSHeapThres
stmmGetSHeapThresSharedBenefitData
stmmGetBenefitData
stmmMemoryTunerMain
stmmMemoryTunerGlobalStartHandling
sqleIndCoordProcessRequest
sqeAgent::RunEDU
( stmmGetScalagTime may or may not show depending on the
operating system ) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL Users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Fix Pack 4 or the Latest. *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Fixed in Fix Pack 4 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.04.2014
22.09.2014
17.10.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.4
|
 |
