Adding a Database Resource - 23.1

spectrum-inline

Product type
Software
Portfolio
Integrate
Enrich
Locate
Verify
Product family
Spectrum™ software
Product
Spectrum™ software > Quality > Addressing
Spectrum™ software > Geo Addressing > Enterprise Tax
Spectrum™ software > Quality > Context Graph
Spectrum™ software > Spatial > Spectrum Spatial
Spectrum™ software > Discovery
Spectrum™ software > Data Integration
Spectrum™ software > Dataflow Designer
Spectrum™ software > Spectrum™ Platform
Spectrum™ software > Web Services
Spectrum™ software > GeoEnrichment
Spectrum™ software > Quality > Spectrum Quality
Version
23.1
ft:locale
en-US
Product name
Precisely Spectrum
ft:title
spectrum-inline
First publish date
2007
ft:lastEdition
2023-06-02
ft:lastPublication
2023-06-02T09:54:39.526000

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.

  1. 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.
  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.
  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 GeoEnrichmentLookup. The Type field, GeoEnrichmentLookup, is selected by default.
  7. To add a database file, under Data Source, click the Add button. In the Dataset Name field, specify a unique name. In the Dataset Path field, specify the full path and database file name, for example: D:/gem/usa_databases/apen_elevation/apn_elevation.h2.db. You can type in the full path with file name or or click the Browse button to locate the file you need, then click Ok.
  8. If you have additional database files to add, click the Add button. To edit a database path, select the database, then click the Edit button. To remove a database, select the database, then click the Delete button.
  9. When you are done with your changes, click Save.