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

  • IBM i 7.2: Finding the job that is killing your systemIBM i 7.2: Finding the job that is killing your system
  • The 2018 State of ResilienceThe 2018 State of Resilience
  • Vector Networks’ new Vizor shines light on Shadow ITVector Networks’ new Vizor shines light on Shadow IT
  • Proximity strengthens IBM i development portfolio by partnering with Remain SoftwareProximity strengthens IBM i development portfolio by partnering with Remain Software
  • Lock System ValuesLock System Values
  • Reclaim DB Cross-Reference (RCLDBXREF)Reclaim DB Cross-Reference (RCLDBXREF)

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

IBM Power Systems Enhances Hybrid Cloud Capabilities with Red Hat

New pre-configured private cloud platform, innovative cloud-consumption payment model, and more Red Hat … [Read More...]

Remain Software Milestone

NIEUWEGEIN, Netherlands — Remain Software released today the second Milestone of TD/OMS V13, Gravity V6, … [Read More...]

Version 4 of the well-known “Flash for i” product: to enhance the usage of External Storage with IBM i

Available for 5 years, installed in more than 200 LPARs in 12 countries, you certainly already know the ‘Flash … [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

Log in

This site uses cookies More info