This Variable (VARA) object defines the data records stored with ILM partitions.
These data records are divided in three categories. Therefore, there are three different variables that are populated by the utility AE DB Load (see AE DB Load when ILM is installed:
- UC_ILM_CONTAINER_STATISTICS for statistical records
- UC_ILM_CONTAINER_REPORT for reports
- UC_ILM_CONTAINER_MISC for messages, see AE DB Revision Report and Open Interface to Output Management Systems
The variables are supplied in the system client 0000 and their settings apply to the whole Automation Engine system.
-
Key:Container number
Note: A container is the mapping of a partition to a tablespace / filegroup
-
Allowed values: 1 to 999
-
Value: must start with 1 and be in ascending order.
-
MS SQL:Name of a file group
The file group name cannot exceed 200 characters.
-
Oracle:Name of a tablespace
-
-
Restart required: No
Notes:
- All three variables must have the same number of partitions. It is not possible to use five partitions for statistical records but only three for reports.
- Use the key ONLINE_PARTITIONS in the variable UC_ILM_SETTINGS to specify the number of online partitions. The number of existing partitions must be equal or larger than the number of online partitions. For more information, see UC_ILM_SETTINGS - Settings for Partitioning with ILM.
Example
For this example we use UC_ILM_CONTAINER_STATISTICS and assume there are three online partitions.
-
Key: 1
Value: UC4_DATA_STATISTICS_1
-
Key: 2
Value: UC4_DATA_STATISTICS_2
-
Key: 3
Value: UC4_DATA_STATISTICS_3
The Automation Engine starts by storing the statistical records in container 1. After a partition change, the data is stored in container 2, and so on. After using container 3, the Automation Engine starts again with container 1.
The number of the current container is displayed in the key ACT_CONTAINER in the variable UC_ILM_SETTINGS. For more information, see UC_ILM_SETTINGS - Settings for Partitioning with ILM.
See also: