PM54847: INZU221I AND INZX005 GENERATING UNEXPECTED PARALLELISM

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Partition parallelism is activated although GBLPARAL NO is
  requested and the unload commend specifies a unique output data
  set for all partitions.  This occurs when the number of
  partitions of the table space involved in the unload is greater
  than or equal to the value of VUU060/ULMAXPAR.
  The following messages which show that parallelism is in action
  are issued.
     INZU221I PARALLELISM ACTIVATED FOR PARTITION PROCESSING.
     MAXIMUM DEGREE OF PARALLELISM IS SET TO n
  .
  and the following msg is issued for each partition involved
  in the unload:
     INZX005 ID7276S1 PARTITION NO. n IS BEING READ
  PB11393
  

Local fix

• Specify MAXPART 0 in the unload command or set VUU060/ULMAXPAR
  to 0. Be aware that changing the ULMAXPAR value can have impacts
  on performance or resources needed when unloading table spaces
  having a number of partitions larger than the current value of
  ULMAXPAR.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: The partition parallelism is activated  *
  *                      although GBLPARAL NO is requested and   *
  *                      the unload command specifies a unique   *
  *                      output data set for all partitions.     *
  *                      In such a case, the following messages  *
  *                      which show that parallelism is in       *
  *                      action are issued. The following        *
  *                      messgae is issued once:                 *
  *                        INZU221I PARALLELISM ACTIVATED FOR    *
  *                       PARTITION PROCESSING.                  *
  *                        MAXIMUM DEGREE OF PARALLELISM IS      *
  *                       SET TO p                               *
  *                      and the following one is issued for     *
  *                      each partition involved in the unload:  *
  *                        INZX005 ID7276S1 PARTITION NO. n IS   *
  *                       BEING READ                             *
  *                      It occurs where the number of           *
  *                       partitions of the table space          *
  *                       involved in the unload is greater or   *
  *                       equal than the value of                *
  *                       VUU060/ULMAXPAR.                       *
  *                      PB 11393                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inztoken, inzmsgs, inzmain and inzpab  were changed to
  allow the user to request parallelism be disabled when both
  GBLPARAL NO, MAXPART 0 are specified for an unload into a
  single file.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

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

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

  UK76342 UK76343

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK76342

     UP12/02/24 P F202

• R410 PSY UK76343

     UP12/02/24 P F202

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.