Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

A driver to use on Ubuntu machine to connect to DB2 on z/Os?

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
mrm950

New User


Joined: 19 Nov 2014
Posts: 1
Location: USA

PostPosted: Wed Nov 19, 2014 11:06 pm    Post subject: A driver to use on Ubuntu machine to connect to DB2 on z/Os?
Reply with quote

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.

This is the code that we are currently using.

<?php
$database = 'Location';
$user = 'USERSIDS';
$password = 'PASSWRD';
$hostname = 'hostname of z/os';
$port = port;
$conn_string = "DRIVER={DB2};DATABASE=$database;" .
"HOSTNAME=$hostname;PORT=$port;PROTOCOL=TCPIP;UID=$user;PWD=$password;";
$conn = db2_connect($conn_string, '', '');
?>


Thank you for the help!
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Thu Nov 20, 2014 9:51 am    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Connect:Direct - RC=000000FF MSG=SVTM... R.Manivannan All Other Mainframe Topics 3 Fri Apr 21, 2017 1:30 am
No new posts DB2 CONNECT query mistah kurtz DB2 3 Fri Jul 15, 2016 6:37 pm
No new posts IP address of user's machine shreya19 TSO/ISPF 5 Wed Mar 16, 2016 3:24 pm
No new posts Connect Direct details shankarm IBM Tools 2 Sat Feb 20, 2016 7:25 pm
No new posts IMS DC to Connect MQ mfgopal IMS DB/DC 1 Tue Jan 05, 2016 3:30 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us