Download DB2 Version 8 Connectivity Cheat Sheet

Download DB2 Version 8 Connectivity Cheat Sheet

The purpose of this article is to provide quick and easy instructions for setting up connectivity between IBM ® DB2 ® Universal Database TM for Linux, UNIX ® and Windows ® V8 clients and DB2 servers using DB2 commands. The DB2 servers can be -- for this article -- DB2 UDB for Linux, UNIX and Windows version 8, DB2 UDB for z/OS TM version 8 or DB2 for iSeries ® 5.2. Note that though we are using the latest versions of DB2 UDB in the different platforms, the same instructions can apply to other DB2 UDB versions.
In case you've followed all the instructions and the connection isn't working, I've included some things to check to help you determine what the problem is as well as typical error messages.
The Configuration Assistant (CA) GUI tool, formerly known as the Client Configuration Assistant (CCA), can be used on either Windows or UNIX platforms as an easy graphical interface for establishing connectivity. However, if you know the actual DB2 commands that are executed under the covers by the CA Tool, you will have a better understanding of what is required when connecting DB2 clients to DB2 servers. Moreover, the commands can always be saved in a script that can be easily distributed to any DB2 client that requires the same connectivity setup. For completeness, however, I will include the steps to follow using the Configuration Assistant in the last section of this article.
The tables below show the steps for setting up connectivity using the DB2 Command Line Processor (CLP). Only "basic" command options will be shown. With DB2 Version 8, TCPIP is the only protocol supported. If you'd like to print off a slimmed down version of these charts to keep handy at your desk, go to the download section at the end of the article.
We'll examine five common scenarios where DB2 UDB for Linux, UNIX and Windows is always the client. For the scenarios where DB2 UDB for Linux, UNIX and Windows is the server (other than scenario 1), stay tuned for Part 2 of this article.

Download