IBM Support

Alerts for IBM i System Limits



IBM i will send messages to the QSYSOPR message queue for a subset of the System Limits support. These messages are intended to alert the IBM i system operator to a high level of consumption of an important system limit.


You are in: IBM i Technology Updates > Db2 for i - Technology Updates >  Db2 for i - Services (SQL) > Tracking Important System Limits > Alerts for IBM i System Limits

This fact page is a resource to help IBM i clients understand the options available to help them to proactively manage instances of high consumption of a critical limit and avoid a potential outage.

Refer to the following topics:

IBM i System Limits tracking: 
For the most important system resources, the IBM i operating system automatically tracks the highest consumption and consumers.

The IBM i operating system is comprised of many products and components. As an integrated operating system, not only do the products and components frequently rely upon each other, but common building blocks and resources are used. Some of the resources are deemed to be critical because their proper use and consumption is directly related to achieving continued, normal operational behavior. The repository for this tracking lies within Db2 for i.

A table, a view, and global variables combine to provide information about limits on your system. Information about the important limits is logged in a Db2 for i supplied table named QSYS2.SYSLIMTBL. The QSYS2.SYSLIMITS view uses SYSLIMTBL and other Db2 resources to provide extended and formatted detail about these limits. You should generally work with the view rather than the underlying table. You can use Db2 for i provided global variables to control the number of rows kept for each type of limit in SYSLIMTBL.

The documentation for this capability is found here:

Alerting for System Limits
The IBM i operating system includes alerts for a subset of System Limits tracking. Once per day, IBM i will look for new occurrences where consumption of some limits exceeded 90% of the maximum allowable size. For these instances of extremely high consumption, messages will be sent to the QSYSOPR system operator message queue.
Limit ID Limit Description Maximum Alerting Level Alerting Cadence
15000 Maximum number of all rows in a partition 4,294,967,288
Greater than 90%
Once per day
15003 Maximum size of the data in a table partition 1,869,169,767,219
15104 Maximum number of variable-length segments 65,533
15400 Maximum *MAX4GB Index Size 4,294,967,296
15401 Maximum *MAX1TB Index Size 1,869,166,411,776
15403 Maximum Encoded Vector Index Size 2,199,023,255,552
19002 Maximum number of spooled files in the system and basic user ASPs 2,610,000

When collection services is recycled (typically just past midnight), a call is made to the QSYS2.Process_System_Limits_Alerts() procedure.
This procedure will look in the System Limits table for objects that have changed in the last 24 hours where the current resource consumption level is > 90% of the maximum.
For those instances, a single message will be sent to QSYSOPR for each object that has exceeded 90% of the maximum.

The message is a Severity 80 with message ID SQL7062.

The message will be sent if there are any rows within the QSYS2.SYSLIMTBL table which indicate that the file exceeded 90% consumption within the last 24 hours. The sole determinant factor for sending the message are the existence of rows within the QSYS2.SYSLIMTBL table with the criteria previously mentioned. The message is sent to raise awareness and enable proactive systems management.

The alerting level defaults to 90%, but clients can optionally customize the alerting level, via global variables within SYSIBMADM.

System limits alerting controls

Example alerting customization:

-- Alert on variable length segment consumption at 75% consumed
    DEFAULT  75;


The following is an example of the SQL7062 message being sent to QSYSOPR.



Alerts for some System Limits

Alerts for some System Limits

Alerts for some System Limits

Required PTF levels for Alert support

The Alert support for System Limits was established with the following Db2 PTF Group.

IBM i Operating System release Db2 PTF Group Enabling Level
IBM i 7.5 SF99950 1
IBM i 7.4 SF99704 1
IBM i 7.3 SF99703

(Level 15 - TR6 timed enhancements)

IBM i 7.2 SF99702 17
User-initiated alerts
System limits alerts, by default, are sent when Collection Services recycles, which is typically once per day just past midnight.
The QSYS2.PROCESS_SYSTEM_LIMITS_ALERTS() procedure can be called anytime that a client would like to have alerts processed for the previous 24 hours.
In other words, this procedure allows a client to establish a cadence more frequently than daily for important System Limits alerting.
See this IBM Documentation page for details: PROCESS_SYSTEM_LIMITS_ALERTS

Assistance with overcoming limits to growth

Reaching an IBM i architectural limit will cause an unscheduled and potentially debilitating application outage due to the database object being unavailable to accept additional data. Actively monitoring the current size and growth rate of database objects is obviously a best practice; and taking advantage of the alerts can be a real advantage. Traditionally, monitoring the database behavior is the responsibility of the "database engineer".
(see for more on the role of a DBE)

Upon receiving an alert, ideally, a high-priority project will be initiated. The main tasks of this project are:

  • Review and assess the current environment
  • Identify short-term and long-term trends for data growth
  • Obtain knowledge on possible methods and strategies to overcome limits to growth
  • Identify the appropriate solution to overcome limits to growth
  • Formulate a plan that will overcome the limits to growth

The IBM Systems Lab Services team has Db2 for i subject matter experts available to assist with all aspects of very large database, including overcoming limits to growth, and increasing scalability.

To learn more about engaging a Db2 for i subject matter expert, please contact:

Doug Mack
IBM Systems Lab Services

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"IBM i 7.4;IBM i 7.3;","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
10 October 2022