PH15696: EXTRA ROWS WHEN UNLOAD SEVERAL PARTITION IN NATIVE MODE WITH ZIIP PROCESSOR USE 20/02/28 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• (HPU 5.1 only) After the enhancement for PH09203 has been
  applied, extra rows can be unloaded when the following
  conditions are fullfilled:
  - the involved table space is partitioned
  - the unload is run in native mode
  - the zIIP processors are used
  - the data from more than one partition is unloaded
  - the LDS parallelism degree is less than the number of
  partitions to unload
  - at least one partition contains a deleted page referenced in
  the space map and is processed
  Extra rows are actually unloaded only if the partition with
  deleted pages referenced in the space map is processed after the
  first set of partitions unloaded in parallel. The unexpected
  rows comes from the deleted page which are unduly processed.
  

Local fix

• consider disabling the zIIP use by specifying the ZIIP OFF
  option or run the unload in SQL mode by specifying the DB2 FORCE
  option
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of High Performance Unload                             *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PH15510                                                      *
  * Options of the GLOBAL OPTIONS block should allow overriding  *
  * the following parameters                                     *
  * that tune the DELIMITED format:                              *
  * - DATE/TIME delimiter option (VUU031/DTDELIM)                *
  * - NULL DATE/TIME delimiter option (VUU043/DTNULDLM).         *
  *                                                              *
  * PH15568                                                      *
  * Support of the TIME UTC/LOCAL keyword in TEMPLATE statement  *
  * specified along with an                                      *
  * unload command in HPU native syntax.                         *
  *                                                              *
  * PH15696                                                      *
  * After the enhancement for PH09203 has been applied, extra    *
  * rows can be unloaded when the                                *
  * following conditions are fullfilled:                         *
  * - the involved table space is partitioned                    *
  * - the unload is run in native mode                           *
  * - the zIIP processors are used                               *
  * - the data from more than one partition is unloaded          *
  * - the LDS parallelism degree is less than the number of      *
  * partitions to unload                                         *
  * - at least one partition contains a deleted page referenced  *
  * in the space map and is processed                            *
  * Extra rows are actually unloaded only if the partition with  *
  * deleted pages referenced in                                  *
  * the space map is processed after the first set of partitions *
  * unloaded in parallel.                                        *
  * The unexpected rows comes from the deleted page which are    *
  * unduly processed.                                            *
  *                                                              *
  * PH16349                                                      *
  * Db2 HPU indirectly retrieves the value of some of the        *
  * DSNZPARM parameters by running                               *
  * SQL statement where a more reliable and recommended way is   *
  * to use the                                                   *
  * SYSPROC.ADMIN_INFO_SYSPARM stored procedure meant for this   *
  * purpose.                                                     *
  * For the BIF_COMPATIBILITY parameter, Db2 HPU uses the        *
  * following SQL query :                                        *
  *      SELECT LENGTH(STRIP(CHAR(0.0))) FROM SYSIBM.SYSDUMMY1   *
  * which is reported through an undesirable IFCID 376 record.   *
  * With this enhancement, such a record is no longer issued.    *
  *                                                              *
  * PH16476                                                      *
  * When the VUU030/ULOPTNS parameter is set with a value that   *
  * contains both USER_SWITCH_METHOD                             *
  * (RACF)                                                       *
  * and an invalid value is specified for any of the parmlib     *
  * parameters, Db2 HPU stops with                               *
  * ABENDU2000                                                   *
  * rather than with a completion code of 8.                     *
  *                                                              *
  * PH16481                                                      *
  * A potential ABENDS0C4 occurs during termination of an unload *
  * involving an XML column.                                     *
  * CEEDUMP contains a trace as follows                          *
  * 6     _inzzpiltWaitForOneTask                                *
  *                   +000005A4  5287        INZUTILK            *
  * inzzpilt.c        Exception                                  *
  * 7     _inzzpiltWaitForAllTasks                               *
  *                   +0000012C  5395        INZUTILK            *
  * inzzpilt.c        Call                                       *
  * 8     _inzzpiltUnload                                        *
  *                   +00000202  3650        INZUTILK            *
  * inzzpilt.c        Call                                       *
  * 9     _inzzpiltUnloadThread                                  *
  *                   +0000018A  2213        INZUTILK            *
  * inzzpilt.c        Call                                       *
  * 10    oenclaveBootXplink                                     *
  *                   +00000138  1014        INZUTILK            *
  * oenclave.c        Call                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the PTF.                                               *
  ****************************************************************
  Code has been changed to fix this problem.
  

Problem conclusion

• Apply the PTF.
  

Temporary fix

• PH16476: The INZI365E message gives an explanation about the
  wrong setting.
  PH16481: None but the correct unloaded data is produced.
  PH15696: Consider disabling the zIIP use by specifying the ZIIP
  OFF option or run the unload in
  SQL mode by specifying the DB2 FORCE option
  

Comments

• ×**** PE20/07/06 FIX IN ERROR. SEE APAR PH25248  FOR DESCRIPTION
  

APAR Information

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

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

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.