IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

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


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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, 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

Superior Member


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

PostPosted: Thu Nov 20, 2014 9:51 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Connect Direct 6.3 for Z/OS All Other Mainframe Topics 20
No new posts Getting TWA in CICS program while con... CICS 14
No new posts Getting an abend (I/O abend was trapp... ABENDS & Debugging 3
No new posts Unable to connect FTP over TLS from z... All Other Mainframe Topics 5
No new posts Connect:Direct Add yesterday date in ... All Other Mainframe Topics 3
Search our Forums:

Back to Top