Adding a Routing Database Resource

  1. In Management Console, go to Resources > Spectrum Databases.
  2. Click the Add button to create a new database or select an existing database resource then click the Edit button to change it. You can also create a new database resource by copying an existing one, by clicking the Copy button .
  3. If you are creating a new database, enter a name for the database resource in the Name field. The name can be anything you choose. If you creating a new database by copying an existing one, rename the default name as needed. You cannot modify the name of an existing database resource, because any services or jobs that reference the database resource by its original name would fail.
  4. Change the Pool Size value if needed, by specifying the maximum number of concurrent requests you want this database to handle.
    Note: This setting represents the number of threads on the components that are listening for service requests from the Spectrumâ„¢ Technology Platform or executing a Location Intelligence Module stage (that is, the maximum number of managed connections). Every web service request enters Spectrum from the platform and is passed to the components. The default value of 4 can be increased to accommodate greater request loads. A pool size that matches the number of CPUs is recommended. The maximum setting should not go above twice the number of the CPU core; for example, on a 4 CPU machine the combined number of threads for all services should not exceed 8. Performance tests should be run with various settings until optimal performance is achieved for the usage.
  5. In the Module field, select Spatial.
  6. In the Type field, select Enterprise Routing.
  7. In the Path field, click the Add button to select the full path to the database file. The database files can be found in: <InstallLocation>\ERM-<CountryCode>\<Vintage>\<Type>\<Country> where <InstallLocation> is the directory you specified when you installed the database files, <CountryCode> is the two-letter country code, <Vintage> is the date of the data (for example, 2009.1), <Type> is driving or pedestrian, and <Country> is the name of the country.
  8. Click Save.
The database resource now appears in the list of available database resources for Find Nearest, Get Travel Boundary, Get Travel Cost Matrix, and Get Travel Directions.