Secure connection

[Dan Krissell]

Hi all, I can't find any examples of how to make a secure connection to db2, nor any mention of it in the code. Without it I can't use this in a enterprise environment.

Is there support for this? 

Thank you, Dan Krissell

[bimaljha]

Hi Dan,

Yes, ibm_db supports secure connection to DB2 over SSL same as ODBC/CLI driver. If you have SSL Certificate from server or an CA signed certificate, just use it in connection string as below:

ibmdb.open("DRIVER={DB2};DATABASE=<dbname>;HOSTNAME=<myhost>;UID=db2user;PWD=password;PORT=<dbport>;PROTOCOL=TCPIP;Security=SSL;SSLServerCertificate=<cert.arm file path>", function(...

Thanks and Regards,

Bimal Jha

[Dan Krissell]

Thank you Bimal, I was able to get it working.