Hello, I have to monitor IBM DB2 database.
So I understand that I have to use ADO SQL sensor (https://helpdesk.paessler.com/en/support/solutions/articles/76000063187-how-to-set-up-the-sql-v2-sensors-in-prtg-is-there-a-guide).
When adding the sensor, I have to fill Connection string, but don't really know how, or what syntax to follow. Could you please give the syntax for PRTG ?
Is ODBC the good method for IBM DB2 ? If yes, do I have to install DB2 client as well on the PRTG probe ?
Thank you for your support.

Article Comments

Hi there,

Did you already checked the manual where the syntax is noted? https://www.paessler.com/manuals/prtg/ado_sql_v2_sensor


Apr, 2022 - Permalink

Hello Moritz, Yes, I've checked this page, and I can find this example : 

Provider=SQLOLEDB.1;Data Source=10.0.0.200\SQLEXPRESS;User ID=user;Password=userpass;Initial Catalog=Northwind
For ODBC connections, you must enter MSDASQL as provider, for example Provider=MSDASQL;DSN=_my_odbc_sqlserver.

To create the string, I have to know how to enter the server's IP, the tcp port etc ... There should be a tutorial somewhere with all the parm and values for this string.

Thanks.


Apr, 2022 - Permalink

Hi there,

I'm sorry but I don't get at which point you have an issue here. IP and Port are defined in the credentials in the device settings: https://www.paessler.com/manuals/prtg/device_settings#dbcredentials


Apr, 2022 - Permalink

Hi Moritz,

I finally found a string that works :-) 

Provider=IBMDADB2;Database=xxx;Hostname=yyy;Protocol=TCPIP; Port=zzz;Uid=uuu;Pwd=pw;

--> I have first use IBMDBDB2, and not MSDASQL.

--> If I define IP and Port in th Setting tab, I can remove it in the Connection string.

The tutorial I'm searching is about : what parmameters + meaning we can code in this string, not only IP and tcp.

The credentials put on Setting Tab for the devices are valid for all the databases on this device. If we want un other user, then the syntaxe in the string is: Uid=uuu;Pwd=pw

Thank you for your support.
Regards.


Apr, 2022 - Permalink

Hi there,

Thank you for the information. I'm glad you could find the correct connection string for your case.


Apr, 2022 - Permalink