I spent a morning prompting my way thru a Google Gemini session, generating a zabbix 7.4 template with discovery via item, trigger and graph prototypes.
The items being solicited were also pulled from Gemini, prompting for key health and performance metrics that are accessible by SQL.
ODBC DSN, username, password, and a CSV list of databases (schemas?) are the four macros.
DB2CLI and DSDriver from 11.1 (my youngest target server) was installed on the Zabbix host and proxy.
/etc/odbc.ini and /opt/ibm/dsdriver/cfg/db2cli.ini have the ODBC DSN. The macro username exists on the target Linux DB2 servers as a normal (/sbin/nologin) user which is a member of the dbmonitor OS group.
I have a single DSN for one schema on a given server, the others in the CSV macro are accessible via the named schema (queries to the other schemas are not fenced by the connection named in the ODBC DSN.)
One of the discovered items is the HADR state. I'm not doing anything with it currently, as I'm trying to figure out how to disable polling of values on the HADR "Standby" hosts, polling only the HADR "Active" (or HADR null?) host.
Note that this is VERY young - my DBAs haven't even blessed the queries and metrics being polled. I figured there's enough unanswered requests for DB2 templates, this can be a beginning for the rest of the community.
The items being solicited were also pulled from Gemini, prompting for key health and performance metrics that are accessible by SQL.
ODBC DSN, username, password, and a CSV list of databases (schemas?) are the four macros.
DB2CLI and DSDriver from 11.1 (my youngest target server) was installed on the Zabbix host and proxy.
/etc/odbc.ini and /opt/ibm/dsdriver/cfg/db2cli.ini have the ODBC DSN. The macro username exists on the target Linux DB2 servers as a normal (/sbin/nologin) user which is a member of the dbmonitor OS group.
I have a single DSN for one schema on a given server, the others in the CSV macro are accessible via the named schema (queries to the other schemas are not fenced by the connection named in the ODBC DSN.)
One of the discovered items is the HADR state. I'm not doing anything with it currently, as I'm trying to figure out how to disable polling of values on the HADR "Standby" hosts, polling only the HADR "Active" (or HADR null?) host.
Note that this is VERY young - my DBAs haven't even blessed the queries and metrics being polled. I figured there's enough unanswered requests for DB2 templates, this can be a beginning for the rest of the community.