Whenever you install a new database resource or modify an existing database resource you must
define it in Management Console in order for it to become available on your system.
This procedure describes how to add or modify a database resource for the Enterprise
Geocoding Module for Australia.
To create a Geocode Address AUS database resource:
-
If you haven't already done so, install the database files on your system. For
instructions on installing databases, see the Spectrumâ„¢ Technology Platform Installation Guide.
-
In Management Console, under Resources, choose
Spectrum Databases.
-
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 .
-
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 are 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.
-
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).
-
In the Module field, select International Geocode
Australia.
-
In the Type field, select Geocode Address Global.
If you had extracted your .SPD files and placed them in the
\server\app\dataimport folder, Spectrum would automatically
add them to the \repository\datastorage folder. You will
see a list of datasets in the Add Database screen.
-
Select the dataset(s) you want to add to the database as a resource. Use the
Filter text box to search for a dataset when you have a long list.
-
Save the database.
- If there are any open Enterprise Designer sessions, click the refresh button to see the new stage.