ArcGIS Pro and ArcGIS Enterprise on Linux and Microsoft Windows support connections to IBM Db2 databases and enterprise geodatabases in Db2.
Visit Esri Technical Support for information about the Esri Supported Environment Policy.
The information below applies to ArcGIS Enterprise 12.0 and ArcGIS Pro 3.6.
Supported database versions
The following IBM Db2 releases and fix pack versions are the minimum certified and supported with ArcGIS. Unless noted otherwise, newer fix pack versions on these versions are supported but not certified.
IBM Db2 Version 12.1
IBM Db2 Version 11.5.9 Fix Pack 0 Cumulative Special Build 58840
Database requirements and limitations
Be aware of the following limitations when using Db2 with ArcGIS:
- Db2 databases must be configured to use UTF-8 encoding.
- When you use a database connection file (.sde) to access Db2 data in ArcGIS Pro, you can only edit data that is registered with the geodatabase. To edit database data, publish an editable web feature layer that references the database data and edit through the web feature layer.
- Db2 is not supported with ArcGIS Enterprise on Kubernetes.
- Requirements and limitations that apply to specific versions of Db2 are listed in the following table:
| Db2 version | Requirements and limitations |
|---|---|
IBM Db2 V12.1 (64 bit) | Minimum required service pack/patch is Fix Pack 0. |
Db2 Spatial Extender is included in the Db2 database product media. | |
Changes in the privilege model introduced with this release of Db2 require changes to the privileges you must grant to the sde user when the database contains an enterprise geodatabase. | |
IBM Db2 V11.5.9 (64 bit) | The minimum required service pack/patch is Fix Pack 0 Cumulative Special Build 58840. |
Db2 Spatial Extender is included in the Db2 database product media. |
Supported operating systems
- If your database management system is installed on a server where ArcGIS products are installed, the server operating system must meet the ArcGIS product system requirements as well as the operating system requirements for your Db2 version.
- If your database is not installed on the same server as an ArcGIS product, see the IBM documentation for operating system requirements for your Db2 version.
ArcGIS is tested and certified on Db2 Enterprise Server Edition. Other versions of Db2, such as Db2 Workgroup Server Edition and Db2 Personal Edition, share a common code base and are supported as long as they meet the ArcGIS Server requirements.
Cloud support
See Requirements for using ArcGIS with databases in the cloud for information about support for database services and databases deployed in the cloud.
Software required to connect to Db2
Your client machine (for example, the one running ArcGIS Pro or ArcGIS Server) must have the appropriate database client files installed for the RDBMS you are using. These client files are available from their respective RDBMS vendors. See Database clients for more information.
You can download a copy of the IBM Data Server Runtime Client for Db2 from My Esri.