A fix is available
APAR status
Closed as program error.
Error description
This APAR provides fixes for version 5.2 that were previously delivered for version 5.1. The following list of version 5.1 APARs are included as part of this 5.2 APAR: -PH57230 -PH57229 -PH56489 -PH56644 -PH57010 -PH56935 -PH55987 Specific error descriptions: PH57230: HPU terminates with return code 8 and message : INZU495E ERROR: INCORRECT LOBFILE TEMPLATE SYSREC01 FOR COLUMN DESCRIPTION : MANDATORY VARIABLE MISSING. THE TEMPLATE MUST CONTAIN AT LEAST ONE OF THE USER DEFINED VARIABLES BASED ON :SELNUM when the following conditions are fulfilled : -unload a table which contains LOB or XML -the SQL mode is used specifying DB2 FORCE -each LOB or XML is unloaded in a dataset -the template used for LOB/XML ensure the unicity specifying &PART and &UNIQ -SQLPART is specified to unload data by partition -the parmlib variable VUU088/ULLOCKMO is set to ALL Local fix: none PH57229: When restarting an unload job by specifying RESTART(YES... in the value of the PARM option of the EXEC statement of the Db2 HPU step, the restart mode is unduly disabled because the restart dataset is not found. The following message is issued: INZU564I RESTART MODE DISABLED: THE RESTART DATASET dataset name DOES NOT EXIST. and indicates a dataset name containing the Db2 member name while the dataset created by the previous/initial run of the unload has a name containing the Db2 datasharing group attachment name. the issue occurs when all the following conditions are fulfilled: - the unload is run against a Db2 data sharing group - the VUU030/ULOPTNS parmlib parameter value either does not contain TEMPLATE_SSID_SUBSTITUTION or contains TEMPLATE_SSID_SUBSTITUTION ( MEMBER_NAME) Local fix: if applicable, consider specifying TEMPLATE_SSID_SUBSTITUTION(GROUP_NAME) in the value of the VUU030/ULOPTNS parmlib parameter. PH56489: The run in restart mode of a Db2 HPU step does not write a complete set of unloaded data for an unload which initial run failed after the allocation of the output dataset. This occurs if the following conditions are fulfilled: -the initial run of the step completed with an error return code (i.e.; greater than 4) and did not abend -the initial run of the step allocated the output dataset for the unload in error Local fix: none. The restart mode does not work and the unload in question must be done from scratch. PH56644: An unload of LOB data into a spanned dataset (SPANNED YES option) performed in native mode abends after having issued the following console message: CEE0374C CONDITION=CEE0802C TOKEN= 00040322 61C3C5C5 00000000_00000000 487 WHILE RUNNING PROGRAM infotel_malloc WHICH STARTS AT 2FEE6458 As the root cause of this issue is a memory overlap, other unpredictable symptoms might occur. Local fix: none. PH57010: When the display utility feature is enabled (i.e., VUU095/ENBDISP is set to YES), an unload can hang at the very end of the processing when stopping the task dedicated to the display utility feature after the unloaded data has been written. Local fix: If applicable, consider disabling the display utility feature by setting the VUU095/ENBDISP parmlib pparameter to NO. PH56935: The unload of the data from an image copy requested through the FROMCOPY option of the Db2 UNLOAD syntax can end with an ABENDS0C4 in function inzctrlhBuildIcInformation. This is can occur when all the following conditions are fulfilled: - the unload command uses the DB2 UNLOAD syntax (the INZUTILC module is run) - the unload from the image copy is requested through the FROMCOPY option - the VUU030/ULOPTNS parmlib parameter's value contains SEARCH_UNCATALOGED_IC(YES) The detailed symptom cannot be predicted as it depends on the memory allocation at run time. An example of symptom is: Abend 0c4 and traceback : inzctrlhBuildIcInformation +00000596 2999 INZUTILK ochar.h 7 inzctrliCheckCopyDsn +000002EC 1505 INZUTILK inzctrli.c 8 _inzctrlhCheckCopyDdnParam +00000AD2 3303 INZUTILK inzctrlh.c 9 inzctrlhHPU +0000176A 1614 INZUTILK inzctrlh.c 10 inzcontrolControl +000001E8 298 INZUTILK inzctrl.c 11 _inzmainThreadForRun +000003CA 698 INZUTILK inzmain.c Local Fix: if applicable, consider using the Db2 HPU syntax to unload the data from the image copy. PH55987: (changed since first description: typo corrected "to the called" instead of "to the caller".) To avoid memory outage issues when Db2 HPU invokes Db2 Sort, it should exploit the capability to request Db2 Sort to reserve memory to the caller brought by APAR PH55226. Local fix: none
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 High Performance Unload for * * z/OS * **************************************************************** * PROBLEM DESCRIPTION: PH57230: * * HPU terminates with return * * code 8 and message : * * * * INZU495E ERROR: INCORRECT LOBFILE * * TEMPLATE SYSREC01 FOR * * COLUMN DESCRIPTION : * * MANDATORY VARIABLE * * MISSING. THE TEMPLATE * * MUST CONTAIN AT LEAST * * ONE OF THE USER * * DEFINED VARIABLES * * BASED ON :SELNUM * * * * when the following conditions are * * fulfilled : * * * * -unload a table which contains LOB or * * XML * * * * -the SQL mode is used specifying DB2 * * FORCE * * * * -each LOB or XML is unloaded in a * * dataset * * * * -the template used for LOB/XML ensure * * the unicity specifying &PART and &UNIQ * * * * -SQLPART is specified to unload data * * by partition * * * * -the parmlib variable VUU088/ULLOCKMO * * is set to ALL * * * * Local fix: none * * * * * * PH57229: * * When restarting an unload job by * * specifying RESTART(YES... in the value * * of the PARM option of the EXEC * * statement of the Db2 HPU step, the * * restart mode is unduly disabled * * because the restart dataset is not * * found. The following message is * * issued: INZU564I RESTART MODE * * DISABLED: THE RESTART DATASET * * dataset name DOES NOT EXIST. * * and indicates a dataset name * * containing the Db2 member name while * * the dataset created by the * * previous/initial run of the unload has * * a name containing the Db2 datasharing * * group attachment name. * * * * the issue occurs when all the * * following conditions are fulfilled: * * - the unload is run against a Db2 data * * sharing group * * - the VUU030/ULOPTNS parmlib parameter * * value either does not contain * * TEMPLATE_SSID_SUBSTITUTION or * * contains * * TEMPLATE_SSID_SUBSTITUTION * * ( MEMBER_NAME) * * * * Local fix: if applicable, consider * * specifying * * TEMPLATE_SSID_SUBSTITUTION(GROUP_NAME) * * in the value of the VUU030/ULOPTNS * * parmlib parameter. * * * * * * PH56489: * * The run in restart mode of a Db2 HPU * * step does not write a complete set of * * unloaded data for an unload which * * initial run failed after the * * allocation of the output dataset. * * This occurs if the following * * conditions are fulfilled: * * * * -the initial run of the step completed * * with an error return code (i.e.; * * greater than 4) and did not abend * * * * -the initial run of the step allocated * * the output dataset for the unload in * * error * * * * Local fix: none. The restart mode does * * not work and the unload in question * * must be done from scratch. * * * * * * PH56644: * * An unload of LOB data into a spanned * * dataset (SPANNED YES option) performed * * in native mode abends after having * * issued the following console message: * * * * CEE0374C CONDITION=CEE0802C * * TOKEN= * * 00040322 61C3C5C5 00000000_00000000 487 * * WHILE RUNNING PROGRAM infotel_malloc * * WHICH STARTS AT 2FEE6458 * * * * As the root cause of this issue is a * * memory overlap, other unpredictable * * symptoms might occur. * * * * Local fix: none. * * * * * * PH57010: * * When the display utility feature is * * enabled (i.e., VUU095/ENBDISP is set * * to YES), an unload can hang at the * * very end of the processing when * * stopping the task dedicated to the * * display utility feature after the * * unloaded data has been written. * * * * Local fix: If applicable, consider * * disabling the display utility feature * * by setting the VUU095/ENBDISP parmlib * * parameter to NO. * * * * * * PH56935: * * The unload of the data from an image * * copy requested through the FROMCOPY * * option of the Db2 UNLOAD syntax can * * end with an ABENDS0C4 in function * * inzctrlhBuildIcInformation. * * * * This is can occur when all the * * following conditions are fulfilled: * * * * - the unload command uses the DB2 * * UNLOAD syntax (the INZUTILC module is * * run) * * * * - the unload from the image copy is * * requested through the FROMCOPY option * * * * - the VUU030/ULOPTNS parmlib * * parameter's value contains * * SEARCH_UNCATALOGED_IC(YES) * * * * The detailed symptom cannot be * * predicted as it depends on the memory * * allocation at run time. An example of * * symptom is: * * Abend 0c4 and traceback : * * * * inzctrlhBuildIcInformation * * +00000596 2999 * * INZUTILK ochar.h * * 7 inzctrliCheckCopyDsn * * +000002EC 1505 * * INZUTILK inzctrli.c * * 8 _inzctrlhCheckCopyDdnParam * * +00000AD2 3303 * * INZUTILK inzctrlh.c * * 9 inzctrlhHPU * * +0000176A 1614 * * INZUTILK inzctrlh.c * * 10 inzcontrolControl * * +000001E8 298 * * INZUTILK inzctrl.c * * 11 _inzmainThreadForRun * * +000003CA 698 * * INZUTILK inzmain.c * * * * Local Fix: if applicable, consider * * using the Db2 HPU syntax to unload the * * data from the image copy. * * * * * * PH55987: * * To avoid memory outage issues when Db2 * * HPU invokes Db2 Sort, it should * * exploit the capability to request Db2 * * Sort to reserve memory to the caller * * brought by APAR PH55226. * * Local fix: none * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** PH57320: unexpected INZU495E when unload LOB/XML by SQL by partition PH57229: RESTART dataset not found in data sharing mode PH56489: run in restart mode does not correct the unloaded dataset produced by the initial run PH56644: abend or unpredictable issue when unloading unloading LOB into spanned dataset PH57010: possible hanging situation at the end of the unload step when display utility feature is enabled PH56935: ABENDS0C4 unloading image copy using FROMCOPY option from Db2 UNLOAD syntax PH55987: avoid Db2 Sort related memory outages
Problem conclusion
Code has been changed to fix this problem
Temporary fix
Comments
APAR Information
APAR number
PH58575
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
2023-12-05
Closed date
2023-12-20
Last modified date
2024-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZ$$PRM INZTDSC INZTVAR INZUTILK
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R520 PSY UI94933
UP24/01/04 P F401
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 February 2024