English

Bug: ArcCatalog feature class properties show a spatial index exists on an ArcSDE feature class that is in load-only I/O mode

Description

A feature class stored in an ArcSDE geodatabase is placed in load-only I/O mode and the spatial index is dropped when one of the following operations is performed:

▪ The spatial index is deleted from within the Indexes tab of the Feature Class Properties dialog box in ArcCatalog.

or

▪ The sdelayer -o load_only_io command is run against the feature class.

If a seperate connection is made to the geodatabase from ArcCatalog after the feature class has been placed in load-only I/O mode, the Indexes tab of the Feature Class Properties dialog box shows the feature class still has a spatial index even though the spatial index was dropped.

Cause

This is a known issue. It has been fixed in ArcGIS 9.3.1 Service Pack 1 and 10.

Workaround

To be sure a feature class is in load-only I/O mode and that the spatial index has been deleted, run the sdelayer -o describe_long command.

From a command prompt, execute sdelayer with the describe_long operation.

The following example requests a description of a feature class named streets:

Code:
sdelayer -o describe_long -O dbo -l streets,shape -i sde_prod -s beaufort -D prod


This returns a list of properties describing the feature class. Check the values for the Spatial Index property 'exist' and the property 'I/O Mode'; the values should be 'No' and 'LOAD' respectively.

The properties returned for the streets feature class are as follows:

Layer    Administration Utility
-----------------------------------------------------
Layer Description ....: <None>
Database : PROD
Table Owner ..........: DBO
Table Name ...........: STREETS
Spatial Column .......: SHAPE
Layer Id .............: 241
SRID .................: 53
Minimum Shape Id .....: 1
Offset ...............:
falsex: -119670466.771485
falsey: -95612605.493381
System Units .........: 31999999.970198
Z Offset..............: 0.000000
Z Units ..............: 1.000000
Measure Offset .......: <None>
Measure Units ........: <None>
XY Cluster Tolerance .: 0.000256
Spatial Index ........:
parameter: SPIDX_GRID,GRID0=1200,FULL
exist: No
array form: 1200,0,0
Layer Envelope .......:
minx: 1837251.62494, miny: 763253.12502
maxx: 1856706.00013, maxy: 776741.56253
Entities .............: nslc+
Layer Type ...........: SDE
Creation Date ........: 11/20/06 08:50:51
I/O Mode .............: LOAD
Autolocking ..........: Enabled
Precision.............: High
User Privileges ......: SELECT, UPDATE, INSERT, DELETE
Coordinate System ....: PROJCS["NAD_1983_StatePlane_Ohio_South_FIPS_3402_Feet",G
EOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980
",6378137.0,298.257222101]],PRIMEM["Greenwich",0.0],UNIT["Degree",0.017453292519
9433]],PROJECTION["Lambert_Conformal_Conic"],PARAMETER["False_Easting",1968500.0
],PARAMETER["False_Northing",0.0],PARAMETER["Central_Meridian",-82.5],PARAMETER[
"Standard_Parallel_1",38.73333333333333],PARAMETER["Standard_Parallel_2",40.0333
3333333333],PARAMETER["Latitude_Of_Origin",38.0],UNIT["Foot_US",0.30480060960121
92]]



Note:
For more information on using the sdelayer command, consult the ArcSDE administration command reference.

Related Information