PH00914: ISSUE A MESSAGE TO EXPLAIN VUX005/MAXSORT OVERRIDES VUX025/PARALLEL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A value greater than the one set for VUX025/PARALLEL is used for
  limiting the parallelism degree where the partition reading is
  concerned.
  
  For example, although VUX025/PARALLEL is set to 15, the
  following message is issued:
  INZU221I PARALLELISM ACTIVATED FOR PARTITION PROCESSING.
    MAXIMUM DEGREE OF PARALLELISM IS SET TO 20
  
  
  The message text should explain that this occurs because the
  VUX005/MAXSORT value overrides the value of VUX025/PARALLEL.
  
  PB53562
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of High Performance Unload                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PI98606:                                                     *
  * The HPU job hangs when an abend occurs while a sort launched *
  * by HPU is in progress.                                       *
  * This occurs if the parameter 'Management of exit written in  *
  * C or COBOL(VUU079/EXITHLL)' is set to NO.                    *
  *                                                              *
  * PI99711:                                                     *
  * The unload stops with completion code 8 after having issued  *
  * an error message such as:                                    *
  * INZI188E UNABLE TO RETRIEVE VSAM INFORMATION FOR THE         *
  * TABLESPACE dbname.tsname                                     *
  *           LDS : indexspace_dataset_name                      *
  * This occurs when:                                            *
  * - the unload job is processed in native mode                 *
  * - the HURBA of one of the related LDS (table space or index) *
  * is greater than or equal to 4 GB                             *
  * - the "Use real-time statistics tables for size estimation   *
  * (VUX036/RTSESTIM)" parameter is set to NO                    *
  *                                                              *
  * PH00914:                                                     *
  * A value greater than the one set for VUX025/PARALLEL is used *
  * for limiting the parallelism degree                          *
  * where the partition reading is concerned.                    *
  * For example, although VUX025/PARALLEL is set to 15, the      *
  * following message is issued:                                 *
  *  INZU221I PARALLELISM ACTIVATED FOR PARTITION PROCESSING.    *
  *  MAXIMUM DEGREE OF PARALLELISM IS SET TO 20                  *
  * The message text should explain that this occurs because the *
  * VUX005/MAXSORT value overrides the                           *
  * value of VUX025/PARALLEL.                                    *
  *                                                              *
  * PH01174:                                                     *
  * The INZU502W message is issued but this does not affect the  *
  * completion code and the unload may                           *
  * unduly end with a completion code less than 4.               *
  *                                                              *
  * PH02252:                                                     *
  * HPU terminates with a completion code of 8 when a logical    *
  * unload processed in native mode involves a                   *
  * conversion from CHAR data to DECFLOAT. Either of the         *
  * following messages are issued:                               *
  * - INZU025E INVALID OPERAND FOR OPERATOR DECFLOAT() if the    *
  * source data involved in the conversion is                    *
  * constant                                                     *
  * -formatting error messages indicating EXPRESSION EVALUATION  *
  * ERROR and a subsequent INZU447E message                      *
  * if the source data involved in the conversion is an SQL      *
  * expression involving a column of a table                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF for problem resolution                         *
  ****************************************************************
  

Problem conclusion

• Code has been changed to fix this problem
  

Temporary fix

• PI98606:
  Consider setting the VUU079/EXITHLL parameter to YES (and
  regenerate and submit the INZALIAS
  customization job afterwards) but take into account that leads
  to an increase HPU jobs memory
  consumption. If only some HPU jobs are more prone to
  intermittent ABEND such as ABENDSx37 issues,
  prefer altering these very jobs by running the INZUTIB2 module
  instead of INZUTILB.
  
  PI99711:
  Set the "Use real-time statistics tables for size estimation
  (VUX036/RTSESTIM)" parameter to YES.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI58539

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI58539

     UP18/09/21 P F809

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.