UC_ILM_SETTINGS - Settings for Partitioning with ILM

Number of the active container

Allowed values: "1" - "999"

Current partition number

The Automation Engine counts the partitions used for installing ILM and increases this value by "1" with each partition change.

ILM status

Allowed values: "Y" and "N"

"Y" - ILM is active, i.e. new partitions are created and switch-outs (only MS SQL Server) are performed.
"N" - ILM is not active, i.e. no partition change or switch-out (only MS SQL Server) is made.

Calendar that includes the days on which the partition should be changed.

Format:

Calendar object/calendar keyword

The partition is changed at 00:00 on the days specified in the calendar keyword. The TimeZone of system client 0000 serves as the time basis.

Object that should be activated if an error occurs.

The following script variables can be read from the read buffer:

• ILM_ACTION# - action in which an error occurred
  The script variable can contain the following values:
  "ADD_PARTITION": partition change
  "CHECK": check for data records of active tasks in the partition
  "DROP": deletion of a partition
  "SWITCH_OUT": switch-out of the oldest partition (only MS SQL Server)
  
• ILM_PARTITION_NAME# - name of the affected partition
• ILM_ERROR_MSGNR# - AE error number
• ILM_ERROR_MSG_INSERT# - variable part of the message text
• ILM_DB_ERROR_MSG# - error message of the databaseA database is an organized collection of data including relevant data structures.

The object is searched for and activated in all clients except for system client 0000. No activation is allowed in this client.

Object that should be activated if an ILM action was successful

 The following script variables can be read from the read buffer:

• ILM_ACTION# - action in which an error occurred
  The script variable can contain the following values:
  "ADD_PARTITION": partition change
  "CHECK": check for data records of active tasks in the partition
  "DROP": deletion of a partition
  "SWITCH_OUT": switch-out of the oldest partition (only MS SQL Server)
  
• ILM_PARTITION_NAME# - name of the affected partition

The object is searched for and activated in all clients except for system client 0000. No activation is allowed in this client.

Name of a Login object that includes the database user to be used for executing ILM actions.

In the Login object, select the host type "DB".

The Login object must be stored in system client 0000.

The database user specified in the Login object must have permission to read the following system tables: 

• ALL_TAB_PARTITIONS
• ALL_CONSTRAINTS
• ALL_PART_INDEXES
• ALL_INDEXES

Number of online partitions.

Allowed values: "1" - "999"

Maximum number of attempts to change the partition until ILM is automatically deactivated.

Allowed values: "1" - "3200"
Default value: "3"

Time (in minutes) to wait between attempts to change the partition (RETRY_MAX_COUNT).

Allowed values: "1" - "3200"
Default value: "10"

Name of the user who created the AE database.

This parameter is required for Oracle databases only.

Note that this parameter is case-sensitive.

The Automation Engine assumes that there is no further AE installationation within the Oracle instance and that all tables within this instance are unique if no user is indicated.

Time delay in minutes for the statistical update after the partition has been changed (only Oracle).

Allowed values: "0" - "1400"
Default value: "15"

Value "0" has the effect that no statistical update is made.

Maximum time in seconds that the Automation Engine is stopped before the partition is changed.

Allowed values: "60" - "32000"
Default value: "3600"

When it is time to change the partition, processing in the AE system comes to a halt and waits until all work processes have ended their ongoing database transactions. The key TIMEOUT is decisive for the maximum waiting time. No new partition can be created if this period of time is exceeded.