A fix is available
APAR status
Closed as program error.
Error description
APAR for roll up PTF of code fixes after code freeze The PTF for this APAR will resolve a number of issues as follows. - The first section lists all the issues with short description. - The next section lists the issues including details. 1. HPU FAST UNLOAD OUTPUT LRECL BIGGER THAN ACTUAL RECORD LENGTH PB12771 2. ABENDS0C1 or ABENDU4083 when indexscan used for two unloads PB12719 3. Support to retrieve HPU v4.2 settings via Tools Customizer DISCOVER feature PB12680 4. Stop processing and issue CC 8 when LISTDEF specifies nonexistant partition PB12750 5. Corrent description or help text of parameters PB12751 6. Correct 4.2 references in SINZDENU(INZLAUNC) PB12758 7. Specify ACTION(REPLACE) RETAIN in HPU BIND job PB12757 8. Correct unprintable for (VUU045/ULFORMAT) online help. PB12775 DETAILS for all the above issues follows. 1. HPU FAST UNLOAD OUTPUT LRECL BIGGER THAN ACTUAL RECORD LENGTH PB12771 An unload with the FAST UNLOAD syntax requesting an output in FORMAT VARIABLE generates an output data set with an irrelevant LRECL. This occurs if the target table has at least one nullable column. DB2 HPU counts each null indicator twice thus leading to an overestimated record length for the output data set. Local fix: none. 2. ABENDS0C1 or ABENDU4083 when indexscan used for two unloads PB12719 An ABEND (ABENDS0C1 or ABENDU4083) can occur when the indexscan feature is used for two unloads involving distinct table spaces are processed in parallel. This occurs if the index spaces used by the indexscan processing have the same name. Local fix: Specify INDEXCSAN NO or disable table space paraellism by specifying PARALLELISM( x, 1, x) where x is the current value that applies (blank if not specified). 3. Support to retrieve HPU v4.2 settings via Tools Customizer DISCOVER feature PB12680 The following Tools Customizer issues were corrected. a. the field-level help (the <help> element) for the parameter must be different than the parameter description (the <description> element). Shortname INZZM005 is an example. The Display parameters help is mostly the parameter name b. The field level help for the parameter should include the default value or the statement "There is no default value.". Many parameters did not have a default value. The following say there is a default in the field level help, however there is no default value: DATE, format DSNTIAUL (VUU015/ULDATE) DATE, format DELIMITED (VUU015/ULDATE) DATE, format VARIABLE (VUU015/ULDATE) DATE, format EXTERNAL (VUU015/ULDATE) TIME, format DSNTIAUL (VUU016/ULTIME) TIME, format DELIMITED (VUU016/ULTIME) TIME, format VARIABLE (VUU016/ULTIME) TIME, format EXTERNAL (VUU016/ULTIME) c. The parameter must have a valid default value. In case the value is optional and does not have valid default value, having no default value is one of the options, but the parameter should be moved to it's own optional step and/or task. d. The parameter must not have a blank default value when the parameter has a <nonblank> verification. Parameters that are marked as required have no default value, but have the * next to them e. The field-level help must include in the following order: 1. A short phrase that describes the parameter. 2. Details in complete sentences. 3. Where applicable, a valid range of values, such as, ?Valid values are 1 ? 255.? 4. Where appropriate, the default value. f. The field-level help must include in the following order: 1. A short phrase that describes the parameter. 2. Details in complete sentences. 3. Where applicable, a valid range of values, such as, ?Valid values are 1 ? 255.? 4. Where appropriate, the default value. g. The field-level help must include in the following order: 1. A short phrase that describes the task and step. 2. Details in complete sentences. h. The template description must resemble the step description in future tense. For example, Creates files needed for TSO and batch execution. i. For bind templates, ACTION(REPLACE) must be specified for each plan or package. RETAIN is valid only for plan. j. For bind templates, the qualifier must be specified for each plan or package. Local fix: none. 4. Stop processing and issue CC 8 when LISTDEF specifies nonexistant partition PB12750 DB2 HPU ends with completion code 0 despite the fact that a LISTDEF specifying a non existing partition number in the PARTLEVEL option is specified. In such as case, the utility should stop with completion code 8 after having issued the following messages : INZI321E LISTDEF ERROR: INVALID PARTLEVEL FOR dbame.tsname VALID RANGE IS (n : m) INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x107a002) Local fix: none. 5. Correct description or help text of parameters PB12751 The description or help text of some parameters are incorrect. For example the following. - (VUM031/QUITUSR) should read (VUM031/QUITSUSR) - The default value mentionned in the help text for VUM025/SRTVSMIN is wrong. Instead of "The default value is 2147483647" it should read 'The default value is the value of VUX022/VBUFSIZE parameter." - The short names of the parameter "Number of rows retrieved by an SQL FETCH function" is missing. (VUU035/ULROWSET) should be added. - The description "DB2 HPU response when a LOADDDN cannot be generated (VUU038/UNLLDER)" mentions a wrong short name. VUU038 should actually read /VUU039 Local fix: none 6. Correct 4.2 references in SINZDENU(INZLAUNC) PB12758 SINZDENU(INZLAUNC) text references 4.2, should be 4.3 that is xrel = '420' should be '430' Local fix: Change the generated job for INZLAUNC before running the CLIST 7. Specify ACTION(REPLACE) RETAIN in HPU BIND job PB12757 The DB2 HPU BIND job (generated from the SINZDENU(INZBIND) template) should specify ACTION(REPLACE) RETAIN. local fix: Add the ACTION(REPLACE) RETAIN to the job generated for the INZBIND template before submitting it. 8. Correct unprintable for (VUU045/ULFORMAT) online help. PB12775 In Tools Customizer, the online help for (VUU045/ULFORMAT) has a corrupted character if the CCSID used for the terminal is not 37. In such a case, the help text looks like the following : Output format to use for logical unloads when the FORMAT parameter is not specified in the UNLOAD command. Valid values are ﾂDSNTIAUL!DELIMITED!VARIABLE!EXTERNAL!USERﾊ<,ﾂSTRICT!ALL!ENDﾊ> (optional parts are surrounded by <>). Example: VARIABLE,ALL. The default value is DSNTIAUL. instead of Output format to use for logical unloads when the FORMAT parameter is not specified in the UNLOAD command. Valid values are {DSNTIAUL|DELIMITED|VARIABLE|EXTERNAL|USER}<,{STRICT|ALL|END}> (optional parts are surrounded by <>). Example: VARIABLE,ALL. The default value is DSNTIAUL. The characters { and } are replaced by ﾂ and ﾊ. Characters non CCSID dependent should be used instead. Local fix: none.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 High Performance Unload. * **************************************************************** * PROBLEM DESCRIPTION: An unload with the FAST UNLOAD syntax * * requesting an output in FORMAT * * VARIABLE generates an output data set * * with an irrelevant LRECL. This occus * * if the target table has at least one * * nullable column. DB2 HPU counts each * * null indicator twice thus leading to * * an overestimated record length for the * * output data set. * * pb 12771 * * An ABEND (ABENDS0C1 or ABENDU4083) can * * occur when the indexscan feature is * * used for two unloads involving * * distinct table spaces are processed in * * parallel. This occur if the index * * spaces used by the indexscan * * processing have the same name. * * pb 12719 * * It is not possible to retreive the * * settings from an HPU 4.2 installation * * via the discover feature. * * pb 12680 * * DB2 HPU Tools Customizer use is not * * compliant to Tools Customizer rules. * * pb 12717 * * An ABENDS0C4 or and ABENDU4093 (in HPU * * 4.3 if PARM='TRAP(OFF)/...' is * * specified) can occur if the following * * applies: * * - unload table from a multi table * * tablespace in native mode * * - the unloaded table has fixed length * * row * * - an ORDER clause is specified * * - one of the tables belonging to the * * multi table table space not to be * * unloaded has a record length greater * * than the unloaded table one * * pb 12749 * * DB2 HPU ends with completion code 0 * * despite the fact that a LISTDEF * * specifying a non existing partition * * number in the PARTLEVEL option is * * specified. In such as case, the * * utility should stop with completiong * * code 8 after having issued the * * following messages : * * INZI321E LISTDEF ERROR: INVALID * * PARTLEVEL FOR dbame.tsname VALID * * RANGE IS (n : m) * * INZU366I UTILITY RETURN CODE 8 (REASON * * CODE 0x107a002) * * pb 12750 * * The description or help text of some * * parameters are incorrect. * * - (VUM031/QUITUSR) should read * * (VUM031/QUITSUSR) * * - The default value mentionned in the * * help text for VUM025/SRTVSMIN is * * wrong. Instead of "The default value * * is 2147483647" it should read 'The * * default value is the value of * * VUX022/VBUFSIZE parameter. " * * - The short names of the parameter * * "Number of rows retrieved by an SQL * * FETCH function" is missing. * * (VUU035/ULROWSET) should be added. * * - The description "DB2 HPU response * * when a LOADDDN cannot be generated * * (VUU038/UNLLDER)" mentions a wrong * * short name. VUU038 should actually * * read /VUU039 * * pb 12751 * * SINZDENU(INZLAUNC) text references * * 4.2, should be 4.3 that is xrel = * * '420' should be '430'. * * pb 12758 * * The DB2 HPU BIND job (generated from * * the SINZDENU(INZBIND) template) * * should specify ACTION(REPLACE) * * RETAIN. * * pb 12757 * * In TCz, the online help for * * (VUU045/ULFORMAT) has a corrupted * * character if the CCSID used for the * * terminal is not 37. * * In such a case, the help text looks * * like the following : * * Output format to use for logical * * unloads when the FORMAT parameter is * * not specified in the UNLOAD command. * * Valid values are * * DSNTIAUL DELIMITED VARIABLE EXTERNAL * * USER,STRICT ALL END * * (optional parts are surrounded by <>). * * Example: VARIABLE,ALL. The * * default value is DSNTIAUL. * * instead of Output format to use for * * logical unloads when the FORMAT * * parameter is not specified in the * * UNLOAD command. Valid values are * * {DSNTIAUL|DELIMITED|VARIABLE| * * EXTERNAL|USER}<,{STRICT|ALL|END}> * * (optional parts are surrounded by <>). * * Example: VARIABLE,ALL. The default * * value is DSNTIAUL. * * The characters { and } are replaced by * * and . Characters non CCSID * * dependent should be used instead. * * pb 12775 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** The inzrunh and inzrun modules were changed. The udbldef, udbspnfx, inzpabf and inzpab modules were changed. The inztssid,inzttvar, inzhpucl, inzlaunc, inzadtoo, inzzscod, inzcheck, inz$$dsc, inztdsc modules were changed. The inztcprm and inz$$seq modules were changed. The inzpabf and inzpab modules were changed. The olistdef module was changed. The inztcprm module was changed. The inzadbsk module was changed. The inzsbind module was changed. The inztcprm module was changed.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI40661
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
430
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-05-07
Closed date
2015-05-21
Last modified date
2015-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI27861
Modules/Macros
HINZ430J INZ$$DSC INZ$$PRM INZADTOO INZBIND INZCHECK INZHPUCL INZLAUNC INZTDSC INZTSSID INZTVAR INZUTILK INZZSCOD
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R430 PSY UI27861
UP15/05/27 P F505
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUUV","label":"IBM Db2 High Performance Unload for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021