PowerWire.eu

Independent IBM i, AIX and Linux news and tech tips for Europe and beyond

  • Home
  • News
  • Technical Articles
    • IBM i
    • AIX
    • Linux
    • VIOS
  • Subscribe
  • About Us
  • Contact Us
  • Advertise with PowerWire.eu

A Screen a Story – The system limit is the limit.

May 5, 2020 by Rudi van Helvoirt Leave a Comment


IBM i is evolving and so is the work around IBM i. Most shops no longer have someone who is constantIy monitoring IBM i. Monitoring has been automated, be it by using the tools available in Navigator for i, watches or tools like Nagios and any other ISV tool, which may or may not use SNMP. Monitoring QSYSOPR is important for keeping track of the health of IBM i. Not so long ago, IBM enhanced the functionality behind the System Limits table. In IBM i  7.3 Technology Refresh 6 added a DB2 for i Database Management Enhancement called “System Limits – QSYSOPR warning uses a new message – SQL7062. Below a link in which the details can be found for this enhancement:

https://www.ibm.com/support/pages/alerts-ibm-i-system-limits Below an image of the message in QSYSOPR:

In short this new functionality, will check once a day if the system limits table is reaching the alerting level specified in the table below:

If the Alerting Level is exceeded the message with the details will appear in QSYSOPR. So instead of having to check this table yourself running SQL just monitoring QSYSOPR will do. Below an example of a Navigator for i Message Monitor, which will pickup the message from QSYSOPR and turn it into an email:

So now you know that looking out for SQL7062 can be worthwhile and by automating it, it can keep you away from harm. One thing is for sure whenever you reach the limits of the system you want to be alerted beforehand.

Related Posts

  • 2017 Common Europe Congress (CEC)2017 Common Europe Congress (CEC)
  • German i developer improves cross-platform testing German i developer improves cross-platform testing
  • Removing the storage bottleneckRemoving the storage bottleneck
  • New and improved: Three big updates from Halcyon, looksoftware gives COBOL folk an IDE, SEQUEL adds pivot tablesNew and improved: Three big updates from Halcyon, looksoftware gives COBOL folk an IDE, SEQUEL adds pivot tables
  • Shield Advance becomes Remains Software newest partnerShield Advance becomes Remains Software newest partner
  • Events: APSU holds three big Power8 launch eventsEvents: APSU holds three big Power8 launch events

Filed Under: IBM i, Technical Articles

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Free monthly newsletter signup

News

Seiden Group Announces Free Access to
CommunityPlus+ PHP for IBM i

— Enhanced PHP RPMs come with optional setup & support services — Ho-Ho-Kus, NJ, January 6, 2021 … [Read More...]

ARCAD releases Azure DevOps integration for all-in-one CI/CD automation on IBM i

New ARCAD for DevOps release enables rapid automation of IBM i application build and deploy within any … [Read More...]

Cloud Walkers bring new tools to IBM i administrators

Cloud Walkers s.r.o is a new company that has been set up by Bartlomiej Grabowski who is an IBM Champion, … [Read More...]

More articles from this section

Quick Links

  • Advertise
  • Subscribe

Follow Us…

  • Email
  • LinkedIn
  • Twitter

Search This Website

Copyright © 2021 · Cue Communications · All Rights Reserved · RED NOISE MEDIA

Copyright © 2021 · Magazine Pro Theme on Genesis Framework · WordPress · Log in

This site uses cookies More info