search

ibmdb / node-ibm_db

IBM DB2 and IBM Informix bindings for node
MIT License
188 stars 151 forks source link

z/os connections #854

Closed betogm08 closed 2 years ago

betogm08 commented 2 years ago

Hello!

I would like to know how to configure a z/OS connection. Can you help? What I need to consider?

bimalkjha commented 2 years ago

@betogm08 If you know the database name, hostname, port number, userid and password for your z/OS database, you can connect to it using ibm_db driver by specifying these values in connection string as shown in this example. You can copy and run the example code to test it. Thanks.

betogm08 commented 2 years ago

Hi @bimalkjha thanks you for your response!

I did the test and what I got is the following error: An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968

Do you know what it means?

bimalkjha commented 2 years ago

@betogm08 Yes, to connect a z/OS system using ibm_db driver from Linux, Unix, Windows or MacOS, you need a db2connect license file. Please see the detailed documentation about it here: https://github.com/ibmdb/node-ibm_db#sql1598n Thanks.