A fix is available
APAR status
Closed as program error.
Error description
When Db2 HPU invokes a sort program that is allowed to use as much 64 bit memory as it wants, it can fail in ABEND if it needs to allocated 64 bit memory after the sort program has exhausted the memory till the applicable MEMLIMIT value. If the sort program offers a way to limit the 64 bit allocation memory, it is recommended to use this feature to solve the issue. If PH55987 is applied and the sort program involved is Db2sort, using the related feature (implemented through the RESERVE_64_MEMORY suboption and the VUU103/DB2SMRES parmlib parameter) to solve the memory outage issues is recommended. If none of these solution are applicable for any of the following reason: * the sort program does not offer a feature to limit its 64 bit memory allocation * the sort program has a feature to limit the 64 bit memory allocation but it cannot be used to avoid any undesirable impact on the other programs using the sort program in question * the sort program in question is not Db2sort * the sort program is Db2sort but PH55987 is not applied or its prerequisite Db2sort PH55226 APAR is not applied * any other reason that prevent the ideal solution to be implemented in some cases, this issue can be avoided by specifying the following LE options : HEAP64(20M,5M,KEEP,32768,32768,FREE,4096,4096,FREE) This can be done at the Db2 HPU step level by adding a CEEOPTNS DD statement pointing to a dataset with the LE option in question, as in the example below: //CEEOPTS DD * HEAP64(20M,5M,KEEP,32768,32768,FREE,4096,4096,FREE) As these LE options are advisable for Db2 HPU invoking a sort program, they should be set by Db2 HPU itself, from Db2 HPU 5.2 (the workaround is also applicable to Db2 HPU 5.1).
Local fix
add a CEEOPTNS DD statement pointing to a dataset with the LE option in question, as in the example below: //CEEOPTS DD * HEAP64(20M,5M,KEEP,32768,32768,FREE,4096,4096,FREE)
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 High Performance Unload for * * z/OS * **************************************************************** * PROBLEM DESCRIPTION: (HPU 5.2 only) * * When Db2 HPU invokes a sort program * * that is allowed to use as much 64 bit * * memory as it wants, it can fail in * * ABEND if it needs to allocated 64 bit * * memory after the sort program has * * exhausted the memory till the * * applicable MEMLIMIT value. * * * * If the sort program offers a way to * * limit the 64 bit allocation memory, it * * is recommended to use this feature to * * solve the issue. * * If PH55987 is applied and the sort * * program involved is Db2sort, using the * * related feature (implemented through * * the RESERVE_64_MEMORY suboption and the * * VUU103/DB2SMRES parmlib parameter) to * * solve the memory outage issues is * * recommended. * * * * If none of these solutions is * * applicable for any of the following * * reason: * * - the sort program does not offer a * * feature to limit its 64 bit memory * * allocation * * - the sort program has a feature to * * limit the 64 bit memory allocation * * but it cannot be used to avoid any * * undesirable impact on the other * * programs using the sort program in * * question * * - the sort program in question is not * * Db2sort * * - the sort program is Db2sort but * * PH55987 is not applied or its * * prerequisite Db2sort PH55226 APAR is * * not applied * * - any other reason that prevent the * * ideal solution to be implemented * * in some cases, this issue can be * * avoided by specifying the following LE * * options : HEAP64(20M,5M,KEEP,32768, * * 32768,FREE,4096,4096,FREE) * * * * This can be done at the Db2 HPU step * * level by adding a CEEOPTNS DD * * statement pointing to a dataset with * * the LE option in question, as in the * * example below: * * //CEEOPTS DD * * * HEAP64(20M,5M,KEEP,32768,32768, * * FREE,4096,4096,FREE) * * * * As these LE options are advisable for * * Db2 HPU invoking a sort program, they * * should be set by Db2 HPU itself, from * * Db2 HPU 5.2 (the workaround is * * applicable to Db2 HPU 5.1). * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** avoid sort programs related memory outages
Problem conclusion
Code has been changed to fix this problem
Temporary fix
Comments
APAR Information
APAR number
PH61481
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
520
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-05-23
Closed date
2024-07-01
Last modified date
2024-08-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZ$$CCQ INZ$$PRM INZMQRY INZPARM INZTDSC INZTOOLS INZTVAR INZUTIB1 INZUTIB2 INZUTILC INZUTILD INZUTILK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R520 PSY UI97541
UP24/07/03 P F407
Fix is available
Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"520","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
01 August 2024