Archiving and Compressing the CCDB › Overview › NDVRARCO Command Language › COMPRESS

COMPRESS

In order to perform compress processing, the user must explicitly instruct NDVRARCO to do so. The syntax for COMPRESS is as follows:

►►────── COMpress ───────────────────────────────────────────────────────────►

 ►────┬───────────────────────────────────────────────────────┬───── - ──────►◄
      └─ TO ───┬─ DATE is mm/dd/yy ──┬────────────────────┬───┤
               │                     └─ TIME is hh:mm:ss ─┘   │
               │                                              │ 
               └─ AGE is age ─────────────────────────────────┘

• The TO DATE value is used to specify the month, day, and year prior to which the compress processing is to be performed. This is followed by an optional TIME value, which defaults to 23:59:59 if not specified.
• The TO AGE value is used to specify the number of days prior to which compression is to be performed.

If neither TO DATE nor TO AGE is specified, the system defaults to an age of 1 (day). NDVRARCO will not touch any Change Log Entries in the database that are less than 24 hours old.

Note: You are limited to one COMPRESS command per NDVRARCO run. If you specify more than one COMPRESS command, only the last applies.

There is a specific set of rules that CA Endevor/DB applies during compress processing:

• For A (Add), D (Delete), or M (Modify) actions -- A series of consecutive Adds that have the same entity description by the same USER/CCID will compress to a single Add; the same holds true for consecutive series of Modifies or Deletes. An Add followed by a series of Modifies will compress to an Add. A series of Modifies followed by a Delete will compress to a Delete. Finally, when Adds and Deletes alternate, the net result will be a Delete if the last action was a Delete, and a Modify if the last action was an Add. For A/M/D action compression, the resultant database record is also modified to show the count of the original change log record, plus the date/time of the oldest compressed record in the series.
• For C (migrate out) and V (migrate in) actions -- These actions are involved in migration as records are migrated out (C) of the source dictionary and migrated into (V) the target dictionary. When compress processing is performed, the most recent C and V record for each entity, for each source/target dictionary are preserved. Thus, the level of the last migration from or to, any dictionary is always preserved.
• Note that since the last C and V actions relative to each source or target are critical to future migration, NDVRARCO considers these records to be inviolate and does not remove them from the database, even if they meet an ARCHIVE command criteria.
• For I (Signin) and O (Signout) actions -- the most recent I (signin) and (O) signout records are preserved for each entity during compression.