connect to DB2 server from a DB2 client

Posted on 2004-11-10
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

    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


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
    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…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now