Administration Guide › Aggregation and Correlation Engine (ACE1) › Adding ACE Instances › Configure Multiple ACE Instances

Configure Multiple ACE Instances

All ACE configuration parameters are configured for the default instance (instance 0). All additional ACE instances, by default, use the parameters configured for the default instance. You can configure the additional ACE instances differently than the default instance, by manually adding the configuration parameters to the T_SYSTEM_CONFIGURATIONS table.

In the T_SYSTEM_CONFIGURATIONS table, the configuration parameters are arranged in a tree-like structure. In the tree, under the 'pslwriter' key, you can find the following:

• All ACE-related parameters
• Keys for all instances of ACE other than 0
  • For every instance other than 0, there is a special key which is located under the 'pslwriter' key in the table. The name of the key is 'pslwriterX', where X is the instance ID. The ACE instance adds this key when it first runs.

You can configure a parameter for a specific instance.

Follow these steps:

1. In the T_SYSTEM_CONFIGURATIONS table, under the 'pslwriter' key, inside the 'pslwriterX' key, add the parameter.
2. Set the value of the parameter.

   For example, all instances have a cycle length of one hour.

   You can set instance 5 with the cycle length of two hours. Under the pslwriter key, create a cyclelength parameter and set it to 7200.

3. Run the following query to display the keys of all instances that exist in T_SYSTEM_CONFIGURATION that are relevant to the engine:

   select t.sys_config_id, t.sys_config_name 
   from t_system_configurations t 
   where t.sys_config_parent=71
   and t.sys_config_name like 'pslwriter%'
   

4. Very that pslwriter5 exists. If pslwriter5 does not exist, you probably never ran it. Run it for a few seconds so that it adds the necessary keys to the table.
5. From the query, take the SYS_CONFIG_ID of instance 5 and run the following query to see the configuration parameters that currently exist for instance 5.

   select t.sys_config_id, t.sys_config_name,  t.sys_config_value
   from t_system_configurations t 
   where t.sys_config_parent=<SYS_CONFIG_ID of instance 5>
   

6. If the parameter, "cyclelength", exists, set the value with the following query:

   update t_system_configurations t
   set t.sys_config_value='7200' 
   where t.sys_config_id=<SYS_CONFIG_ID of the parameter>
   

7. If the parameter, "cyclelength", does not exist, add the parameter and set the value with the following query:

   insert into t_system_configurations t
   (
   	SYS_CONFIG_ID, 
   	SYS_CONFIG_NAME, 
   	SYS_CONFIG_VALUE, 
   	SYS_CONFIG_PARENT, 
   	MODIFY_DATE
   )
   values
   (
   	seq_sla_sys_config.nextval, 
   	'cyclelength', 
   	'7200', 
   	<SYS_CONFIG_ID of instance 5>,
   	sysdate
   )