IBM DB2 database requirements for ArcGIS 10.1

Visit Esri Support for general support information on Esri's Supported Environment Policy as well as information on earlier versions.

Supported database versions

IBM DB2 Version 9.7 Fix Pack 4 (64-bit)

IBM DB2 Version 9 for z/OS

Click here for DB2 fix pack Support

Supported operating systems

Database

Supported Operating Systems

Minimum OS Version

Maximum OS Version

IBM DB2 Version 9.7 Fix Pack 4 (64-bit)

Click here for DB2 fix pack Support

IBM AIX 6.1.0.0 (64-bit)

IBM AIX 7.1.0.0 (64-bit)

Red Hat Enterprise Linux Server 5 (64-bit)*

Update 7

Red Hat Enterprise Linux Server 6 (64-bit)*

Sun Solaris 10 (64-bit (SPARC))

SUSE Linux Enterprise Server 11 (64-bit)*

SP1

Windows Server 2003 Standard, Enterprise, and Datacenter (64-bit [EM64T])*

SP2

SP2

Windows Server 2008 Standard, Enterprise, and Datacenter (64-bit [EM64T])*

SP2

SP2

Windows 7 Enterprise (64-bit (EM64T))

SP1

SP1

IBM DB2 Version 9 for z/OS

z/OS 1.12

Database requirements/limitations

IBM DB2 V9.7 for Linux, UNIX, and Windows (64-bit)

  • Minimum required service packs/patches: Fix Pack 4
  • Recommended service packs/patches: n/a
  • Required add-ons: IBM Spatial Extender Version 9.7 Fix Pack 4

IBM DB2 V9 for z/OS

  • Feature services are not supported with a DB2 z/OS database
  • Any geoprocessing operation that writes information to the database requires the generation of unique ObjectID values. Manipulating identity columns on z/OS is limited; therefore, any tool that writes data to the database is not supported with a DB2 z/OS database
  • Required service packs/patches: APAR PM24155
  • Required add-ons: IBM Spatial Support for DB2 for z/OS—DB2 Accessories Suite

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 ArcSDE requirements listed above. For more information on the distributed editions of DB2, refer to the articles listed below.

NoteNote:

*Enterprise ArcSDE for DB2 technology is now available as a 64-bit runtime environment. This operating system is supported beginning at ArcGIS 10.0. ArcSDE XML column support is enabled by the Text Search Extender Product. Refer to IBM documentation to properly configure Text Search.

DB2 database fix pack support

Operating system limitations

Software required to connect to a DBMS

Your client machine (for example, the one running ArcMap) will need to have the appropriate client files installed for the RDBMS you are using. These client files are available from their respective RDBMS vendors, but they are also available on Esri Customer Care Portal as a convenience. Please see Database clients for more information. RDBMS client files available from the customer care portal are IBM DB2, IBM Informix, Microsoft SQL Server, Microsoft Windows Azure SQL Database, and PostgreSQL. Client files for IBM Netezza, Oracle and Teradata are not available on the customer care portal and must be obtained from the IBM, Oracle and Teradata support sites.

6/22/2016