Zabbix agent emulator for as400 system

[sancho]

Hi Kos,

Amazing! Thank you very much.

The new options open up a lot of possibilities.

The Alpha version has been working very well for me so far. I'll let you know how this beta version and the new features perform once I've had more time to test them.

As always, congratulations on your excellent work.

[j.k.]

Hi KOS, I have tried new version and have some problems with my select.
I have this item:

With this key:
as400.sql.select["SELECT count(*) FROM QSYS2.JOB_QUEUE_INFO WHERE ACTIVE_JOBS IS NOT NULL and SUBSYSTEM_NAME = 'SLASCH'"]

But result in Zabbix is this error: as400.ZbxException: java.sql.SQLException: [SQL0666] SQL query exceeds specified limit or threshold.

From the log: 25:20260715:094854.715 Starting Zabbix Agent v0.8.0-beta3
25:20260715:094854.725 using configuration file: /home/ZABBIX/agentd/zabbix_agentd.conf
25:20260715:094854.725 IBM Corporation Java version "1.8.0_401"
25:20260715:094854.726 Java(TM) SE Runtime Environment (build 8.0.8.20 - pap3280sr8fp20-20240112_01(SR8 FP20))
25:20260715:094854.726 IBM J9 VM (build 2.9, JRE 1.8.0 OS/400 ppc-32-Bit 20231219_62619 (JIT enabled, AOT enabled)
OpenJ9 - 08d2144
OMR - 7a5005b
IBM - 7394519)
25:20260715:094854.765 Open Source Software, JTOpen 11.2 codebase 5770-SS1 V7R5M0.00 built=20230219 @AI9
25:20260715:094857.153 Agent hostname: 'BDAT01', System info: IBM OS/400 BDAT01 V7R3M0, IBM Corporation IBM J9 VM (v1.8.0_401)
30:20260715:094857.230 agent #1 started [collector]
31:20260715:094857.258 agent #2 (172.16.108.37) started [active checks #3]
32:20260715:094857.274 agent #3 started[listener #1]
34:20260715:094857.281 agent #4 started[listener #2]
35:20260715:094857.286 agent #5 started[listener #3]
31:20260715:094902.166 As400Metric.process(as400.sql.select["SELECT count(*) FROM QSYS2.JOB_QUEUE_INFO WHERE ACTIVE_JOBS IS NOT NULL and SUBSYSTEM_NAME = 'SLASCH'"]) error: java.sql.SQLException: [SQL0666] SQL query exceeds specified limit or threshold.

But the limit is *nomax

Thansk in advance for any response.