Remote access with Perl running on Solaris to an IBM DB2 database on Linux

Posted on 2006-11-15
Medium Priority
Last Modified: 2013-12-05

We have a Perl 5.6.1 script that is running on Sun Solaris 9. We need it to connect to and run a query on a table in an IBM DB2 V8.2 database which is installed on a Suse Linux 9 computer. What is the best way to accomplish this? Will we need a bridging tool due to the different operating systems on the servers?

Thank you.
Question by:TAI-
LVL 37

Accepted Solution

momi_sabag earned 750 total points
ID: 17954097

first of all you will need to install a db2 client on the solaris machine,
you can download a free client from the ibm web site
you can use the run time client which is the minimal client in terms of demand on machine resources

once you have installed the db2 run time client (or any other client) you need to catalog the remote database (the one on the linux machine) localy on the solaris
in order to do so you need to use 2 commands
catalog tcpip node - this will define the communication path to the linux server
catalog db - this will define a local alias on the solaris machine to the udb database that resides on the linux machine

now you can access the database as if it is local to the solaris machine

in order to run the query localy, you can just use the commands :
db2 connect to <db-name> user <user-name> using <password>
db2 select ... <rest of your query>
and just grab the output from stdout


Expert Comment

ID: 17955317
This will help: Perl programming with DB2 Universal Database


Author Comment

ID: 17977427
Hmm. It seems I have to somehow combine the two replies.

The document in the IBM link doesn't seem to explain how to remotely access the database over different OS.

And momi's commands don't seem to be Perl commands.

Maybe if I install DB2 client and catalog, then use the Perl DBI commands it might work.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Installing FreeBSD… FreeBSD is a darling of an operating system. The stability and usability make it a clear choice for servers and desktops (for the cunning). Savvy?  The Ports collection makes available every popular FOSS application and packag…
I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question