PH14937: UNDUE COMPLETION CODE OF 8 AFTER EXPECTED INZI800E IF ZIIP IN USE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This attempt to read the "next" LDS occurs when the current LDS
  is almost full is a normal Db2 HPU operation and its failure
  should not be considered as an error and the process should go
  on.
  This issue only occurs when the zIIP processors are used.
  
  PB58317 msgINZI800E
  

Local fix

• disable the zIIP use by specifying the ZIIP OFF option.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Db2 High Performance Unload for z/OS                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PH13384:                                                     *
  * The output data set for an unload requesting an fixed length *
  * output format has an unexpected DCB with RECFM=VB. As a      *
  * consequence, the LRECL may also be greater than expected,    *
  * i.e. LRECL=expected_lrecl+4 where expected_lrecl is the      *
  * value of the LRECL attribute expected for the output         *
  * dataset.                                                     *
  * This occurs if the following conditions are fullfilled:      *
  *  - the Fast Unload syntax is used                            *
  *  - the unload is run in native mode                          *
  *  - the requested output format is a fixed length format      *
  *  - the data to unload is from a partitionned tablespace      *
  *  - parallelism is enabled (VUX025/PARALLEL is set to a value *
  * greater than 1 and no specification of the unload disable    *
  * parallelism)                                                 *
  *  - no RECFM attribute is specified for the output dataset or *
  * the "Override DCB FAST UNLOAD syntax (VUM029/DFSIGDCB)"      *
  * parmlib parameter is set to YES                              *
  *  - the VUU036/GBLPARAL parameter is set to NO                *
  *                                                              *
  * PH13979:                                                     *
  * Fix 1 - On a DB2 with SQLDELIM set to QUOTE, any unload      *
  * stops at the vey begining of the process with completion     *
  * code of 8 after having reported the following error:         *
  * INZI193E DB2 ERROR: {DB2 FOR OS/390}{ODBC DRIVER}{DSN10015}  *
  *                                                              *
  * DSNT408I SQLCODE = -206, ERROR:  SYSIBM.DECIMAL_POINT IS NOT *
  * VALID IN THE                                                 *
  *                        CONTEXT WHERE IT IS USED              *
  * INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x18a00d)        *
  * Fix 2 - An unload requesting XML data be unloaded from a     *
  * FlashCopy data set fails with completion code 8 and reason   *
  * code 0x121a013 reported through the following message:       *
  *  INZU366I UTILITY RETURN CODE 8 (REASON CODE 0x121a013)      *
  * but no error message is issued.                              *
  * This occurs if the NODEID index space on the XML table space *
  * containing the involved XML column has several LDS.          *
  *                                                              *
  * PH14203:                                                     *
  * After the fix for PH04657/PB54892 has been applied, if the   *
  * userid of the submitter of the job (USER parameter from JOB  *
  * statement) is 8 character long, the unload job can hang or   *
  * other unpredictable issues can occur.                        *
  * This can occur only if the following conditions are          *
  * fiullfilled:                                                 *
  * - at least one of the following parameters is not set to     *
  * CURRENT_USER and the specified value is different from the   *
  * userid of the job submitter.                                 *
  *    ? VUM028/DISPLUSR                                         *
  *    ? VUM031/QUITSUSR                                         *
  *    ? VUM032/ACTLGUSR                                         *
  *    ? VUM035/EXPLNUSR                                         *
  * and the feature(s) driven by this(these) parameter(s)        *
  * is(are) put into action                                      *
  * - the VUU030/ULOPTNS setting specifies                       *
  * USER_SWITCH_METHOD(AS)                                       *
  *                                                              *
  * PH14502:                                                     *
  * The unload of the data from image copies of a partitioned    *
  * table space terminates in ABENDSC03 or issue messages about  *
  * not being able to unallocate some data set (such as          *
  * IKJ56861I FILE SYS00008 NOT UNALLOCATED, DATA SET IS OPEN)   *
  * when the following conditions are fulfilled :                *
  * - several image copies at the partition level are used as    *
  * input                                                        *
  * - the involved image copies are not inline image copies      *
  * - the use of ZIIP processor is enable (i.e. ZIIP OFF does    *
  * not apply)                                                   *
  * Other symptoms resulting from the failure to unallocate may  *
  * occur such as the failure to allocate another file when some *
  * of the Db2 PPU input/output files are allocated on tape      *
  * reported through messages such as the following one:         *
  * INZU370I LDS ALLOCATION FAILED FOR dbname.tsname PART n, DB2 *
  * CATALOG IS ACCESSED TO UPDATE LDS NAME.                      *
  *                                                              *
  * PH14937:                                                     *
  * After the apllication of the maintenance for                 *
  * PH09203/PB55763, Db2 HPU stops with completion code of 8     *
  * after having reported the follwing error as follows          *
  *     INZI800E ERROR ACCESSING TO A DATASET. ACTION: ALLOCATE  *
  * RC: 0x1708                                                   *
  *     REASON: 0x2                                              *
  *     DDN: SYSnnnnn DSN:                                       *
  * vcat.DSNDBC.dbname.tsname.iprefix.Annn                       *
  * where the mentioned data set                                 *
  * vcat.DSNDBC.dbname.tsname.iprefix.Annn does not exist and    *
  * the vcat.DSNDBC.dbname.tsname.iprefix.Ammm where mmm = nnn - *
  * 1 exists.                                                    *
  * This attempt to read the "next" LDS occurs when the current  *
  * LDS is almost full is a normal Db2 HPU operation and its     *
  * failure should not be considered as an error and the process *
  * should go on.                                                *
  * This issue only occurs when the zIIP processors are used.    *
  *                                                              *
  * PH14986:                                                     *
  * GDPR compliance to use Pervasive Encryption capability of    *
  * z14 processor.                                               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF.                                               *
  ****************************************************************
  Code has been changed to fix this problem.
  

Problem conclusion

• Apply the PTF.
  

Temporary fix

• PH13384:
  If the "Override DCB FAST UNLOAD syntax (VUM029/DFSIGDCB)"
  parmlib parameter is set to NO, specify RECFM=FB for the output
  dataset.
  PH14203:
  None unless all the parameters mentionned above can be set to
  CURRENT_USER.
  PH14502:
  Disable the use of zIIP processors by specifying the ZIIP OFF
  option.
  PH14937:
  Disable the zIIP use by specifying the ZIIP OFF option.
  

Comments

• ×**** PE20/01/09 FIX IN ERROR. SEE APAR PH17313  FOR DESCRIPTION
  

APAR Information

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

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

  UI64922

Modules/Macros

• INZTDSC  INZ$$PRM INZCHECK INZUTILK INZTVAR  INZTSSID
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R510 PSY UI64922

     UP19/09/20 P F909

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.