Hello everyone! I am a student working as part of a university group and we are trying to connect our Ubuntu machine to z/OS DB2.
We currently have a script that currently uses php ibm_db2 functions to connect to DB2 Express C on an Ubuntu 14.04 server. When we try to translate that same script to remotely connect to a database on DB2 z/OS, we recieve this error, "[IBM][CLI Driver] SQL1598N An attempt to connect to the database server failed because of a licensing problem. SQLSTATE=42968 SQLCODE=-1598". We did some research and came across this site, http://www-01.ibm.com/support/docview.wss?uid=swg21305417, which describes that the driver used by the ibm_db2 functions cannot conntact the database because of non-matching drivers and licences. How do we go about finding a driver and license to install on our Ubuntu machine to connect to DB2 on z/Os? If we are not going about this in the right way, are there any alternative methods we can use? We are open to suggestions.
Joined: 22 Apr 2006 Posts: 6258 Location: Mumbai, India
Do you've DB2 Connect installed on Ubuntu machine? The DB2 CLI/ODBC driver cannot connect directly to a DB2 z/OS database. You need to install and configure the product called DB2 Connect that serves as a gateway.