IBM Support

PH35200: INZU244I MISSING WHEN GBLPARAL_MAXPART_SET_NULL (YES)

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The following message
    INZU244I IN SELECT STARTING AT (n, p)
    TABLESPACE dbname.tsname
    MAXPART OPTION IS SET TO 0
    DUE TO GBLPARAL_MAXPART_SET_NULL(YES) IN VUU030/ULOPTNS PARMLIB
    VARIABLE
    should be issued but is missing.
    
    This occurs if the following conditions are fulfilled :
    - GBLPARAL_MAXPART_SET_NULL(YES) is set in VUU030/ULOPTNS
    - VUU060/ULMAXPAR is set to a non zero value
    - VUU036/GBLPARAL is set to NO
    - the unload requires the data from several partitions of a
    tablespace be unloaded into a single dataset and does not
    specify the MAXPART option
    - the number of partition to be unloaded is greater than the
    value of VUU060/ULMAXPAR
    

Local fix

  • none but this only affects the reporting and not the
    related feature (MAXPART is set to 0 as designed).
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 High Performance Unload         *
    *                 for z/OS                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following message                   *
    *                      INZU244I IN SELECT STARTING AT (n, p)   *
    *                      TABLESPACE dbname.tsname                *
    *                      MAXPART OPTION IS SET TO 0              *
    *                      DUE TO GBLPARAL_MAXPART_SET_NULL(YES)   *
    *                      IN VUU030/ULOPTNS PARMLIB VARIABLE      *
    *                      should be issued but is missing.        *
    *                                                              *
    *                      This occurs if the following conditions *
    *                      are fulfilled :                         *
    *                      - GBLPARAL_MAXPART_SET_NULL(YES) is set *
    *                      in VUU030/ULOPTNS                       *
    *                      - VUU060/ULMAXPAR si set to a non zero  *
    *                      value                                   *
    *                      - VUU036/GBLPARAL si set to NO          *
    *                      - the unload requires the data from     *
    *                      several partitions of a tablespace be   *
    *                      unloaded into a single dataset and does *
    *                      not specify the MAXPART option          *
    *                      - the number of partition to be         *
    *                      unloaded is greater than the value of   *
    *                      VUU060/ULMAXPAR                         *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    INZU244I missing when GBLPARAL_MAXPART_SET_NULL (YES)
    

Problem conclusion

  • Code has been changed to fix this problem
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH35200

  • 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

    2021-03-10

  • Closed date

    2021-03-23

  • Last modified date

    2021-04-02

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

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

Modules/Macros

  • INZCHECK INZCRX10 INZCRXSM INZCRXSQ INZTPMEM INZUTILK
    

Fix information

  • Fixed component name

    DB2 HI PERF UNL

  • Fixed component ID

    5697F4400

Applicable component levels

  • R510 PSY UI74571

       UP21/03/30 P F103

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.1.0"}]

Document Information

Modified date:
03 April 2021