ArcGIS Server Banner

Updating geodatabase statistics in DB2 databases

Updating geodatabase statistics in DB2 databases

Release 9.3 E-mail This TopicPrintable VersionGive Us feedback
Note:This topic was updated for 9.3.1.

DB2 provides the RUNSTATS statement to allow you to update the statistics on a particular table.

If you decide to update the statistics of all or some of the feature class tables with the DB2 RUNSTATS statement, use the following syntax:

RUNSTATS ON TABLE <table_name> WITH DISTRIBUTION AND DETAILED INDEXES ALL

You can also update the statistics for every table in a designated schema with the UPDATE STATISTICS command, as shown in the example below:

db2 REORGCHK UPDATE STATISTICS ON SCHEMA SDE

In this example, the SDE schema name is specified. This will update the statistics on all the ArcSDE system tables, which are stored in the SDE user's schema.

For more information on the DB2 SQL RUNSTATS and UPDATE STATISTICS statements, refer to the IBM DB2 Universal Database Command Reference.

See Also

  • About updating geodatabase statistics