DB2 - Problem description
Problem IT20174 | Status: Closed |
DB2 MAY ABEND WHEN A PLAN CONTAINING AGGREGATION IS INTERRUPTED AND SUBSEQUENTLY REEXECUTED | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
DB2 may abend or trap when a plan containing aggregation is interrupted or otherwise terminated abnormally and then executed again such that the section is reused. To hit the trap there must be rows flowing through the aggregation operator when the interrupt is received and then when the section is reused there must be no rows flowing through the aggregation operator. You may see a stack similar to : sqlriPeaEOF sqlripea sqlriSectInvoke sqlrr_dss_router A match to this APAR will have sqlriPeaEOF at the top of the stack | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 11.1 Mod 2 Fix Pack 2 or higher * **************************************************************** | |
Local Fix: | |
setting DB2_REDUCED_OPTIMIZATION=NO_PEA will work around the issue. Static sections must be rebound for it to take effect | |
available fix packs: | |
DB2 Version 11.1 Mod 2 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 11.1 Mod 2 Fix Pack 2 | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 12.04.2017 27.06.2017 27.06.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |