UC_UTILITY_REORG - Reorganization Specifications

This Variable (VARA) object contains specifications and information concerning the data reorganization process. There are various ways of reorganizing data. Depending on which method you choose, one of the following is true:

Reorganizing through the REST API or AWI, see Reorganizing Operational Data and AE REST API - Database Maintenance.

In this case, you do need to define the variable in advance. The list below indicates whether a key is relevant when archiving through AWI/REST API or not.
Reorganizing with the AE DB Reorg Utility

The AE DB Reorg utility automatically creates and updates this variable. Therefore, no manual interaction is required when using the Utility.

This variable includes the following keys:

AH

Relevant for all reorganization methods.

Description: Reorganization of statistical data

Format:flag1 days flag2 number
- flag1: reorganizes statistics (TRUE -yes, FALSE - no)
- days: archive old statistics
- flag2: keeps statistics (TRUE -yes, FALSE - no)
- number: keeps at least the number of statistical entries per object that is specified here, even if these entries are older than the days that have been specified
Important! The settings of flags 1 and 2 work together as follows: the AE DB Reorg utility keeps all records for each object with a timestamp newer than the threshold defined in flag1. For records older than this threshold, the system retains the newest N entries per object, as set by flag2. For example, if the variable is set as TRUE 0030 TRUE 0050 you will retain all runs from the last 30 days plus 5 older runs per object.
AUTO_REORG

Relevant when reorganizing through AWI/REST API.

Description: Defines the maximum age of data records in days. All data records older than this specified value are reorganized (unless NO_ARCHIVE_CHECK is set to 0, in which case it only reorganizes previously archived records).

Note: This value overrules other specific age settings in the variable if it specifies fewer days.

Format: The age in days

Allowed values: 0 to 32767. If set to 0, all data records are reorganized.

Default value: 365
MELD

Relevant for all reorganization methods.

Description: Reorganization of messages

Format:flag days1 days2
- flag: reorganizes messages (TRUE -yes, FALSE - no)
- days1: reorganizes read messages that are older than specified here
- days2: reorganizes unread messages that are older than specified here
NO_ARCHIVE_CHECK

Relevant when reorganizing through AWI/REST API.

Description: Determines whether the reorganization process checks if data has been archived before reorganizing it.

Format: flag
- 0: Checks if data has been archived before.
- 1: There is no archiving check.
Default value: 0
OBJECT_AUDIT

Relevant for all reorganization methods.

Description: Reorganization of Revision Reports

Format:flag1 days flag2
- flag1: reorganizes Revision Reports (TRUE -yes, FALSE - no)
- days: reorganizes Revision Reports that are older than specified here
- flag2: reorganizes only audited Revision Reports (TRUE -yes, FALSE - no)
RH

Relevant for all reorganization methods.

Description: Reorganization of reports

Format: flag1 days flag2 number
- flag1: reorganizes reports (TRUE -yes, FALSE - no)
- days: reorganizes reports that are older than specified here
- flag2: keeps reports (TRUE -yes, FALSE - no)
- number: keeps at least the number of reports per object that is specified here, even if these entries are older than the days that have been specified
VERSION_CONTROL

Relevant for all reorganization methods.

Description: Reorganization of duplicated objects

Format:flag1 days flag2 number
- flag1: reorganizes duplicated objects (TRUE -yes, FALSE - no)
- days: reorganizes versions that are older than specified here (TRUE - yes, FALSE - no)
- flag2: keeps versions (TRUE -yes, FALSE - no)
- number: keeps at least the number of versions per object that is specified here, even if these entries are older than the days that have been specified