IBM Support

PH30965: INZU547W REASON 1136-75 WHEN PARALLELISM LESS THAN THE NUMBER OF UNLOADED PARTITIONS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • An unload run in native mode and involving LOB
    data unduly issues the INZU547W message indicated REASON 1136-75
     and stops with a completion code of 8.
    
    This occurs if the following conditions are fulfilled :
    - the involved table space is partitioned
    - the unload requests LOB data be unloaded into a PDS allocated
    by a TEMPLATE statement specifying a dataset name-expression
    with the &PART or &PA variable
    - the applicable LDS parallelism degree indicated by the
    INZU221I, INZU476I and INZU523I messages is less than the number
    of partitions involved by the unload
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 High Performance Unload         *
    *                 for z/OS                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: An unload run in native mode and        *
    *                      involving LOB data unduly issues the    *
    *                      INZU547W message indicated              *
    *                      REASON 1136-75 and stops with a         *
    *                      completion code of 8.                   *
    *                                                              *
    *                      This occurs if the following conditions *
    *                      are fulfilled :                         *
    *                      - the involved table space is           *
    *                      partitioned                             *
    *                      - the unload requests LOB data be       *
    *                      unloaded into a PDS allocated by a      *
    *                      TEMPLATE statement specifying a dataset *
    *                      name-expression with the &PART or &PA   *
    *                      variable                                *
    *                      - the applicable LDS parallelism degree *
    *                      indicated by the INZU221I, INZU476I and *
    *                      INZU523I messages is less than the      *
    *                      number of partitions involved by the    *
    *                      unload                                  *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    INZU547W REASON 1136-75 when parallelism less than the number
    of unloaded partitions
    

Problem conclusion

  • Code has been changed to fix this problem
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH30965

  • Reported component name

    DB2 HI PERF UNL

  • Reported component ID

    5697F4400

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-10-27

  • Closed date

    2020-11-20

  • Last modified date

    2021-01-30

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

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

Modules/Macros

  • INZ$$PRM INZA30   INZA40   INZB601E INZB601I INZB61   INZB70E
    INZB70I  INZBIND  INZCHECK INZCRXSM INZCRXSQ INZHPUCL INZSDN
    INZTDSC  INZTPMEM INZTVAR  INZUTIB1 INZUTIB2 INZUTILC INZUTILK
    INZUTILL
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R510 PSY UI72678

       UP21/01/04 P F012

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0"}]

Document Information

Modified date:
12 February 2021