Autoregistering DB2 spatial tables with ArcSDE

Autoregistration is functionality that allows ArcSDE to automatically search the DB2 system tables for new tables with spatial columns whenever an ArcSDE client lists the feature classes stored in the database. When a new spatial table is discovered, it is registered with ArcSDE and made available to applications.

ArcSDE uses the first record in a newly discovered table to establish the ArcSDE geometry type. If the table contains multiple geometry types, you can use the sdelayer administration command with the -e option to alter the geometry type definition.

ArcSDE searches for a column in the table to use as a row ID column. To qualify, the column must be defined as INTEGER, NOT NULL, and UNIQUE constraints. If such a column is found, the name of the column is recorded in the ArcSDE TABLE_REGISTRY system table along with the table name. If a qualifying row ID column is not found, the table is registered, but operations requiring a row ID are unavailable.

  1. Autoregistration is controlled by the SERVER_CONFIG parameter DISABLEAUTOREG, which is set to TRUE by default. That means autoregistration is disabled. To turn on autoregistration, use the sdeconfig command with the alter operation to change the value of the DISABLEAUTOREG parameter.

    sdeconfig -o alter -v DISABLEAUTOREG=FALSE 
    -i sde:db2 -s myserver -D mydb -u sde -p verbotten 


    For information on using ArcSDE commands, consult the command reference provided with the ArcSDE component of ArcGIS Server Enterprise.

Related Topics