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