IBM Support

PH73499: IMPROVEMENTS FOR RUNSTATS TABLESPACE PART INDEX STATISTICS COLLECTION REDUCTION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Support for the INCLUDE NPI keyword on the RUNSTATS TABLESPACE
    PART statement, introduced by Db2 APAR PH70307
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    ****************************************************************
    * PROBLEM DESCRIPTION: This enhancement provides support for   *
    *                      the INCLUDE NPI keyword on the RUNSTATS *
    *                      TABLESPACE PART statement, introduced   *
    *                      by Db2 APAR PH70307.                    *
    ****************************************************************
    Db2 APAR PH70307 (Db2 13 FL500) adds the INCLUDE NPI keyword to
    the RUNSTATS TABLESPACE PART utility statement, allowing control
    over whether nonpartitioned indexes (NPIs) are scanned when
    collecting statistics for a single table space partition.
    With this APAR, the existing INCLUDE NPI option on the 'Utility
    Options' panels (ADB2USR and ADB2USRA) is no longer a sub-option
    of USE PROFILE and can be used in conjunction with the INDEX
    keyword.
    This behavior is active only when Db2 Admin Tool is connected to
    Db2 13 FL510 or later. If FL510 is not active, the previous
    behavior is preserved (where INCLUDE NPI is valid only with USE
    PROFILE).
    

Problem conclusion

Temporary fix

Comments

  • The enhancement has been delivered.
    

APAR Information

  • APAR number

    PH73499

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    D10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2026-10-09

  • Closed date

    2026-10-21

  • Last modified date

    2026-11-02

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

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

    UO10076

Modules/Macros

  • ADB25LU  ADB2USR  ADB2USRA ADB2USRO ADBHUSR  ADBHUSRA
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RD10 PSY UO10076

       UP26/10/23 P F610  

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.

[{"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":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 November 2026