Licence issue

[Jan Vitez]

 Good day,

i trying to user ibm_db on win7 on IBM cloud  but getting this error :
[IBM][CLI Driver] SQL1598N  An attempt to connect to the database server failed because of a licensing problem.  SQLSTATE=42968  SQLCODE=-1598.

there is no licence file on server. ibm_db is working without any issue on my workstation but on the server i'm getting the error above. Tried to reinstall, change odbc setting etc.
I need info how exactly ibm_db is connecting to DB (remote one, not local). Is it odbc or something else.

Thank you!

[Saba Kauser]

Hello,

Is the database server connected to is same in success and failure case or is it different?
In ibm_db case success case, there must be a client side license present under clidriver\license.
For failure case, you can add a valid license at the server using 'db2licm -a <license filename>' command.

[Saba Kauser]

Hello,

Is the database server connected to is same in success and failure case or is it different?
In ibm_db case success case, there must be a client side license present under clidriver\license.
For failure case, you can add a valid license at the server using 'db2licm -a <license filename>' command.

On Monday, September 28, 2015 at 2:20:32 PM UTC+5:30, Jan Vitez wrote:

[Austin Barrington]

Hello,

I am facing the same problem connecting to a Z OS instances of DB2. I have downloaded the IBM DB2 Cli but it does not come with db2licm in the adm directory. I have also tried this with the IBM 10.1 Client and still no hope. I can connect using the db2 command to the remote database but through python it is not using the license installed or maybe I have not referanced the db2 libs properly.

What I have tried:

(DB2 Client)

export IBM_DB_HOME:/opt/ibm/V10.1/

pip install ibm_db

Successfully connects to remote via command line but not through python

(DB2 clidriver)

extract ibm_data_server_driver_for_odbc_cli_linuxx64_v10.5.tar.gz

extract include.tar into that

export IBM_DB_HOME:/opt/clidriver/

pip install ibm_db

the db2lic command is missing in adm folder.

Any idea as to what I should check next?

[roopa.ra...@in.ibm.com]

HI ,

db2licm will not be present for ibm_data_server_driver_odbc_cli driver under adm folder

To  connect a DB2 for z/OS server using IBM client drivers you need to buy db2connect license from IBM. License is not part of drivers. It is *.lic file that you need to copy under clidriver/license folder. You can get more information from this link

https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.qb.server.doc/doc/r0006748.html?lang=en

Thanks
Roopa

On Monday, September 28, 2015 at 2:20:32 PM UTC+5:30, Jan Vitez wrote: