topic Re: UNABLE TO INSTALL ArcSDE 9.3 FOR DB2 9.1 in Data Management Questions https://community.esri.com/t5/data-management-questions/unable-to-install-arcsde-9-3-for-db2-9-1/m-p/550163#M31165 <HTML><HEAD></HEAD><BODY><SPAN>am sorry guys ....would like to correct my previous post.....i am actually using DB2 9.1 FP 1 and not DB2 9.1 FP 5........</SPAN></BODY></HTML> Wed, 05 May 2010 09:04:00 GMT LavanyaS 2010-05-05T09:04:00Z UNABLE TO INSTALL ArcSDE 9.3 FOR DB2 9.1 https://community.esri.com/t5/data-management-questions/unable-to-install-arcsde-9-3-for-db2-9-1/m-p/550162#M31164 <HTML><HEAD></HEAD><BODY><SPAN>Hey people,</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I tried to install ArcGIS 9.3 SDE on my Windows server 2003 Machine with DB2 9.1&nbsp; FP 5 (incl. DB2 SpatialEdition).Though i could finish the installation successfully&nbsp; i am unable to complete the&nbsp; Post Installation with the following steps.</SPAN><BR /><BR /><SPAN> step1:&nbsp; I chose to run the post installation using CUSTOM option and </SPAN><BR /><BR /><SPAN> step2:&nbsp;&nbsp; chose&nbsp; REPOSITORY SETUP,AUTHORIZE ARCSDE,CREATE ARCSDE SERVICE in the select ArcSDE setup&nbsp;&nbsp; wizard option and </SPAN><BR /><BR /><SPAN> step3: chose the default files in the ArcSDE configuration files setup window and </SPAN><BR /><BR /><SPAN> step4:&nbsp; entered the credentials.And the following error pops up..</SPAN><BR /><BR /><SPAN>ArcSDE Repository was unsuccessfully completed. Would you like to view status? and when i click yes i can see</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp; ESRI ArcSDE Server Setup Utility Thu Apr 29 15:24:25 2010</SPAN><BR /><SPAN>----------------------------------------------------------------</SPAN><BR /><SPAN>Creating ArcSde schema.....</SPAN><BR /><SPAN>Error: Underlying DBMS error (-51).</SPAN><BR /><SPAN>Error: SDE release install not completed. </SPAN><BR /><SPAN> Check SDEHOME\etc\sde_setup.log for more details.</SPAN><BR /><BR /><BR /><SPAN>An when&nbsp; i open the sde_setup.log file i can see the following.</SPAN><BR /><BR /><SPAN>[Thu Apr 29 15:24:25 2010] Instance initialized for sde . . .</SPAN><BR /><SPAN>[Thu Apr 29 15:24:25 2010] S_registration_scan: -204, 42S02</SPAN><BR /><SPAN>S_registration_scan: [IBM][CLI Driver][DB2/NT] SQL0204N&nbsp; "SDE.TABLE_REGISTRY" is an undefined name.&nbsp; SQLSTATE=42704</SPAN><BR /><BR /><BR /><SPAN>[Thu Apr 29 15:24:25 2010] ERROR installing/upgrading ArcSDE, Error = -51</SPAN><BR /><BR /><SPAN>After the Installtion and before the Post Installation I created a DB2 Database as described in the manual. </SPAN><BR /><BR /><SPAN>Can someone help me on this...</SPAN></BODY></HTML> Thu, 29 Apr 2010 09:07:27 GMT https://community.esri.com/t5/data-management-questions/unable-to-install-arcsde-9-3-for-db2-9-1/m-p/550162#M31164 LavanyaS 2010-04-29T09:07:27Z Re: UNABLE TO INSTALL ArcSDE 9.3 FOR DB2 9.1 https://community.esri.com/t5/data-management-questions/unable-to-install-arcsde-9-3-for-db2-9-1/m-p/550163#M31165 <HTML><HEAD></HEAD><BODY><SPAN>am sorry guys ....would like to correct my previous post.....i am actually using DB2 9.1 FP 1 and not DB2 9.1 FP 5........</SPAN></BODY></HTML> Wed, 05 May 2010 09:04:00 GMT https://community.esri.com/t5/data-management-questions/unable-to-install-arcsde-9-3-for-db2-9-1/m-p/550163#M31165 LavanyaS 2010-05-05T09:04:00Z Re: UNABLE TO INSTALL ArcSDE 9.3 FOR DB2 9.1 https://community.esri.com/t5/data-management-questions/unable-to-install-arcsde-9-3-for-db2-9-1/m-p/550164#M31166 <HTML><HEAD></HEAD><BODY><SPAN>You can delete the tables under the SDE schema. In my case there is only one table (SDE.VERSION).</SPAN></BODY></HTML> Tue, 30 Nov 2010 12:29:36 GMT https://community.esri.com/t5/data-management-questions/unable-to-install-arcsde-9-3-for-db2-9-1/m-p/550164#M31166 yangxiao 2010-11-30T12:29:36Z