Adding, Modifying, or Deleting a Global Addressing 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 database resource for the Global Addressing Module.

To create a Global Addressing Module database resource:

  1. If you have not already done so, install the database files on your system. For instructions on installing databases, see the section "Installing Global Addressing Module Databases".
  2. In Management Console, under Resources, choose Spectrum Databases.
  3. You can use the buttons at the top left to manage your databases:

    To create a new database, click Add .

    To change an existing database, select the database and then click Edit .

    To delete a database, select the database and then click Delete .

    To create a new database by copying an existing database, click Copy .

  4. If you are creating a new database, on the Add Database page, enter a name for the database resource in the Name field. 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.
  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).

    When modifying the pool size you must also consider the number of runtime instances specified in the dataflow for the stages accessing the database. Consider for example a dataflow that has a Global Address Validation stage that is configured to use one runtime instance. If you set the pool size for the Global Address Validation database to four, you will not see a performance improvement because there would be only one runtime instance and therefore there would only be one request at a time to the database. However, if you were to increase the number of runtime instances of the Global Address Validation stage to four, you might then see an improvement in performance since there would be four instances of the Global Address Validation stage accessing the database simultaneously, therefore using the full pool. For more information about setting runtime instances, see the Spectrumâ„¢ Technology Administration Guide.

    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 Global Address Validation Coder.
  7. In the Type field, select Global Addressing.
  8. To select all Global Addressing databases and all countries within those databases, click Include at the top of the list of available databases. To select only specific individual databases and all countries within those individual databases, click Include next to the individual databases.
    Tip: To see the countries included in an individual database, click the arrow to the left of a database. You can also click Include at this level to include only specific countries in an individual database.
    Note: We recommend grouping countries into regional Database Resources. For example, group the APAC countries into one Database Resource and the EMEA countries into another Database Resource. Attempting to add all countries for the Global Addressing Validation stage and the Global Type Ahead stage into just one Database Resource may cause the Database Resource creation process to time out and fail to create the Database Resource.
  9. Click Save to add and save the selected databases. The Spectrumâ„¢ Databases page displays the added or modified databases.