Using Management Console to Create a Database Resource

To create a Spectrum Universal Address database resource in Management Console from a newly installed SPD file:

  1. Open Management Console.
  2. Go to Resources > Spectrum Databases.
    If you do not see the Spectrum Databases menu, then you do not need to define database resources.
  3. You can use the buttons at the top left to manage your databases.

    To create a new database, click Add .

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

  4. 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 resource by copying an existing database resource, rename as needed. You cannot modify the name of an existing database resource.
  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 Spectrum Universal Address stage that is configured to use one runtime instance. If you set the pool size for the Spectrum Universal Address 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 Spectrum Universal Address stage to four, you might then see an improvement in performance since there would be four instances of the Spectrum Universal Address 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 Min memory (MB) field, specify the minimum amount of memory allocated for this database resource.
  7. In the Max memory (MB) field, specify the maximum amount of memory allocated for this database resource.
  8. In the Module field, select Spectrum Universal Address .
  9. In the Type field, select the type of data.
    1. Select the Canada Address Coders database for Canada address processing.
    2. Select the International Address Coders database for International address processing.
    3. Select the US Address Coders database for United States (USA) address processing.
  10. For Canada Address Coders, in the *Canada: field, select the base database vintage.
  11. For International Address Coders, in the *International: field, select the base database vintage.
  12. For US Address Coders, in the *US: field, select the base database vintage.
  13. For US Address Coders, specify the database vintage for the following optional databases you use for processing.
    • Delivery Point Validation (DPV)
    • LACSLink
    • SuiteLink
    • Residential Delivery Indicator (RDI)
    • Early Warning System (EWS)
  14. To override advanced settings such as additional command line arguments when starting processing, properties, and environmental variables for remote processing, select Override advanced settings.
  15. Click Save to add and save the database resource. The Spectrum Databases page displays the added database resource.