Select to view content in your preferred language

UNABLE TO INSTALL ArcSDE 9.3 FOR DB2 9.1

868
2
04-29-2010 02:07 AM
LavanyaS
New Contributor
Hey people,
      
       I tried to install ArcGIS 9.3 SDE on my Windows server 2003 Machine with DB2 9.1  FP 5 (incl. DB2 SpatialEdition).Though i could finish the installation successfully  i am unable to complete the  Post Installation with the following steps.

step1:  I chose to run the post installation using CUSTOM option and

step2:   chose  REPOSITORY SETUP,AUTHORIZE ARCSDE,CREATE ARCSDE SERVICE in the select ArcSDE setup   wizard option and

step3: chose the default files in the ArcSDE configuration files setup window and

step4:  entered the credentials.And the following error pops up..

ArcSDE Repository was unsuccessfully completed. Would you like to view status? and when i click yes i can see

    ESRI ArcSDE Server Setup Utility Thu Apr 29 15:24:25 2010
----------------------------------------------------------------
Creating ArcSde schema.....
Error: Underlying DBMS error (-51).
Error: SDE release install not completed.
Check SDEHOME\etc\sde_setup.log for more details.


An when  i open the sde_setup.log file i can see the following.

[Thu Apr 29 15:24:25 2010] Instance initialized for sde . . .
[Thu Apr 29 15:24:25 2010] S_registration_scan: -204, 42S02
S_registration_scan: [IBM][CLI Driver][DB2/NT] SQL0204N  "SDE.TABLE_REGISTRY" is an undefined name.  SQLSTATE=42704


[Thu Apr 29 15:24:25 2010] ERROR installing/upgrading ArcSDE, Error = -51

After the Installtion and before the Post Installation I created a DB2 Database as described in the manual.

Can someone help me on this...
0 Kudos
2 Replies
LavanyaS
New Contributor
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........
0 Kudos
yangxiao
New Contributor
You can delete the tables under the SDE schema. In my case there is only one table (SDE.VERSION).
0 Kudos