connect to DB2 server from a DB2 client

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 ?
LVL 1
LeTayAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ghp7000Commented:
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
issue:
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


0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB2

From novice to tech pro — start learning today.

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.