Enabling geodatabase functionality in a DB2 database

This topic applies to ArcGIS for Desktop Standard and ArcGIS for Desktop Advanced only.

You can connect from ArcGIS for Desktop as a geodatabase administrator to an existing IBM DB2 database and create a geodatabase in it.

You would enable geodatabase functionality if you decide you such things as topologies, networks, versioned editing, archiving, or replication in your DB2 database.

The following are the steps you take to enable geodatabase functionality in a DB2 database using the Enable Enterprise Geodatabase tool, which can be accessed from a database connection in the Catalog tree:

  1. Create an operating system user named sde, which will connect to the database to enable geodatabase functionality.
  2. Grant the sde user DBADM authority in the database and ensure that sde is a member of an operating system group that has SYSMON authority.
  3. Start ArcMap or ArcCatalog.
  4. Create a database connection to the DB2 database from the Catalog tree, connecting as the sde user.

    Be sure to save the user's password on the Database Connection dialog box.


    You cannot use a DSNless connection when enabling geodatabase functionality or upgrading a geodatabase.

  5. Right-click the database connection and click Enable Geodatabase.

    The Enable Enterprise Geodatabase tool opens.

  6. Add the database connection file for your DB2 database to the Input Database text box.
  7. Browse to the ArcGIS for Server authorization file that was created when you authorized ArcGIS for Server, and add it to the Authorization File text box.

    When you use the wizard to authorize ArcGIS for Server, a keycodes file is written to the server where the software is installed. If you authorized ArcGIS for Server on a Linux box, the file was created in /arcgis/server/framework/runtime/.wine/drive_c/Program Files/ESRI/License<release>/sysgen. If you authorized on a Windows server, the file was created in Program Files\ESRI\License<release>\sysgen. If you have not already done so, authorize ArcGIS for Server to create this file.

  8. Click OK to run the tool.

A geodatabase is created in the database.

A log file for the geodatabase creation (GDBCreateGeodatabase<#>.log) is written to the directory specified for your %TEMP% variable on the computer where the tool is run. If you have any problems running the tool, check this log file to troubleshoot the problem.