Starting spatiotemporal indexing

You start spatiotemporal indexing by running the STS_SubtrackCreate function for the time series column.

Before you begin

The TimeSeries, Spatial, and R-tree index extensions must be registered in the database.

A time series table must exist.

Procedure

To start spatiotemporal indexing:
  1. Prepare storage spaces for your spatiotemporal data.
  2. Optional: If you are using multiple CPU virtual processors, set the PRELOAD_DLL_FILE configuration parameter to the path for the spatiotemporal shared library file in the onconfig file and then restart the database server:
    PRELOAD_DLL_FILE $INFORMIXDIR/extend/sts.version/sts.bld 
    The version is the version number of the spatiotemporal search extension.
  3. Optional: Set default parameters for configuring spatiotemporal data and storage by running the STS_SetDefaultParameters function.
  4. Run the STS_SubtrackCreate function for the time series.
    A subtrack table and spatiotemporal search system tables are created. If you configured Scheduler tasks, the subtrack table is populated and indexed.
  5. If you did not configure a Scheduler task with the STS_SubtrackCreate function, run the STS_SubtrackBuild function to populate the subtrack table and index the initial set of data.