Connecting Esri ArcGIS for Desktop to Db2

You can connect Esri ArcGIS for Desktop version 10.3.1 to Db2® and then use it to analyze and visualize geospatial data.

Before you begin

Before you can connect to your database, you must carry out the following steps:

Verify prerequisites, including installing driver packages, configuring your local environment, and downloading SSL certificates (if needed)
Collect connect information, including database details such as host name and port numbers, and connect credentials such as user ID and password

You must have the Db2 driver package or the IBM Data Server Driver Package installed on your computer.

Determine your ODBC DSN data from the database details and connect credentials that you collected beforehand.
Create a new connection:
1. In the ArcCatalog Catalog tree, open the Database Connections node and click Add Database Connection.
2. In the Database Connections wizard:
  1. Select DB2 from the Database Platform drop-down list.
  2. Enter the following string in the Data source field:
```
HostName=<hostname>;Port=<port>;Database=<database>;
CLIENTBUFFERSUNBOUNDLOBS=1;LOBCACHESIZE=50000000;
FET_BUF_SIZE=256K  
```
    where <hostname>, <port>, and <database> are placeholders that represent the host name, port number, and database name you noted earlier.
  3. Select Database authentication as the authentication type.
  4. Specify your user name and password (the user ID and password you noted earlier) in the corresponding fields.
  5. Press OK.

The ArcCatalog component of Esri ArcGIS for Desktop is now connected to your Db2 Warehouse database.