Connecting to DB2 to publish to a spatial data server

To connect to an IBM DB2 database from ArcGIS for Desktop to create a map and publish data to a spatial data server, you must install the IBM Data Server Run-time Client for DB2 9.7 on the machine where you have ArcGIS for Desktop installed. Then create a connection to the database using a DSN-less connection string.

You can get the IBM Data Server Run-time Client for DB2 from IBM.

Steps:

1. Follow IBM's instructions for installing IBM Data Server Run-time Client for DB2 9.7.
2. If you revoked CONNECT privileges from Public in the database, you must grant CONNECT privileges on the database to the user you want to use for your database connection.
3. Start ArcCatalog or start ArcMap and open the Catalog window.
4. Expand the Database Connection node and double-click Add Database Connection.
5. Choose DB2 from the Database Platform drop-down list.
6. Type the following information in the Datasource text box: HostName=<host>;Port=<port number>;Database=<database name>.

   For example, if you are connecting to a DB2 database, geo, on server flux communicating through port 42000, you would type HostName=flux;Port=42000;Database=geo.

7. Use database authentication to connect, and type the user name and password of the connecting user in the appropriate text boxes.

   Be sure to leave Save user name and password checked.

8. Click OK to make the connection.

A new database connection is listed under the Database Connections node.