DB2 - Problem description
Problem IT16249 | Status: Closed |
IF SORTHEAP IS SET TO A SMALL NUMBER, WE SEE THE FOLLOWING DB2DIAG.LOG ENTRY | |
product: | |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 | |
Problem description: | |
If sortheap is set to something small like 50 pages, there is a case where we see this in db2diag.log FUNCTION: DB2 UDB, sort/list services, sqlsReserveSharedSortSpace, probe:60 DATA #1 : String, 34 bytes Invalid shared sort memory request DATA #2 : unsigned integer, 4 bytes 65 | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Any platform * **************************************************************** * PROBLEM DESCRIPTION: * * If sortheap is set to something small like 50 pages, there * * is a case where we see this in db2diag.log * * * * * * FUNCTION: DB2 UDB, sort/list services, * * sqlsReserveSharedSortSpace, probe:60 * * DATA #1 : String, 34 bytes * * Invalid shared sort memory request * * DATA #2 : unsigned integer, 4 bytes * * 65 * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.1 Fix Pack 5 * **************************************************************** | |
Local Fix: | |
Increase the SORTHEAP value using: db2 update db cfg using sortheap 100 immediate | |
Solution | |
Workaround | |
Increase the SORTHEAP value using: db2 update db cfg using sortheap 100 immediate | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.07.2016 22.12.2016 22.12.2016 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |