connect to DB2 server from a DB2 client

Posted on 2004-11-10
Medium Priority
Last Modified: 2008-03-06
I have installed IBM DB2 (8.1) on a server (Windows 2000 server)
I create a database and issued some SQL script to create a few tables
Then I installed the DB2 client on my own PC (Windows 2000 workstation)
I now have the most stupid question : how do I define a connection to that DB and then for example use the db2 command line ?
Question by:LeTay
1 Comment
LVL 13

Accepted Solution

ghp7000 earned 2000 total points
ID: 12551574
make sure the client software is at least the same version level as the db software (8.1 in your case)
once the client software is installed, all you have to do is catalog the node and the database on the client side:
to catalog the node:
launch the db2 command line processor on client machine from start menu
db2 catalog tcpip node db2node remote myserver server 50000
in the above example, the communication type is tcpip
the node name is db2node (u can use any name you want up to 12 characters)
myserver is the machine name that is hosting the database
50000 means that the machine hosting the database is listening for connections on port 50000, this is the default setup when you installed the database

now that you have the node setup, you catalog the database(s) that reside on that node:
db2 catalog database <database name) at node db2node
repeat for each database that the server is hosting and for which you want  to connect to

this is basic setup for client server connectivity


Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

850 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