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:

The variables are supplied in the system client 0 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.

See also: