From Windows-NodeJS: How to read/write DB2i?

[Bob hserus]

Hi  Bimal Kumar,

While talking Kevin M. Adler(Your Rochester/USA team member), he said you would be able to help me. Here is my need. I want my Windows2012Server-NodeJS to read/write data from/to DB2i in a remote OS/400 server. What is the right/efficient way. I am thinking as follows. 

- Installing DB2 Connect in Windows2012Server? If yes, could you guide me on what build ID# that I should download from IBM internal software download site. I was looking for "DB2Connect Client". Couldn't find any. I found "IBM DB2 Connect Server 9.7 for Windows® on AMD64 and Intel® EM64T systems (x64) Multilingual (CZ19TML )". Is this the right one.  Please advise.

[bimaljha]

Correct link to download db2 client drivers is : http://www-01.ibm.com/support/docview.wss?uid=swg27007053

node ibm_db driver works with all client drivers but most preferred is "IBM Data Server Driver Package" due its less size.

However to use ibm_db driver, you need not to install separate db2 client driver in your system. ibm_db get installed with adbc/cli driver for connectivity. you just need to copy db2connect license under ibm_db/installer/clidriver/license folder as documented here: https://github.com/ibmdb/node-ibm_db

Thanks and Regards,

Bimal Jha

[Bob hserus]

Thank you Bimal. Appreciated.