Setting up a connection to DB2

This information applies to clients of IBM DB2 for Linux, UNIX, Windows, and z/OS.

You must install the DB2 client software on the machine where the ArcGIS client is installed. Follow the instructions provided with the DB2 client software to install it.

Note:

You must install a DB2 9.7 or higher release client on the client computers to connect directly from ArcGIS 10.1 or 10.2 to a supported DB2 version. The DB2 9.7 client must be used even if you are connecting to an earlier release of DB2.

After you install the client software, you can catalog a database, thereby seting up a data source name, or connect from ArcGIS to your database without setting up a data source name.

If your ArcGIS client is installed on a Linux machine that is separate from the DB2 server, you must create a DB2 client instance on the client machine before you can catalog the DB2 instance.

If you do not set up a data source name, you must provide a string at the time of connection that contains all the information the client needs to connect to your database. The string is in the format HostName=<DB2 host>;Port=<port number>;Database=<database name>.