DB2 Tips

Do you want to access a remote DB2 database from your local DB2 client? This is a very common requirement and this short blog article describes the necessary steps to achieve this.

Gather remote system connection details

The following information are needed.

1. Remote hostname
2. Remote database name
3. Remote Db2 Port

For step 3, please see my earlier blog article.


Catalog the remote system

In our example, let us assume the remote hostname is itm61db2, the database name is warehous and remote db2 port is 50000.

Bring up the DB2 Command Line Processor and issue the following command.


catalog tcpip node itm61nod remote itm61db2 server 50000


The node name that you enter, (itm61nod) should be 8 characters or less. Remember you need to do this step only once per system. For example, if you had already cataloged the system and want to catalog the second database on the same database server, you can skip this step.


Catalog the remote database

Continuing the above example, to catalog the warehous database running on the itm61db2 node, please enter the following command.


catalog database warehous as itm61tdw at node itm61nod


That's it. Now if you bring up Db2 Control Center, you will see the newly catalog database. You can browse the tables and other database objects after authenticating yourself.