I’m honored to once again be named an IBM Champion, for 2023! It’s a privilege to be associated with such an amazing group of talented and dedicated people! #IBMChampion#IBMi@COMMONug#LISUG
topic in the IBM i Knowledge Center for the full list of tracked limits.
For each limit that is tracked, you will find an identifier as well as the maximum allowed value for that particular limit. The floor is the level at which IBM i starts to track that limit, and the increment is how much the usage must change (either increase or decrease) for an entry to be tracked in the QSYS2.SYSLIMTBL table.
Automatically tracking the limits is great, but knowing when a limit is getting near the maximum is essential for the health of your system as well as administrative peace of mind. IBM supports automatic alerting on a subset of the system limits. This automatic alerting is in the form of a message, SQL7062 that is sent to QSYSOPR. By default, the system processes the alerts when Collection Services is cycled, which is typically midnight for most systems.
However, alerting once a day is insufficient if you are dealing with limits approaching their maximum on an ongoing basis. I am working with a client that has such an issue with a large table. This client submitted an idea for more a customizable alerting cadence to IBM. I’m happy to report that IBM delivered this enhancement in the Db2 Group PTF this past December; level 3 for 7.5 and level 23 for 7.4.
This new capability is the QSYS2.PROCESS_SYSTEM_ALERTS procedure. This allows you to call this procedure when you want the system to check for limits that have exceeded their alerting threshold; for example, you could schedule this to be called hourly.
You can also customize the alerting level for a subset of the system limits. IBM documents the default alerting level as well as global variables that can be defined to change the percentage at which the alert is issued. These are documented on the System Limits Alerts page.
Finally, not all limits have alerting in place. For many limits, you must manually check on them or use something like the Adminsitration Runtime Expert SQL Query Verifier to schedule checks where you can query the limit and assess a percentage.
Refer to these previous i Can posts for additional information on system limits:
The only thing worse than training your employees and having them leave is not training them and having them stay. Henry Ford
Dear Manager,
As you know, I am always striving towards more efficiency and tries to do things smarter to make our business even more successful. Therefore I would like to get permission to go to XYZ Conference (Why not Common Europe Congress) in the month of XYZ (Say June 2023).
At this conference I will have the best chances to meet real experts in my field. Learn from them, hear about how other companies are using the latest technologies to solve issues we are still struggling with. People at these conferences are the best in sharing their own experiences and warning for pitfalls to avoid for us to save time and money. This is of course difficult to make a return of investment on, but as you know, experts like them charge 150 – 200 Euro/USD per hour normally.
There will be vendors of very good solutions attending the conference as sponsors as well. We are using tools from Company A + Company B + Company C already today, I will talk to them of course but also visit the expo area to find out if there are other tools or solutions we should consider using.
Panel discussion from Common Europe Congress 2022
I’ve went through the draft conference agenda, and here is a list of sessions I will attend for sure If I get there:
The latest trends and directions from Vendor XYZ
“Cloud this and cloud that”
How to optimise the investment we’ve already made in technology XYZ
XYZ
You can count on me making a presentation to show at the next group meeting when I am back home again. In this presentation I will go through the best findings from the conference and also give some inspiration to my colleagues. The whole team will grow stronger because of this.
Example of content from Common Europe Congress 2022
Besides all the benefit our company gains from this educational event. I will grow as a person, get new insights and probably make some new friends, some of them for life even. After all, to not let us educate ourselves about the technologies we are already using, is similar to buying a truck without giving people the driving license for it.
The total investment from you would be:
Admission XX Euro/USD (If booking before Date XYZ)
