Configuring database properties

Spectrum Technology Platform can access data that resides in remote/connected databases, bringing the data into memory for processing. The Spectrum Management Console Add Database window provides a UI-based method for configuring databases

Configure database connections

  1. Access Spectrum Management Console using the URL http://server:port/managementconsole, where server is the server name or IP address, and port is the HTTP or HTTPS port used by Spectrum Technology Platform.
    The default port is 8080.
  2. Go to Resources > Spectrum Databases.
  3. Go to Resources > Spectrum Databases.
  4. Click the Add database button to display the Add Database page.
  5. In the Name field, give your database an easily recognizable name.
  6. Define the database Pool Size and Min/Max memory settings.
    • Max Memory must be greater than zero, but cannot exceed 65336 MB/64GB.
    • Min Memory must be less than or equal to the Max Memory setting.
    Note: The fields for defining Pool Size and Min/Max memory values can be empty. If a value is empty, that value will not be specified on the command line when starting the component, as if no value were explicitly defined.
    Note: For more information, see Database Pool Size and Runtime Instances.
  7. Under Module, select the Spectrum Technology Platform module to which this database applies. This will display the available database types in the Type selection list.
  8. Select the database to configure to populate the Required Databases and Optional Databases drop-down lists.
    Note that Optional Databases may not appear in the drop-down selection lists if none are available.
  9. If necessary, select the Override advanced settings check box to adjust Java Properties, Environment Variables, or supply command line processing arguments.

Override advanced settings

This feature is available from the Spectrum Databases > Add Database window. It provides a way to define extra command line arguments in Spectrum Management Console, rather than setting up a property file that you would reference for processing. This makes it easier to define and maintain database settings across Spectrum Technology Platform, especially in a clustered environment.
Note: We suggest that you change these settings with caution, as they can affect processing globally.
  • To add a new Java property or environment variable.
    1. Select either Java Properties or Environment Variables to expand the list of existing properties.
    2. Select the Add button to display a blank input line.
    3. Add a Name and Value for the new entity.
    4. Click Enter to save the new entity.
  • To delete a property or variable
    1. Select either Java Properties or Environment Variables to expand the list of existing definitions.
    2. Select the check box next to the entity to delete.
    3. Click the Delete button , above the entity list, to delete the setting.
      Note: You will not see a confirm message when you select the delete button.
  • Specifying command line properties
    Use this field to define command line properties that are not memory-related settings and cannot be expressed as Java properties.
    Note: We suggest that you change these settings with caution, as they can affect processing globally.