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 on the Esri Supported Environment Policy.
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
IBM Db2 Version 11.1 Mod 4 Fix Pack 5
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 packs/patches 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 (64 bit) | The minimum required service packs/patches is Fix Pack 0. |
Db2 Spatial Extender is included in the Db2 database product media. | |
You cannot enable a geodatabase in V11.5, Mod 9 due to Db2 issue DT245904. | |
IBM Db2 V11.1 (64 bit) | The minimum required service packs/patches is Mod 4 Fix Pack 5. |
Db2 Spatial Extender is included in the Db2 database product media. | |
This is the last ArcGIS release to support this version of Db2. |
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 on support for database services and databases deployed in the cloud.
Software required to connect to a DBMS
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.