PI84021: BINARY ZEROES AND NORMAL COMPLETION IF INVALID TIME FORMAT WITH NN

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An unload specifying an invalid TIME format containing NN unduly
  completes with a normal completion code and fills up the related
  output field(s) with binary zeroes. DB2 HPU shouyld end with an
  error message and a completion code of 8 instead.
  
  PB49059
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of the High Performance Unload                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * 1. An unload specifying an invalid TIME format containing NN *
  * unduly completes with a normal completion code and fills up  *
  * the related output field(s) with binary zeroes. DB2 HPU      *
  * should end with an error message and a completion code of 8  *
  * instead.                                                     *
  * 2. The unload process enters an infinite loop when an unload *
  * specifies an invalid TIMESTAMP format containing more than   *
  * one NN element.                                              *
  * 3. An unload specifying a TIME/TIMESTAMP format and          *
  * requesting the related LOAD statement be generated (LOADDN   *
  * option) can create an invlid LOAD statement.                 *
  * This occurs:                                                 *
  * - if the format specified for TIME is shorter than 4         *
  * characters                                                   *
  * - or if the format specified for TIMESTAMP is shorter than   *
  * 16 characters                                                *
  * 4. An unload specifying DATA format and requesting the       *
  * related LOAD statement be generated (LOADDN option) can      *
  * create an invlid LOAD statement.                             *
  * This occurs:                                                 *
  * - if the format specified for DATE is shorter than 8         *
  * characters                                                   *
  * 5. The unload process against a partitioned tablespace with  *
  * the zIIP use enabled might get stuck in a wait state. This   *
  * can occur if the parmlib parameter VUX043/ZIIPMXPU is set to *
  * 0 (default value) and the parmlib parameter VUX042/ZIIPMXPL  *
  * is not set to 0.                                             *
  * 6. (HPU 5.1 only) DB2 HPU ends with completion code 8 after  *
  * having issued the following error messages:                  *
  *                                                              *
  * INZI143E ERROR: DURING SYSIN ALLOCATION                      *
  * INZI169E ERROR WHEN OPENING SYSIN                            *
  * INZI165E ERROR WHEN TRYING TO QUIESCE THE PARTITION(S) OF    *
  * TABLESPACE DMDEPOD2.DMDPFTTS                                 *
  * 7. An unload stops intermittently with completion code 16    *
  * after having issued the message INZI151E ERROR WHEN FINDING  *
  * SQLID, ERROR CODE: 16 REASON CODE: 00000000. The issue has   *
  * only been encountered when running DB2 HPU against a DB2     *
  * data sharing group but might also occur with a single DB2    *
  * subsystem.                                                   *
  * This can occur if the QUIESCE feature is requested.          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF                                                *
  ****************************************************************
  

Problem conclusion

• The fix includes code to correct the issue.
  

Temporary fix

• 5. Set the parmlib parameter VUX042/ZIIPMXPL to 0 or 0 the
  parmlib parameter VUX043/ZIIPMXPU to a non zero value.
  

Comments

• Documentation update for #3:
  INZU527I LOAD STATEMENT NOT GENERATED FOR SELECT STARTING AT
  position DUE TO COLUMN column_name, data_type FORMAT NOT
  SUPPORTED BY LOAD UTILITY.
  
  Explanation: HPU has not generated the requested load statement
  because the unloaded data contains fields in a
  date/time/timestamp format that are not supported by the LOAD
  utility. The indicated data_type might be a supported by the
  LOAD utility but the actual format requested for the indicated
  target column mentionned in the text is not.
  User response: Check the format requested for the indicated
  column name. Do check if any reformatting clause such as an INTO
  or a REFORMAT clause applies to this column. If you need to load
  the data unloaded by DB2 HPU to be reloadable by the LOAD
  utility, consider changing the format specification for this
  column. Otherwise, i,e, if you need the data formatted as
  specified, consider removing the LOADDDN option that might have
  been specified by mistake.
  Return code: 0
  
  Documentation update for #4:
  INZU527I LOAD STATEMENT NOT GENERATED FOR SELECT STARTING AT
  position DUE TO COLUMN column_name, data_type FORMAT NOT
  SUPPORTED BY LOAD UTILITY.
  
  Explanation: HPU has not generated the requested load statement
  because the unloaded data contains fields in a
  date/time/timestamp format that are not supported by the LOAD
  utility. The indicated data_type might be a supported by the
  LOAD utility but the actual format requested for the indicated
  target column mentionned in the text is not.
  User response: Check the format requested for the indicated
  column name. Do check if any reformatting clause such as an INTO
  or a REFORMAT clause applies to this column. If you need to load
  the data unloaded by DB2 HPU to be reloadable by the LOAD
  utility, consider changing the format specification for this
  column. Otherwise, i,e, if you need the data formatted as
  specified, consider removing the LOADDDN option that might have
  been specified by mistake.
  Return code: 0
  

APAR Information

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

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

  UI49104

Modules/Macros

• INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI49104

     UP17/08/09 P F708

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.