AE DB Archive

You use the AE DB Archive utility (ucybdbar and ucybdbarg) to archive data records by marking them with a deletion flag. You can create forecasts before you start the archiving process, reset archive flags, or export data to text files for external report analysis. Archived data is still available for years, it is stored in 7-bit ASCII code and can be displayed by using the Archive Browser. For more information, see Open Interface to Output Management Systems and Archive Browser.

This page includes the following:

Overview

Log on to the utility by using the client that you want to archive.

(Optional) You can archive the relevant data in batch mode with the ucybdbar utility but you must start the utility at least once in interactive mode to specify the settings you require. For more information, see Start Parameters - Utilities.

The graphical user interface of the ucybdbarg utility shows the following status information:

Three options are available which you can either double-click directly or open from the File menu:

Important! Database fields that are written to archive files are separated by semicolons. If semicolons are also used in the archive keywords, the separation of database fields is no longer unique. Therefore, the AE DB Archive utility converts the semicolons that are used in archive keywords to commas.

Settings Window

You can either use the Settings tab to define your archiving parameters or double-click the particular table line. The settings you define here will only apply to the client that you used to log on to the utility.

You can define date criteria for data records to be archived. The time considered is 00:00.

Messages Tab

Define what should be archived:

Statistics Tab

Reports related to the statistics will also be archived. The following fields are available:

Archive Tab

The following fields are available:

Create a Forecast

You can create a forecast before you start the actual archiving process to simulate archive runs. The forecast results are displayed within the tables.

If you already have archived data of the specific client, the estimated values (in the format hours:minutes:seconds) are calculated based on information of previous archive runs and becomes even more exact with each archiving process.

Structure of the Archive Folder

The base archive directory and the maximum size of the archive can be defined in the settings of the utility. The files archived can be browsed using the Archive Browser, see Archive Browser.

Structure of the Index Files

Index files are generated when the statistical records of the AH and RH tables are archived. Each index line refers to a data record in the archive. The individual positions of the data records are described below:

Index for AH: UC_AH.IDX

Example:

H2;1;LF;PROG;JPAK;GRP;1302137;;2017-05-23 10:31:42;0;0;;;LF.JP.GROUP;73837;2555;7;148

Index for RH: UC_RH.IDX

Example:

H3;98;JE01;MM.CHECK.FREE.SPACE;1000020;2017-05-24 12:56:03;2018-05-24 12:56:10;2820;39;12;151

Message Archive: UC_MELD.TXT

Example:

M;1;LF;PROG;2018-03-18 09:43:54;Automation Engine;Report;Error;;U0011021 Host 'LFT40' is not active!

Comment Archive: UC_ACMT.TXT

Example:

M;100;MH/PROG;TESTJOB;454711222;2018-03-15 09:43:54;nnn;This task was modified by (MH).

See also: