IBM Support

PH73778: ADDED SUPPORT FOR A DEFAULT ROW LIMIT OF 500 ROWS WHEN EXECUTING QUERIES IN ADMIN FOUNDATION

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Previously, query results were returned without a default row
    limit. In some cases, users could unintentionally retrieve very
    large result sets, which could impact overall system stability
    and resource utilization.
    With this change, query results are limited to 500 rows by
    default, helping to provide a more consistent and reliable user
    experience while reducing the risk of resource-related issues.
    Users can still modify the row limit as needed to retrieve
    additional results based on their requirements.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the IBM Unified Management Server   *
    *                 for z/OS and the following experiences:      *
    *                 - Db2 Administration Foundation for z/OS     *
    ****************************************************************
    * PROBLEM DESCRIPTION: To prevent unbounded query execution    *
    *                      and reduce potential performance        *
    *                      impacts, UMS will automatically apply   *
    *                      a hard-coded default row limit of 500   *
    *                      rows to SQL queries that do not specify *
    *                       a row limit. If a user provides a      *
    *                      custom row limit using the existing     *
    *                      row-limit option, that value will take  *
    *                       precedence over the default limit.     *
    ****************************************************************
    Introduce a default row limit of 500 rows for all SQL queries
    executed in UMS when no row limit is explicitly specified.
    User-defined row limits will continue to be supported and will
    override the default value.
    

Problem conclusion

  • Apply the PTF provided by this APAR
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH73778

  • Reported component name

    UNIFIED MGMT SV

  • Reported component ID

    5698UM100

  • Reported release

    120

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2026-10-26

  • Closed date

    2026-11-17

  • Last modified date

    2026-11-18

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

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

    UO10397

Modules/Macros

  • IZPMNFST IZPSERVE IZPUI
    

Fix information

  • Fixed component name

    UNIFIED MGMT SV

  • Fixed component ID

    5698UM100

Applicable component levels

  • R120 PSY UO10397

       UP26/11/18 I 1000  

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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"120"}]

Document Information

Modified date:
18 November 2026