Inquiry on Occasional Null Values from AS400 Using Nagios XI IBMi Plugin

[kuroyuki48]

Hi,

I would like to inquire about monitoring AS400 servers using the Nagios XI IBMi plugin. Is it common to occasionally receive null values from AS400? I’m asking because, although the IBMi plugin generally works well, I sometimes receive null values from AS400, which trigger alerts.

[williamlea1]

Hi,

Which services are you using?

[kuroyuki48]

Hi,

Which services are you using?

Hi @williamlea1, I primarily use CustomSQL to perform polling from QSYS.

[williamlea1]

Hi Kuroyuki48,

I would suggest that its the custom you are running occasionally produces output the warning and critical it doesn't like. Its more than likely something like that than anything else.

[kuroyuki48]

Hi @williamlea1 I tried logging the messages returned from AS400, but it still occasionally shows a null value.

[williamlea1]

Hi,

Whats the SQL you are running?

[kuroyuki48]

The statement I run looks similar to the one below. I am able to run this query without any issues; however, from time to time, I receive null values from AS400:
Select * QSYS2.Message_queue M Where M.Message_Queue_Lib = 'Qsys'.