Select to view content in your preferred language

ArcGIS 10.1 and PostgreSQL, DB2

1019
1
Jump to solution
08-14-2013 11:46 AM
HollyZhang1
Occasional Contributor
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,
0 Kudos
1 Solution

Accepted Solutions
AsrujitSengupta
Deactivated User
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,

View solution in original post

0 Kudos
1 Reply
AsrujitSengupta
Deactivated User
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,
0 Kudos