English

How To: Install and setup ArcSDE and DB2 on separate servers

Summary

Instructions provided describe how to install and setup ArcSDE and DB2 on separate servers. If ArcSDE is installed on a different server than the DB2 database management system (DBMS), the ArcSDE server must be set up as a client machine to the DB2 database, and specific library and .bnd files must be copied from the ArcSDE server to the DB2 server.

Procedure

The DB2 client must be installed on the server where ArcSDE is installed, and certain files must be copied from the SDEHOME to the DB2 INSTANCEHOME directory on the DB2 server.

Note:
If ArcSDE and DB2 are installed on different operating systems (OS), be sure the copied libraries and .bnd files are for the OS on which DB2 is installed. For example, if ArcSDE is installed on a Windows server and DB2 is installed on a Linux server, the copied files must be for Linux. These files can be obtained in two ways.

a. By temporarily installing ArcSDE on the DB2 Linux server and deleting everything in the SDEHOME\bin and SDEHOME\lib directories except sdesrvfn, sdesrvsp, sdesrvfn.bnd, and sdesrvsp.bnd (as mentioned in Steps 1-8 below).

Or, if DB2 is installed on a UNIX or Linux box:

b. By untarring the appropriate ArcSDE installation files and using ftp to copy the files to their respective directories on the DB2 server.


  1. Install the DB2 Administration or Application Development client on the server on which ArcSDE is installed.
  2. Using the Configuration Assistant, test to make sure the DB2 client on the ArcSDE server can connect to the DB2 database on the other server.
  3. Copy/paste (Windows) or FTP (UNIX) a copy of the sdesrvfn library from the SDEHOME lib directory (UNIX/Linux) or bin folder (Windows) on the ArcSDE server and place it in the DB2INSTANCEHOME\sqllib\function directory.
  4. Copy/paste (Windows) or FTP (UNIX) a copy of the sdesrvsp library from the SDEHOME lib directory (UNIX/Linux) or bin folder (Windows) on the ArcSDE server and place it in the DB2INSTANCEHOME\sqllib\function\unfenced directory.
  5. Copy/paste (Windows) or FTP (UNIX) a copy of the sdesrvfn.bnd file from the SDEHOME lib directory on the ArcSDE server and place it in the DB2INSTANCEHOME\sqllib\function directory.
  6. Copy/paste (Windows) or FTP (UNIX) a copy of the sdesrvsp.bnd file from the SDEHOME lib directory on the ArcSDE server and place it in the DB2INSTANCEHOME\sqllib\function\unfenced directory.
  7. On the machine where ArcSDE is installed, set the SDE_DATABASE environment variable in the SDEHOME\etc\dbinit.sde file to the remote DB2 database. The value should be the name of the database that refers to the remote database configured in the DB2 client setup in Step 2 above. For example, add an entry similar to the following:
    Code:
    set SDE_DATABASE=sdedb2

  8. Complete the ArcSDE Post Installation setup from the ArcSDE server.