UC_ILM_CONTAINER_* - Automation Engine Database Partitions

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 AE DB Load utility (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 ONLINE_PARTITIONS key in the UC_ILM_SETTINGS variable 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 ACT_CONTAINER key in the UC_ILM_SETTINGS variable. For more information, see UC_ILM_SETTINGS - Settings for Partitioning with ILM.