History data is useful for monitoring database performance for a given period of time and for performing trend analysis. History options specify whether history data is collected, when it is collected, and where (that is, in which Adabas Review repository) it is stored.
This document covers the following topics:
Although history data may be written for both detailed and summary reports, the report type plays a key role in determining how Adabas Review processes history data.
A detail report maintains a one-to-one correspondence between a command log record read or passed to ADARVU and an output record produced by Adabas Review. When the command processed by Adabas Review satisfies the report processing rules, Adabas Review builds the required format and record buffer using the current report definition and immediately stores a record in the Adabas Review repository.
A summary report has a many-to-one relationship between multiple records processed (i.e., summarized) to produce one output record. When the Adabas Review interactive processor is running, information is written out to the Adabas Review repository at Adabas termination, when an interval is reached, or when the report is closed. If the Adabas Review batch processor is being executed, the data is written during end of file (EOF) processing.
For both types of reports, Adabas Review generates a Natural display program so that history data may be viewed online.
The parameters that determine whether Adabas Review writes history data are set when you create or edit the report definition. These history parameters appear on the Report Options screen of the Edit Report (ER) function.
If history data is to be written by a report running in batch mode, the history parameters make up the COPY statement.
The history options are briefly described in the following tables:
| Parameter | Specify . . . | Possible Values | Default |
|---|---|---|---|
HISTORY |
whether the data collected by the report is to be written to an Adabas Review repository and stored as history data. If (N), all other history options are ignored. | Y | N | N |
HISTORY INT |
the history interval; that is, the time interval during which history data is collected by the report. At each interval, the report prints its output if PRINT=Y and stores any history data. The report is then deleted. If RESTART=Y, the report is then restarted. | time duration in minutes | none |
If the HISTORY INT parameter is used,
history data is written to the Adabas Review repository at the interval
specified, provided the database containing the Adabas Review repository is
active.
To write history data at regular intervals (e.g., every hour), you must also specify RESTART=Y, so that the report is restarted after the interval has been reached. This parameter is listed on the Report Options screen of the Edit Report (ER) function.
Note:
If the report option RESTART=Y is specified, all history data for the
report is written to the Adabas Review repository file if the MAXK value for
the report is exceeded.
If the HISTORY INT parameter is
not used, history data is written to the Adabas Review repository at
Adabas termination.
The history parameters DBID,
FNR, and SVC specify the database
ID and file number of the Adabas Review repository, and the
SVC used to communicate with it. This information is
obtained from the target definition for the database you are using.
You may change these parameters, provided that they specify another Adabas Review repository.
| Parameter | Specify . . . | Value | Default |
|---|---|---|---|
HISTORY DBID |
the ID number for the database that is to store the history data; that is, the Adabas Review repository. * The default is the database ID of the Adabas Review repository to which you currently have access. | dbid | * |
HISTORY FNR |
the ID number of the file in the Adabas Review repository that is to contain the history data. ** The default is the file number in the Adabas Review repository to which you currently have access. | fnr | ** |
HISTORY SVC |
the Adabas SVC number used to write the history data to the Adabas Review repository. *** The default is the SVC number of the Adabas Review repository that you are currently accessing, if that database appears on the Target Definitions screen (LT function). Otherwise, the default is the SVC number of the default database listed on the Target Definitions screen. | svc | *** |
