UC_UTILITY_REORG - Reorganization Specifications

This Variable (VARA) object contains specifications and information concerning the data reorganization process. The AE DB Reorg utility (see AE DB Reorg) automatically creates and updates this variable. Therefore, no manual interaction is required.

This variable includes the following keys:

AH

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.
MELD

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
OBJECT_AUDIT

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

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

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