Dear All,
I'm using odbc to connect with DB2 databases. Connection itself is working fine, I can fetch data from database. Problem is when I'm adding new connection. After modification of /etc/odbc.ini end db2dsdriver.cfg, isql is working fine I can connect to db and make queries. Problem is this connection is not working form Zabbix itself. When I'm testing items I'm getting this error:
"Cannont connect to ODBC DSN: [SQL_ERROR]:[][-1531][[unixODBC][IBM][CLI Driver] SQL1531N The connection failed because the name specified with the DSN connetcion string keyword c]"
Solution for this is simple but problematic, it's enough to restart zabbix server. Config cache reload is not enough :/ Did you notice similar issue? Maybe for other databases? Restarting Zabbix every time when I'm adding new connection is not quite good solution... Maybe is there some way to restart ODBC poolers only?
I'm using odbc to connect with DB2 databases. Connection itself is working fine, I can fetch data from database. Problem is when I'm adding new connection. After modification of /etc/odbc.ini end db2dsdriver.cfg, isql is working fine I can connect to db and make queries. Problem is this connection is not working form Zabbix itself. When I'm testing items I'm getting this error:
"Cannont connect to ODBC DSN: [SQL_ERROR]:[][-1531][[unixODBC][IBM][CLI Driver] SQL1531N The connection failed because the name specified with the DSN connetcion string keyword c]"
Solution for this is simple but problematic, it's enough to restart zabbix server. Config cache reload is not enough :/ Did you notice similar issue? Maybe for other databases? Restarting Zabbix every time when I'm adding new connection is not quite good solution... Maybe is there some way to restart ODBC poolers only?