Configuring database properties
Spectrum™ Technology Platform can access data that resides in remote/connected databases, bringing the data into memory for processing. The Management Console Add Database window provides a UI-based method for configuring databases.
To configure database connections:
- Access 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.
- Go to Resources > Spectrum Databases.
- Select the Add database button to display the Add Database window.
- In the Name field, give your database an easily recognizable name, such as Q1 Addressing Job Database.
- 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: For more information, see Database Pool Size and Runtime Instances.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.
- 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.
- 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.
- 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 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.
To add a Java property or environment variable:
- Select either Java Properties or Environment Variables to expand the list of existing properties.
- Select the Add button to display a blank input line.
- Add a Name and Value for the new entity.
- Press Enter to save the new entity.
To delete a Java property or environment variable:
- Select either Java Properties or Environment Variables to expand the list of existing definitions.
- Select the check box next to the entity to delete.
- Click the Delete button , above the entity list, to delete the setting.