Version 4.5.1
 —  Using Adabas Review  —

Managing History Data

If any reports are set to save history data to the Adabas Review repository, data will accumulate that needs to be managed. This document covers the following topics:


Listing History Reports

The List History Reports (LH) function lists reports that have written history data to the Adabas Review repository, and provides commands to view history data, download it to a personal computer, submit it for hard copy printing, and purge it. In addition, you may edit the report definition and its corresponding display program.

Start of instruction setTo access the List History Reports function:

  1. Enter the code LH on the command line.

    The Adabas History Reports screen is displayed:

    20:29:12                  A D A B A S  -  R E V I E W                2009-06-18
                                    History Reports                       HUB=15690
                                                                                   
                                                                                   
      Sel     Report Name                     Recs   Rpts   Start Date   End Date  
    +-----------------------------------------------------------------------------+
    ! __  APPLICATION FILE FIELD USAGE          25      2   2009-06-18 2009-06-18 !
    ! __  COMMAND LOGGING                        6      1   2009-06-18 2009-06-18 !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    +-----------------------------------------------------------------------------+
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit                           +                      Menu   

An explanation of the Adabas History Reports screen is provided in the following table:

Heading Explanation
Sel Selection line. Commands are entered on the selection line preceding the report name. For a list of available commands, enter a "?" on the selection line.
Report Name Name of the report.
Recs Records. Indicates the number of records written to the Adabas Review repository by this report.
Reports Indicates the number of times that history data was written for the report.
Date Range Starting and ending dates in which the report was run. If the "Reports" column indicates more than one occurrence, the dates are inclusive.

PF8 has been provided as a scroll key. If more than one screen of report names exists, PF8 or (+) scrolls the list forward.

Start of instruction setTo issue a command from the Adabas History Reports screen:

  1. Enter the command on the selection line preceding the report name.

    You may use the following commands:

    Cmd Action
    CH Compress history report
    DD Display report information
    DL Download history data (from expanded list only)
    EP Edit display program
    ER Edit report definition
    EX Expand history list (from summary screen only)
    HC Print history data (hard copy)
    PH Purge history data (from expanded list only)
    VW View history data. You are prompted for a date and time range for the history data report. If you specify no date or time range, all history data is presented. If you specify a date with no time, all history data for that day is presented.

Top of page

Expanding the List of History Reports

If the list of history reports (LH function) shows a report name as having more than one report, it means that the report has collected data on more than one occasion. Data has been stored on the history file each time the report was active.

Start of instruction setTo view information about each time a report has collected data:

  1. Enter the command EX on the selection line preceding the report name.

    The Expanded History List screen that appears is similar to the one shown below:

    20:42:30                  A D A B A S  -  R E V I E W                2009-06-18
                            History Reports (Expanded List)               HUB=15690
                                                                                   
                                                                                   
      Sel     Report Name                        Start               Stop          
    +-----------------------------------------------------------------------------+
    ! __ APPLICATION FILE FIELD USAGE     2009-06-18 20:24:23 2009-06-18 20:25:09 !
    ! __ APPLICATION FILE FIELD USAGE     2009-06-18 20:26:59 2009-06-18 20:27:28 !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    +-----------------------------------------------------------------------------+
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit                           +                      Menu   

Note:
A start time of CMPRSSED indicates that the report occurrence is the result of the compress history (CH) command.

Top of page

Compressing Accumulated History Report Data

The compress history (CH) command causes all report occurrences within a date range to be summarized into a single report occurrence. The original report occurrences will then be purged.

This section covers the following topics:

Cautions

RESET HISTORY FILE

If history records were indeed lost, the reset program will inform you of this.

Advantages

Start Times for Compressed Reports

All report occurrences that have been compressed will show a start time of CMPRSSED on the Expanded History List.

Compression Procedure

Start of instruction setTo compress accumulated history data:

  1. From the History Reports screen, enter the CH command to compress history data for a specific report and press ENTER .

    You are prompted to enter a date range for the records to be compressed.

  2. Enter the date range and press ENTER.

    A message is displayed, warning you that records could be lost due to abnormal termination.

  3. Enter "Y" and press ENTER to continue

    Or:
    Enter "N" and press ENTER to cancel the compress command.

    You are returned to the History Reports screen.

    You are prompted to enter an ET (End Transaction) factor.

  4. Enter an ET factor and press ENTER.

    The ET factor describes the number of Adabas calls that will be performed before an ET (end transaction) is issued. There is no default value. If a value of less than 5 is entered, 5 will be assumed. A good value to start with is 25.

    Or:
    Press ENTER to accept the default value of 25.

    Messages report the progress of the history data compression. The final message, "History report compression complete", indicates that the compression has completed.

Top of page

Purging Accumulated History Data

The data accumulated by a history report is purged using the PH command.

Start of instruction setTo purge accumulated history data:

  1. From the History Reports screen, enter the EX command to expand the list so that all occurrences for the particular report are displayed.

  2. From the expanded list, select the occurrence you want to delete, type the PH command on the selection line preceding the report name, and press ENTER.

    Depending on the setting in your profile, you may be prompted to confirm the purge request.

  3. Confirm the purge request, if required.

Top of page