PROBLEM

Unable to alter the spatial index grid sizes of a DB2 feature class in load-only I/O mode

Last Published: April 25, 2020

Description

When a feature class in a DB2 geodatabase is in load-only I/O mode, altering the spatial index grid cell values using the sdelayer -o alter command or the SE_layer_alter C-API function does not change the grid cell values.

Cause

This is a known limitation of using sdelayer -o alter or SE_layer_alter on a DB2 feature class that is in load-only I/O mode.

Solution or Workaround

Either place the feature class in normal I/O mode before altering the spatial grid cell size using sdelayer -o alter or the SE_layer_alter function, or edit the grid cell sizes in ArcCatalog.

For information on editing a feature class' grid cell sizes in ArcCatalog, see the Desktop Help topic: Setting spatial indexes.

    Article ID: 000009090

    Software:
    • Legacy Products

    Receive notifications and find solutions for new or common issues

    Get summarized answers and video solutions from our new AI chatbot.

    Download the Esri Support App

    Discover more on this topic

    Esri Community

    Search for related information

    Training

    Find training related to this topic

    ArcGIS Ideas

    Explore ideas and give feedback

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options