Monitoring on IBM iseries

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
RIDS_I2MP
Posts: 751
Joined: Thu Mar 13, 2014 9:25 am

Monitoring on IBM iseries

Post by RIDS_I2MP »

Hi Team,

We have a request to monitor IBM iSeries - V7R4M0 sytems.
Can you please let us know what all things are required. Like agent and configuration details.
Please attach document if available.

Thanks for the support .
Thanks & Regards,
I2MP Team.
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: Monitoring on IBM iseries

Post by benjaminsmith »

Hi,

IBM has created its own configuration wizard for Nagiso XI that is available, that would be the recommended method for setting this up.

You'll need to install Java on the XI server, and instructions are available on the wizard page.
Please open a terminal to the command line of your Nagios XI installation and install JAVA.
For CentOS/RHEL systems please run: yum install -y java-1.8.0-openjdk
For Debian-based systems please run: apt-get install -y default-jre
https://github.com/IBM/nagios-for-i/tre ... 20NagiosXI

For instructions on installing configuration wizards, please refer to the following guide.

Installing Configuration Wizards

As far as what it can and cannot do, the GitHub page is the best resource.

https://github.com/IBM/nagios-for-i

Hope that helps, let us know if you need further assistance.

--Benjamin
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
RIDS_I2MP
Posts: 751
Joined: Thu Mar 13, 2014 9:25 am

Re: Monitoring on IBM iseries

Post by RIDS_I2MP »

Hi Team,

We have completed installation part. Can you please let us know which agent needs to be installed and please provide document for enabling monitoring of host and services.

Thanks
Thanks & Regards,
I2MP Team.
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: Monitoring on IBM iseries

Post by benjaminsmith »

Hi,

The wizard connects to the IBM i system by logging in with an account. For more details on setting up this account on the support page on IBM's website, see item #4.

https://www.ibm.com/support/pages/node/1166188

We do not have an IBM i system, I would recommend reaching to the admin at your company for assistance. Once the account is set up for monitoring, it's very simple to run the wizard.

Let us know if you get it working.

--Benjamin
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
RIDS_I2MP
Posts: 751
Joined: Thu Mar 13, 2014 9:25 am

Re: Monitoring on IBM iseries

Post by RIDS_I2MP »

Hello Team,

We have tried to enable monitoring on IBM 1 servers. But only ping is working apart from that CPU, ASP and disk usage is not working and we are getting below error.

>>/bin/bash /usr/local/nagios/libexec/check_ibmi_status.sh -M CPU -H 10.147.223.25 -W 80 -C 90
Exception - com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL0204] SYSTEM_STATUS_INFO in QSYS2 type *FILE not found.
com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:945)
com.ibm.as400.access.JDError.throwSQLException(JDError.java:742)
com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1790)
com.ibm.as400.access.AS400JDBCStatement.executeQuery(AS400JDBCStatement.java:2517)
com.ibm.nagios.service.impl.CPU.execute(CPU.java:38)
com.ibm.nagios.RequestHandler.CollectStatus(RequestHandler.java:29)
com.ibm.nagios.RequestHandler.process(RequestHandler.java:16)
com.ibm.nagios.CheckIBMiStatus.run(CheckIBMiStatus.java:18)
com.ibm.nagios.ConnectToSystem.run(ConnectToSystem.java:65)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)
2021-09-20_144224.png
Can you please help us to resolve this.

Thanks in advance.
You do not have the required permissions to view the files attached to this post.
Thanks & Regards,
I2MP Team.
User avatar
jdunitz
Posts: 235
Joined: Wed Feb 05, 2020 2:50 pm

Re: Monitoring on IBM iseries

Post by jdunitz »

Could you show the output of this command?

/usr/local/nagios/libexec/check_ibmi_status.sh -M CPU -H ip-addr-of-your-i-system -W 11 -C 22

Thanks!

--Jeffrey
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
RIDS_I2MP
Posts: 751
Joined: Thu Mar 13, 2014 9:25 am

Re: Monitoring on IBM iseries

Post by RIDS_I2MP »

PFB O/P for the Command

>/usr/local/nagios/libexec/check_ibmi_status.sh -M CPU -H 10.147.223.25 -W 11 -C 22
Exception - com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL0204] SYSTEM_STATUS_INFO in QSYS2 type *FILE not found.
com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:945)
com.ibm.as400.access.JDError.throwSQLException(JDError.java:742)
com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1790)
com.ibm.as400.access.AS400JDBCStatement.executeQuery(AS400JDBCStatement.java:2517)
com.ibm.nagios.service.impl.CPU.execute(CPU.java:38)
com.ibm.nagios.RequestHandler.CollectStatus(RequestHandler.java:29)
com.ibm.nagios.RequestHandler.process(RequestHandler.java:16)
com.ibm.nagios.CheckIBMiStatus.run(CheckIBMiStatus.java:18)
com.ibm.nagios.ConnectToSystem.run(ConnectToSystem.java:65)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)
Thanks & Regards,
I2MP Team.
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: Monitoring on IBM iseries

Post by benjaminsmith »

Hi,

Okay, a few more questions, to help us troubleshoot. Unfortunately, we do not have access to an IBM i server to help troubleshoot.

1. Do you know what version you are running on the IBM side?

2. Let's make sure you have all the files installed on the Nagios XI side, please check for the following files in the /usr/local/nagios/libexec/ directory.
https://github.com/IBM/nagios-for-i/tree/master/libexec

3. Next please run the following command and post the output.

Code: Select all

bash -x /usr/local/nagios/libexec/check_ibmi_status.sh -M CPU -H 10.147.223.25 -W 11 -C 22
4. Lastly, on the following page, Nagios for i FAQs, make sure you have the privileges set.
https://www.ibm.com/support/pages/node/1285402/
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
RIDS_I2MP
Posts: 751
Joined: Thu Mar 13, 2014 9:25 am

Re: Monitoring on IBM iseries

Post by RIDS_I2MP »

1. OS Version V7R4M0 and V5R4M0

2.PFB attached screenshots. All rquired files are installed.
2021-09-25_144859.png
3. PFB Query O/P
[nagios@eu2napu002 libexec]$ bash -x /usr/local/nagios/libexec/check_ibmi_status.sh -M CPU -H 10.147.223.25 -W 11 -C 22
+ java -cp /usr/local/nagios/libexec/jt400.jar:/usr/local/nagios/libexec/nagios4i.jar com.ibm.nagios.client.CheckIBMiStatus -M CPU -H 10.147.223.25 -W 11 -C 22
Exception - com.ibm.as400.access.AS400JDBCSQLSyntaxErrorException: [SQL0204] SYSTEM_STATUS_INFO in QSYS2 type *FILE not found.
com.ibm.as400.access.JDError.createSQLExceptionSubClass(JDError.java:945)
com.ibm.as400.access.JDError.throwSQLException(JDError.java:742)
com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java:1790)
com.ibm.as400.access.AS400JDBCStatement.executeQuery(AS400JDBCStatement.java:2517)
com.ibm.nagios.service.impl.CPU.execute(CPU.java:38)
com.ibm.nagios.RequestHandler.CollectStatus(RequestHandler.java:29)
com.ibm.nagios.RequestHandler.process(RequestHandler.java:16)
com.ibm.nagios.CheckIBMiStatus.run(CheckIBMiStatus.java:18)
com.ibm.nagios.ConnectToSystem.run(ConnectToSystem.java:65)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
java.lang.Thread.run(Thread.java:748)
You have new mail in /var/spool/mail/nagios

4.We shall check if port are open or not.

Meanwhile can you can check.
You do not have the required permissions to view the files attached to this post.
Thanks & Regards,
I2MP Team.
benjaminsmith
Posts: 5324
Joined: Wed Aug 22, 2018 4:39 pm
Location: saint paul

Re: Monitoring on IBM iseries

Post by benjaminsmith »

Hi,

Are you the admin on this system? I believe the plugin is connecting to the machine and trying to read the following table for data.

https://www.ibm.com/docs/en/i/7.4?topic ... -info-view

However, either it's either not enabled or restricted and generating an error. Can you run the command locally on the bottom of that page and get valid data back?

--Benjamin
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.

Be sure to check out our Knowledgebase for helpful articles and solutions!
Locked