ArcGIS 10.1 and PostgreSQL, DB2

HollyZhang1 — Wed, 14 Aug 2013 18:46:49 GMT

I am trying to store our GIS data to a DBMS (DB2 or PostgreSQL). Currently, we are running a DB2 for iSeries database for non spatial data. And I had PostgreSQL experience. I have the following three questions:

1. PostgreSQL 9.1.3 is required for ArcGIS 10.1. Is it OK to use PostgreSQL 9.1.9 version for ArcGIS 10.1?

2. IBM DB2 Version 9.7 Fix Pack 4 (64-bit) is required for ArcGIS 10.1. There are 2 different applications in the IBM world: Windows DB2 and iSeries DB2, following different version numbering, and different development paths. IBM DB2 Version 9.7 Fix Pack 4 (64-bit) is a Windows DB2 version. What ArcGIS 10.1 requires for iSeries DB2 Version?

3. Must ArcSDE be installed to set up a geodatabase in DB2 from ArcGIS 10.1 desktop? There are three types of DBMS (Oracle, PostgreSQL and SQL Server) in the Create Enterprise Geodatabase geoprocessing tool to select. How about creating enterprise geodatabase in DB2?

Thanks,

Re: ArcGIS 10.1 and PostgreSQL, DB2

AsrujitSengupta — Wed, 14 Aug 2013 20:02:28 GMT

Holly,

Answer 1: Yes, that is supported. As the base version of PostgreSQL 9.1.3 is a supported Database version, PostgreSQL 9.1.9 will also be supported.
http://support.esri.com/en/content/supportedenvironmentpolicy

Answer 2: To the best of my knowledge, I don't think ArcSDE is supported with DB2 iSeries. If you have a DB2 iSeries, you may be able to make an OLEDB connection to this database to access tables, however again, ArcSDE is not supported on this database platform.

Answer 3: The below link should answer this question--
Enabling geodatabase functionality in a DB2 database:
http://resources.arcgis.com/en/help/main/10.1/index.html#//0029000000sn000000

Regards,

topic Re: ArcGIS 10.1 and PostgreSQL, DB2 in Data Management Questions

ArcGIS 10.1 and PostgreSQL, DB2

Re: ArcGIS 10.1 and PostgreSQL, DB2