A fix is available
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