A fix is available
APAR status
Closed as program error.
Error description
rolled up maintenance PB53817 PB54035 PB54073
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * Users of High Performance Unload * **************************************************************** * PROBLEM DESCRIPTION: * * PI98847: Support ORDER clause on columns with fieldproc in * * native mode * * * * PH01894: * * The time displayed along with the messages which numbers * * start with INZX is not consistent with the * * system time. * * This occurs if the setting of the LC_TOD category of the * * unix current locale does not ensure that * * the IBM/C localtime() function returns a time consistent * * with the z/OS system time settings. * * * * PH02085: * * The LRECL and RECFM parameters of the DCB of the SYSPRINT * * data set are set to RECFM=VB and * * LRECL=1028 instead of the expected RECFM=VBA and LRECL=124. * * This occurs if the following conditions are fullfilled: * * - the fix for PI97510/PB52783 is applied * * - these parameters (LRECL and/or RECFM) are not set via the * * SYSPRINT allocation by the process that * * invokes DB2 HPU * * - the file allocated as SYSPRINT does not already exists * * - the DISP parameter for SYSPRINT specifies MOD. * * * * PH02909: * * HPU hangs at the beginning of the process if the following * * conditions are fulfilled: * * - the ?User to QUIESCE the tablespace (VUM031/QUITSUSR)? * * parameter is not set to CURRENT_USER * * - the "User who issues SELECT by using dynamic SQL * * (VUM032/ACTLGUSR)" parameter is set to * * CURRENT_USER * * - the "User who runs the DISPLAY command (VUM028/DISPLUSR)" * * parameter is set to the same userid as * * VUM031/QUITSUSR * * - a preceding DB2 HPU step failed to perform the QUIESCE * * utility as reported by either the INZU176I * * or the INZU172E message because of the restricted state of * * the table space * * * * PH03148: * * Fix 1 - An allocation error occurs for one of the output * * data sets of a multiple SELECT unload * * command. The following error messages are issued: * * IEC143I 213-30,IFG0194D,HPUZ475R,REPRO,UL02,0AC7,INF006, * * 294 * * LABO.HPUZ0475.OUTDATA(UL02) * * * * ... * * SYSTEM COMPLETION CODE=213 REASON CODE=00000030 * * * * TIME=14.18.54 SEQ=52030 CPU=0000 ASID=0065 * * * * PSW AT TIME OF ERROR 075C1000 80DDF36E ILC 2 INTC 0D * * * * NO ACTIVE MODULE FOUND * * * * NAME=UNKNOWN * * * * DATA AT PSW 00DDF368 - 4100302C 0A0D010D A7E5014B * * * * AR/GR 0: 008C1CF0/00000000_00DDF678 1: * * 00000000/00000000_A4213000 * * 2: 00000000/00000048_0000B9C0 3: * * 00000000/00000000_00DDF64C * * 4: 00000000/00000000_008BD410 5: * * 00000000/00000000_008BD7A4 * * 6: 20C7CA00/00000000_008BD74C 7: * * E9D3D6C7/00000000_008BD7A4 * * 8: 00000000/00000000_008BD76C 9: * * 00000000/00000048_008BAEC0 * * A: 00000000/00000048_80DE1A0A B: * * 00000000/00000000_00DE25CA * * C: 00000000/00000000_80DE2826 D: * * 00000000/00000000_7F517CE8 * * E: 00000000/00000000_80DDEBCC F: * * 00000000/00000000_00000030 * * END OF SYMPTOM DUMP * * * * This occurs if at least two SELECT statements fullfil the * * following conditions: * * - their output data sets (défined through OUTDDN) are * * members of the same PDS data set. * * - the tables belong to the same tablespace or the * * parallelism is activated either for lds read in * * native mode, either for SQL unload in SQL mode * * Example: The following unload faces this issue. * * //UL01 DD DSN=LABO.HPUZ0475.OUTDATA(UL01),DISP=SHR * * //UL02 DD DSN=LABO.HPUZ0475.OUTDATA(UL02),DISP=SHR * * //SYSIN DD * * * UNLOAD TABLESPACE * * DB2 NO * * SELECT * FROM MZLFRD.TBDZBAFRD00601 * * OUTDDN UL01 * * SELECT * FROM MZLFRD.TBDZBAFRD00601 * * OUTDDN UL02 * * ; * * Fix 2 - An unpredictable incorrect result, including * * incorrect unloaded data, completion code 8 and * * ABENDS0C4, can occur when attempting to unload in native * * mode, the data from a table that fulfills * * the followings conditions: * * - the table has one column defined with a FIELDPROC which * * decoded data type is variable and the * * encoded data type is not variable. * * - the table has another column having a variable type * * + either defined with a FIELDPROC with encoded data * * having a variable type (case 1) * * + or with no FIELDPROC (case 2), * * If case 1 applies, Db2 HPU issues the following message : * * * 231 * FIELDPROC ERROR * * * and stops with completion code of 8. * * If case 2 applies, Db2 HPU either: * * - produces incorrect unpredictible unloaded data * * - ends with ABENDS0C4. * * Fix 3 - A logical unload run in native mode produces * * incorrect unloaded data for a column with a * * field procedure (FIELDPROC) that encodes the data into * * decimal data type. No generic description of * * the data alteration in the related output field can be * * given. * * * * PH03150: * * Fix 1 - An unpredictable ABEND (among which ABENDU4088, * * ABENDS0C1, ABENDS0C4...) can occur when the * * following conditions are fulfilled: * * - two UNLOAD commands are specified * * - the first UNLOAD command (in writing sequence) specifies * * at least two SELECT statements among * * which a SELECT statement with an SQLPART clause run in SQL * * mode. * * Fix 2 - The SYSPRINT dataset is unduly allocated with a * * RECFM=FB although although the SYSPRINT DD * * statement specifies RECFM=FBA. * * For example, the issue occurs if the SYSPRINT DD statement * * specifies * * //SYSPRINT DD DSN=MZLFRD.XCA.T000001.SYSPRINT, * * // DISP=(NEW,CATLG,CATLG), * * // SPACE=(TRK,(10,10,0)), * * // UNIT=WORK,RECFM=FBA,LRECL=4096 * * Fix 3 - When the fix for APAR PH01899, i.e. PTF UI58156 is * * applied, incorrect output data is * * unloaded for numerical data unloaded as VARCHAR or CHAR when * * the following conditions are fulfilled: * * - PIC option specified for this resulting column * * - JUST RIGHT applies to this resulting column (specified * * either in the UNLOAD statement or in * * PARMLIB). * * - ccsid conversion is needed from local EBCDIC to another * * ccsid. * * The issue affects the padding character that is not the * * expected one. An unpredicatble character is * * used instead. For example, for data unload in unicode the * * expected padding character, encoded as * * x'20' (space in unicode), might be replaced by the incorrect * * x'1A' code. In such a case, Db2 HPU * * could unload * * 11111111111111111231 * * AAAAAAAAAAAAAAAAAB1A * * instead of * * 22222222222222222223 * * 000000000000000000B1 * **************************************************************** * RECOMMENDATION: * * Apply the PTF for problem resolution * ****************************************************************
Problem conclusion
Code has been changed to fix this problem
Temporary fix
PH01894: Set the LC_TOD category of the unix current locale so that the IBM/C localtime() function returns a time consistent with the z/OS system time settings. PH02085: Specify the desired DCB RECFM and LRECL attributes of the SYSPRINT ddname. PH02909: Consider changing the setting as follows: - either set a specific user for VUM032/ACTLGUSR parameters - or set CURRENT_USER for the parameter VUM031/QUITSUSR. You can also use the SQL mode (can be forced by specifying the DB2 FORCE option) if the unloaded objects are regularly in restricted state that prevents the QUIESCE utility to be run against them. You can also run the DB2 HPU steps into separate jobs. PH03148: Fix 1 - Separate the SELECT statements that share the same output PDS into separate UNLOAD commands such as in the following example: //UL01 DD DSN=LABO.HPUZ0475.OUTDATA(UL01),DISP=SHR //UL02 DD DSN=LABO.HPUZ0475.OUTDATA(UL02),DISP=SHR //SYSIN DD * GLOBAL DB2 NO UNLOAD TABLESPACE SELECT * FROM MZLFRD.TBDZBAFRD00601 OUTDDN UL01 ; UNLOAD TABLESPACE SELECT * FROM MZLFRD.TBDZBAFRD00601 OUTDDN UL02 ; Fix 2 - Run the unload in SQL mode by specifying the DB2 FORCE option. Fix 3 - Run the unload in SQL mode by specifying the DB2 FORCE option. PH03150: Fix 1 - Separate the UNLOAD commands into distinct steps.
Comments
×**** PE19/05/20 PTF IN ERROR. SEE APAR PH11228 FOR DESCRIPTION ×**** PE19/07/25 PTF IN ERROR. SEE APAR PH10355 FOR DESCRIPTION ×**** PE19/07/25 PTF IN ERROR. SEE APAR PH10355 FOR DESCRIPTION ×**** PE19/07/25 PTF IN ERROR. SEE APAR PH10355 FOR DESCRIPTION
APAR Information
APAR number
PH03150
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
510
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-09-21
Closed date
2018-10-04
Last modified date
2019-07-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI58908
Modules/Macros
INZUTILC INZUTILK INZUTIB2 INZUTIB1
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R510 PSY UI58908
UP18/10/09 P F810
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":"5.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021