**CMK version: 2.1.0p21
**OS version: Debian 5.10.197
**Error message:
Error while connecting to database: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: “TCP/IP”. Communication API being used: “SOCKETS”. Location where the error was detected: “<>”. Communication function detecting the error: “connect”. Protocol specific error code(s): “111”, “", "”. SQLSTATE=08001 SQLCODE=-30081
Hello,
since i am finally migrating from Checkmk Version 1.6.0p27 to 2.1.0p21 i have a problem to monitor the db2 database on our ibmi systems.
In our old Checkmk Version (1.6.0p27) which i took over from an old colleague there was a plugin named check_db2oni.
This plugin was for doing some db2 sql querys.
In the new version there is a check named check_sql (Check SQL Database)
Theoretically i can query sql against db2 with this but if i do this with our ibmi db2 i get the following message:
Error while connecting to database: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "<<HOST IP>>". Communication function detecting the error: "connect". Protocol specific error code(s): "111", "*", "*". SQLSTATE=08001 SQLCODE=-30081
IBM says:
The root cause is outside of Db2, which might be in the client/server network stack or network device that is situated between them.
But it’s the same ip network as the old checkmk system and there are no destrictions between ibmi and checkmk.
The Check Command is:
check_mk_active-sql!–pwstore=5@11@iseries ‘–hostname=<>’ ‘–dbms=db2’ ‘–name=$HOSTNAME$’ ‘–user=<>’ ‘–password=<>’ ‘–port=25000’ ‘SELECT DEC (100 - DEC(TOTAL_CAPACITY_AVAILABLE, 19, 2) / DEC(TOTAL_CAPACITY, 19, 2) * 100, 19, 2) AS AVAILABLE_SPACE, ‘"’"’“'”‘"’“'”‘"’<>‘"’“'”‘"’“'”‘"’“’ AS DESCRIPTION, CONCAT(DEC (100 - DEC(TOTAL_CAPACITY_AVAILABLE, 19, 2) / DEC(TOTAL_CAPACITY, 19, 2) * 100, 19, 2),'”‘"’“'”‘"’“'”‘"’\;85\;90’“'”‘"’“'”‘"’“'”‘) AS PERFDATA FROM qsys2.asp_info WHERE ASP_NUMBER=1\n’
Is anyone out there who is able to query db2 on ibmi with checkmk?
unfortunatly i’m stuck.