Adding a Global Geocoding Module Database Resource

Whenever you install a new database resource or modify an existing database resource you must define it in the Management Console in order for it to become available on your system. This procedure describes how to add or modify a Global Geocoding Module database resource.

Important: You can only define a single Global Geocoding Module database resource that contains all of the country datasets.
  1. If you haven't already done so, install the dataset files on your system. For instructions on installing databases, see the Spectrum™ Technology Platform Installation Guide.
  2. In Management Console, under Resources, choose Spectrum Databases.
  3. To create a new database resource, click the Add button . To make changes to an existing database resource, select it, then click the Edit button . To delete a database resource, select it, then click the Delete button .
    Note: You can copy a Global Geocoding database resource to use for another installed module; however, a copy of a database resource cannot be made for the Global Geocoding Module since it can only have one database resource.
  4. If you are creating a new database resource, on the Add Database page, enter a name for the database resource in the Name field.
  5. In the Pool size field, specify the maximum number of concurrent requests you want this database to handle.

    The optimal pool size varies by module. You will generally see the best results by setting the pool size between one-half to twice the number of CPUs on the server, with the optimal pool size for most modules being the same as the number of CPUs. For example, if your server has four CPUs you may want to experiment with a pool size between 2 (one-half the number of CPUs) and 8 (twice the number of CPUs) with the optimal size possibly being 4 (the number of CPUs).

    Tip: You should conduct performance tests with various settings to identify the optimal pool size and runtime instance settings for your environment.
  6. In the Module field, select GlobalGeocode. The Type field, Global Geocode Dataset, is selected by default.
  7. To add a dataset, under Data Source, click the Add button . In the Path field, specify the folder that contains the dataset files.You can type in a path or click the Browse button to locate the dataset you need, then click Ok.
  8. If you have additional datasets to add, click the Add button . To edit a dataset path, select the dataset, then click the Edit button . To remove a dataset, select the dataset, then click the Delete button .
  9. When you are done with your changes, click Save.
Note: If the database fails to configure due to insufficient resources, you may need to increase the Java Virtual Machine (JVM) initial heap size (Xms) and/or add the max heap size (Xmx) in the java.vmargs file. This file is located in the SpectrumDirectory\server\modules\GlobalGeocode folder, where SpectrumDirectory is your Spectrum installation directory.