Maintaining Report Definitions

This document discusses the Adabas Review facilities that allow you to maintain Adabas Review report definitions. After you have completed your report, you may start it immediately, or save it to be started at another time. A report must be started so that it can accumulate data. For more information, read Running Reports.

Note:
You cannot name a report "ALL".

It covers the following topics:


Listing Report Definitions

The List Report Definition (LR) function lists all reports. From the list, you can:

  • Directly update the DBID and Auto Start report options. All report definitions on the screen can be updated in a single operation.

  • Use commands to maintain a report. The commands are entered on the selection line preceding the name of the report.

Start of instruction setTo access the List Report Definition function:

  1. Enter the code LR on the command line.

    Or:
    You can specify the report name or partial report name in the LR command. For example:

    • Specifying LR IO SUMMARY BY RABN* will display the list of all report definitions, starting at the IO SUMMARY BY RABN report.

    • Specifying LR IO* will display the list of all report definitions, starting with the first report with the name beginning with the word "IO". In this case, if both the IO COUNT BY HOUR and IO SUMMARY BY RABN reports are in the list, the list would start at the IO COUNT BY HOUR report.

    Note:
    You must specify an asterisk at the end of the full or partial report name in the LR command.

    The Report Definitions screen appears. In this example, no specific report name or partial report name was requested:

    10:13:39                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)             Report Definitions             Hub Target: 296  
                                                                                  
                                                             Sum          Display 
      Sel     Report Name                    DBID Type Auto  Det   Hist   Program 
    +-----------------------------------------------------------------------------+
    | __ > APPLICATION FILE FIELD USAGE            D     N    S     N    SR-00030 |
    | __   BUFFER POOL DISPLAY                     D     N    S     N    BUFFPOOL |
    | __   COMMAND LOGGING                         D     N    D     N    SR-00025 |
    | __ > COMMANDS BY HOUR                        D     Y    S     N    SR-00004 |
    | __   COST ACCOUNTING EXAMPLE                 D     N    S     N    SR-00028 |
    | __   DESCRIPTOR USAGE REPORT                 D     N    S     N    SR-00020 |
    | __ > EXCEPTIONAL RESPONSE CODES              D     Y    S     N    SR-00002 |
    | __   FILE USAGE                              D     N    S     N    SR-00031 |
    | __   XYZTEST                            ALL  DSN   N    S     N    RD-00004 |
    | __ < XYZTEST1                           ALL  DSY   N    S     N    RD-00121 |
    | __ < XYZTEST2                           ALL  DSY   N    S     N    RD-00024 |
    | __   HOURLY DATABASE OVERVIEW                D     N    S     N    SR-00032 |
    +-----------------------------------------------------------------------------+
                                                                                  
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit  Mod                -     +                      Menu

The columns of the Report Definitions screen are explained as follows:

Sel Selection line. Enter commands on the selection line preceding the report name. For a list of available commands, enter a ? on the selection line.
Report Name

An arrow (>) preceding the report name indicates that the report has been started.

An arrow (<) preceding the report name indicates that the report has been scheduled and resides in the wait queue.

DBID

The database ID of the database from which the report data is collected. Possible values are a valid database ID, the term "ALL", or a blank. For more information, read Specifying the Report DBID.

Type

First character: Indicates whether the report is a regular Adabas Review report ("D") or an Adabas Review client report ("C").

Second character: Indicates whether the report is defined with scheduling parameter ("S"). If blank, there is no scheduling definition.

Third character: Indicates whether the scheduling definition is active ("Y") or not active ("N").

Auto Indicates whether the report is started automatically at database initialization.
Sum/Det "S" indicates a summary report; "D" indicates a detailed report.
Hist Indicates whether the report writes history data.
Display Program Lists the name of the program generated to display report output online. In mode DISPLAY=BASIC the program names start with RD or SR. In mode DISPLAY=EDITOR the program names start with RX or SX.

PF7 and PF8 have been provided as scroll keys. If more than one screen of report names exists, PF8 or (+) scrolls the list forward and PF7 or (-) scrolls the list backward.

Start of instruction setTo update the values of the DBID and/or Auto Start report options:

  1. Press PF4 (Mod).

    All DBID and Auto fields become modifiable (modify mode).

  2. Modify the values as required.

  3. Press PF5 (Update) to save the changes or PF3 (Exit) to abandon your changes.

Only the report definitions listed on the current screen may be modified. Pressing PF8 to move forward or PF7 to move backward cancels the modify mode.

Start of instruction setTo issue a command from the Report Definitions screen:

  1. Enter one of the following commands on the selection line preceding the report name.

Command  Issue this command to...
CD Change DBID
CP Change display program
CR Copy report definition
DD Display report information
EB Edit buffer pool report
EL Edit Pulse Report
EX Edit Cluster Services Report
EP Edit display program
ER Edit report
PR Purge report definition
RG Regenerate display program
SC Schedule report
ST Start report
VW View started report
VX View started report with Software AG Editor

Creating a New Report Definition

You can create a new report definition by entering all of its information on the Edit Report screen or by copying an existing report and editing its settings. This section describes how to create a new report definition by entering all of its information on the Edit Report screen. For information on copying a report definition and editing it, read Copying a Report Definition and Editing Existing Reports.

Start of instruction setTo create a new report definition, complete the following steps:

  1. At any SYSREVDB command prompt, enter the command ER followed by the name of your new report.

    Note:
    If you want to create a client report, enter the command EC followed by the name of your new report.

    Or:
    Simply enter ER or EC at any SYSREVDB command prompt.

    The ER command invokes the Edit Report screen; the EC command invokes the Edit Client Report screen.

    If you specified the name of a report, it is filled in the Report Name field. The following example shows a blank Edit Report screen:

    10:14:37                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)               Edit Report                  Hub Target: 296  
                                                                                   
    Detail/Summary: S   Report Name: ________________________________   DBID: _____
                                                                                   
    +-----------------------------------------------------------------------------+
    |  Field     Order   Sum   Min   Max   Avg   Pct   Rate      Cost      Round  |
    |-----------------------------------------------------------------------------|
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    +-----------------------------------------------------------------------------+
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help  Optns Exit  SOnly Save  Start  -     +    Sched Rules Flds  Menu
  2. Tab to the Detail/Summary field and indicate whether this will be a detail (D) or summary (S) report.

  3. Tab to the DBID to Monitor field and specify the database ID on which the report data should be based. For more information, read Specifying the Report DBID.

  4. Type the name of the report in the Report Name field, if you have not already specified one. For more information, read Specifying the Report Name.

    Note:
    Once you have specified a name for the report, you can save the report definition at any time by pressing PF5.

  5. Tab to the field table for the report and specify the fields and the order of the fields for the report.

    Up to 20 fields may be selected for a single database or client reporting report. You may enter field names directly on the appropriate screen or you may select the fields from lists provided on other screens (use PF11 to access these screens). The fields you choose from the screen lists are transferred automatically to the Edit Report or Edit Client Report screen (as appropriate).

    A complete list of Adabas Review fields can be found in the Field Reference.

    Note:
    Alternate field names that you find in the Field Reference cannot be used in SYSREVDB (online) reports. Only field names that are listed on the SYSREVDB screen lists can be used.

    If the field type is numeric, you can specify whether the values are to be rounded, totaled, averaged, expressed as a percentage or rate of commands per second, or whether a cost should be calculated for the field. You can also specify that the minimum or maximum values are to be displayed.

    For complete information on specifying fields and field order for the report, read Specifying Field Names and Specifying Field Order. The following additional documentation might also be useful:

  6. Optionally specify processing rules for the fields in your report. Report processing rules determine how field values are selected for your standard database and client reports. These rules restrict the accumulated data to certain values or conditions. For more information, read Using the Report Processing Rules Screen.

  7. Specify reporting options for the report by pressing PF2 or entering the OPTNS command on the command line of the Edit Report or Edit Client Report screen. Report options describe additional processing aspects of the standard database and client reports. These include such things as whether the report will perform command or summary logging, whether the data it collects will be written to the Adabas Review repository and stored as history data, whether and how the data it collects will be written to the Adabas Review raw log file, and whether a report may be scheduled.

    For more information, read Using the Report Options Screen.

  8. Save the report definition by pressing PF5. For more information, read Saving a Report Definition.

    You can now start the report if you want. For more information, read Running Reports Online.

    Note:
    Pressing PF4 saves a report, but does not generate a display program. PF6 (Start) or PF9 (Schedule) also saves (PF5) a report before starting/scheduling it.

Changing the DBID

Each report collects data from a particular database. You can change that database using the Change DBID (CD) command from the List Report Definitions (LR) function. The CD command is issued from the Report Definitions screen.

Start of instruction setTo change the database for which the report is to be created:

  1. Enter the CD command on the selection line preceding the report name and press ENTER.

    The cursor is positioned at the DBID column for that report and the field is opened for editing.

  2. In the DBID column, enter a value as defined in Specifying the Report DBID.

    If you leave the DBID blank, you will be prompted to enter the DBID when you start the report.

Mass Update of Target DBIDs

You can also change the database from which data is collected for multiple reports at the same time by issuing the MODIFY DBIDS command from the List Report Definitions (LR) function.

There are two options for accomplishing mass DBID changes. Option 1 allows you to update them manually from a screen, whereas option 2 is command line driven and allows many DBIDs to be changed with a single command.

Start of instruction setTo modify the database for which the report is to be created using option 1:

  1. Enter MODIFY DBIDS on the command line of the Report Definitions screen and press ENTER.

    The Modify DBIDs screen appears listing as many as 24 reports:

    10:16:41                  *****   R E V I E W   *****                2020-02-10
                                     Modify Reports                                
                                                                                   
                                                                                   
       DBID      Report Name                  DBID      Report Name                
    +-----------------------------------------------------------------------------+
    |  None APPLICATION FILE FIELD USAGE   |  None JOB OVERVIEW                   |
    |  None BUFFER POOL DISPLAY            |  None LAST 500 ADABAS CALLS          |
    |  None COMMAND LOGGING                |  None LONG RUNNING COMMANDS          |
    |  None COMMANDS BY HOUR               |  None NATURAL PROGRAM TRACE          |
    |  None COST ACCOUNTING EXAMPLE        |  None NATURAL SUMMARY                |
    |  None DESCRIPTOR USAGE REPORT        |  None NATURAL TRANSACTION TRACE      |
    |  None EXCEPTIONAL RESPONSE CODES     |  None PRILOG REPORT                  |
    |  None FILE USAGE                     |  None RATE OF COMMANDS AND IOS BY DA |
    |  None HOURLY DATABASE OVERVIEW       |  None RATE OF COMMANDS AND IOS BY HO |
    |  None IO COUNT BY HOUR               |  None SCHEDULE FILE USAGE            |
    |  None IO SUMMARY BY RABN             |  None SUMMARY REPORT BY FILE         |
    |  None IO SUMMARY BY VOLUME           |  None THREAD ACTIVITY                |
    +-----------------------------------------------------------------------------+
                   (Press PF2 to set all reports to the same DBID)                 
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help  Same  Exit        Save         -     +                      Menu

Start of instruction setTo modify the DBID to be monitored for any number of reports:

  1. Overtype the listed DBID for each report.

  2. Press PF5 to save your changes; press PF3 to exit without saving your changes.

Start of instruction setTo change the DBID for all reports listed on the screen to the same DBID:

  1. Press PF2.

    You are prompted to enter the DBID.

  2. Enter the DBID and press ENTER.

Start of instruction setTo modify the database for which the report is to be created using option 2:

  1. From the LR screen, enter the following into the command line:

    CHANGE DBID FROM fffff TO ttttt

    Where fffff is the current DBID and ttttt is the new DBID.

    Valid values for fffff and ttttt are: A numeric DBID within a range of 1 to 65535, ALL or NONE.

    • Example 1:

      CHANGE DBID FROM 11111 TO ALL
    • Example 2:

      CHANGE DBID FROM NONE TO 12345
    • Example 3:

      CHANGE DBID FROM 22222 TO NONE

    Both DBIDs must be different or an error message will be issued.

Displaying Report Information

From the list of available report definitions, you can display (DD) a brief summary of report information. For all reports, this information includes:

Name name of the report.

Note:
You cannot name a report "ALL".

Saved By the identity of the user who saved the report
Saved Last the date when the report was saved the last time
Format whether the report provides summary or detailed information
History whether history data is saved for the report

For each individual report the following information is included, depending on the report's particular settings:

Account for summary reports, the order in which control breaks occur; for detailed reports, the order in which the fields are displayed.
Summary the fields for which summary values are calculated
Rate the fields for which the rate per second for the field's value is calculated.
Minimum the fields for which the minimum value is displayed.
Maximum the fields for which the maximum value is displayed.
Average the fields for which average values are calculated
Round the fields for which the value is rounded (that is, incremented) by the amount specified in the report definition so that the result is evenly divisible by the "round" value.
Select the fields selected for the report. A maximum of 20 fields is allowed for each report.

Start of instruction setTo display report information:

  1. From the Started Reports screen, enter the DD command on the selection line preceding the report name to display a summary of report information.

    A screen similar to the following appears:

    19:12:57                  *****   R E V I E W   *****                2020-07-18
                                   Report Information                              
                                                                                   
                                                                                   
                                                                                   
    +-----------------------------------------------------------------------------+
    ! Name...... APPLICATION FILE FIELD USAGE                                     !
    ! Saved By.. INSTALL                                                          !
    ! Saved Last 2020-07-15                                                       !
    ! Format.... Summary                                                          !
    ! History... No                                                               !
    ! Account... NATAPPL,FILE,FBFIELDS                                            !
    ! Summary... IOS,COMMANDS,CMDRESP,ADADURA                                     !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    !                                                                             !
    +-----------------------------------------------------------------------------+
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit                     -     +                      Menu

Copying a Report Definition

One way to create new reports is to use the Copy Report Definition (CR) command from the List Report Definitions (LR) function. The CR command is issued from the Report Definitions screen. The command allows you to copy a report definition either to another Adabas Review repository, or to the current Adabas Review repository under a new name.

Start of instruction setTo copy a report definition and generate a display program:

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

    Adabas Review displays the Copy Report Definition window, which contains the Report Name, the DBID, and File number of the report definition to be copied. The Report Name field is initially set to the report name to be copied.

  2. If you are copying the report to the current Adabas Review repository, change the report name.

    Note:
    You cannot name a report "ALL".

    The DBID and the File fields indicate the repository where the report is to be copied. These fields are initially set to the current repository.

  3. Ensure that the DBID and File indicate a valid Adabas Review repository.

  4. Once you have made the required changes, press PF5 to copy the report definition, or press PF3 to cancel and exit the window.

    After the report definition is copied, the Display Program Name will display the message

    Need RG

    This indicates that you must generate a display program before the new report can be displayed.

  5. Generate a display program in one of two ways:

    Enter RG on the selection line preceding the new report name; or

    Edit the report using the Edit Report (ER) function; then save it. Adabas Review automatically generates a new display program reflecting the changes.

Purging a Report Definition

The Purge Reports (PR) command is issued from the Report Definitions screen (LR function). This command deletes the report definition and the corresponding display program, if the display program is not also used with a history report.

Start of instruction setTo purge a report definition:

  1. Enter the PR command on the selection line preceding the name of the report to be deleted.

    Depending on your profile settings, you may be prompted to confirm the purge request before the command is executed.

  2. Confirm the purge request, if required.

Maintaining Buffer Pool Reports

A sample report called "Buffer Pool Report" is created when Adabas Review is installed. The Edit Buffer Pool Report (EB) function uses the sample report to create, edit, and start buffer pool reports for specific databases being monitored.

Unlike other reports, a display program is not generated for buffer pool reports when they are saved. When viewed, these reports call the program BUFFPOOL, which displays a bar graph showing the buffer pool statistics.

This section covers the following topics:

Accessing the Edit Buffer Pool Report Screen

Start of instruction setTo access the Edit Buffer Pool Report screen:

  1. Enter the EB command on the command line.

    Or:
    Enter the ES command on the command line to access the Specialty Report Types menu.

    10:18:50                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)          Specialty Report Types            Hub Target: 296                                                                                 
                                                                                   
                                                                                   
                      Code               Description                               
                      ----     ---------------------------------                   
                       CM           Review Client Management                       
                       EB           Edit Buffer Pool Report                        
                       EC           Edit Client Report                             
                       EL           Edit Pulse Report                              
                       EX           Edit Cluster Services Report                   
                      ----     ---------------------------------                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit                                                  Menu

    Then enter the EB command on the command line.

    The Edit Buffer Pool Report screen appears.

    10:19:31                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)          Edit Buffer Pool Report           Hub Target: 296  
                                                                                   
                                                                                   
                                                                                   
                +-------------------------------------------------------+          
                !                                                       !          
                !   Report Name: ... ________________________________   !          
                !                                                       !          
                !   DBID: .......... _____                              !          
                !                                                       !          
                !   Autostarted: ... N                                  !          
                !                                                       !          
                !                                                       !          
                +-------------------------------------------------------+          
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit        Save  Start                               Menu

Creating a New Buffer Pool Report

Start of instruction set To edit the Buffer Pool Report:

  1. Access the Edit Buffer Pool screen, as described in Accessing the Edit Buffer Pool Screen.

    The Edit Buffer Pool Report window appears as shown in the following example:

    10:20:59                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)          Edit Buffer Pool Report           Hub Target: 296  
                                                                                   
                                                                                   
                                                                                   
                +-------------------------------------------------------+          
                !                                                       !          
                !   Report Name: ... ________________________________   !          
                !                                                       !          
                !   DBID: .......... _____                              !          
                !                                                       !          
                !   Autostarted: ... N                                  !          
                !                                                       !          
                !                                                       !          
                +-------------------------------------------------------+          
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit        Save  Start                               Menu
  2. Supply a name for the report in the Report Name field.

    Note:
    You cannot name a report "ALL".

  3. Optionally, supply the database ID for which buffer pool information is collect in the report using the DBID field.

  4. Indicate whether the report should be autostarted or not in the Autostarted field. Specify "N" if you do not want it autostarted; specify "Y" if you do.

  5. Press PF5 to save your changes to the report; press PF6 to save the report and manually start it.

Editing a Buffer Pool Report

Start of instruction set To edit a Buffer Pool Report:

  1. Locate the report on any of the list function screens (LR, LS, and LH) and enter the ER command in the Sel column associated with the report.

    Or:
    Enter the ER rptname or the EB rptname command on the command line of any screen.

    The Edit Buffer Pool Report window appears for the report you selected.

  2. Optionally change the name for the report in the Report Name field.

    Note:
    You cannot name a report "ALL".

  3. Optionally, change the database ID for which buffer pool information is collect in the report using the DBID field.

  4. Optionally, change the autostart selection specified by the Autostarted field. Specify "N" if you do not want it autostarted; specify "Y" if you do.

  5. Press PF5 to save your changes to the report; press PF6 to save the report and manually start it.

Maintaining Adabas Pulse Reports

Adabas Pulse Reports receive nucleus statistical data from Adabas on an interval basis. Adabas transmits a pulse record to Adabas Review once in each interval period.

Adabas Pulse Reports allows a DBA to collect statistical details about the Adabas nucleus during a user-specified time interval. The reports collect minimum, maximum, and average values for non-cumulative nucleus statistics such as:

  • The current number of users

  • The current amount of the work pool used

  • The current number of hold queue elements

Adabas Pulse Reports also gather and calculate the delta values of cumulative nucleus statistics such as buffer waits, format overwrites, and buffer flushes. These statistics can help a DBA monitor overall database activity over a given period of time. Non-cumulative statistics are checked every minute with the average calculated at the time interval. Cumulative statistics are checked only at the time interval when deltas are calculated.

Only one Adabas Pulse Report may be started per database. In the Adabas Review hub environment, you may have several Adabas Pulse Reports active, but only one for each of the monitored databases.

The Adabas Pulse Report timer interval can be set in the report options and must be specified in minutes. The minimum interval is one minute and the maximum is 1440 minutes (24 hours). Once a report is started, the specified interval remains in effect until the report is stopped. A new interval can be set prior to restarting the report.

Accessing the Edit Adabas Pulse Report Screen

Start of instruction setTo access the Edit Adabas Pulse Report screen:

  1. Enter the EL command on the command line.

    Or:
    Enter the ES command on the command line to access the Specialty Report Types menu.

    10:21:37                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)          Specialty Report Types            Hub Target: 296  
                                                                                   
                                                                                   
                                                                                   
                      Code               Description                               
                      ----     ---------------------------------                   
                       CM           Review Client Management                       
                       EB           Edit Buffer Pool Report                        
                       EC           Edit Client Report                             
                       EL           Edit Pulse Report                              
                       EX           Edit Cluster Services Report                   
                      ----     ---------------------------------                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit                                                  Menu

    Then enter the EL command on the command line.

    The Edit ADABAS Pulse Report screen appears.

    10:22:26                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)         Edit ADABAS Pulse Report           Hub Target: 296  
                                                                                   
                                                                                   
                                                                                   
                +-------------------------------------------------------+          
                !                                                       !          
                !   Report Name: .... Adabas Pulse Report               !          
                !   DBID: ........................... _____             !          
                !   Adabas Collection Interval: (mins) ____             !          
                !   Autostarted: ........................ N             !          
                !                                                       !          
                !   Collect History: .................... N             !          
                !   History Interval: (minutes) ...... ____             !          
                !   Repository DBID: ...............  __123             !          
                !   Repository File: ................  __45             !          
                !   Repository Database SVC: ........   234             !          
                +-------------------------------------------------------+          
                                                                                   
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit        Save  Start                               Menu

Creating an Adabas Pulse Report

Start of instruction setTo create an Adabas Pulse Report:

  1. Access the Edit ADABAS Pulse Report screen, as described in Accessing the Edit Adabas Pulse Report Screen.

    The Edit ADABAS Pulse Report screen displays.

    10:22:26                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)         Edit ADABAS Pulse Report           Hub Target: 296  
                                                                                   
                                                                                   
                                                                                   
                +-------------------------------------------------------+          
                !                                                       !          
                !   Report Name: .... Adabas Pulse Report               !          
                !   DBID: ........................... _____             !          
                !   Adabas Collection Interval: (mins) ____             !          
                !   Autostarted: ........................ N             !          
                !                                                       !          
                !   Collect History: .................... N             !          
                !   History Interval: (minutes) ...... ____             !          
                !   Repository DBID: ...............  __123             !          
                !   Repository File: ................  __45             !          
                !   Repository Database SVC: ........   234             !          
                +-------------------------------------------------------+          
                                                                                   
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit        Save  Start                               Menu
  2. Supply values for the following input fields on the Edit ADABAS Pulse Report screen:

    Note:
    You cannot manually specify the name of the Adabas Pulse Report shown in the Report Name field. The Adabas Pulse Report name is generated automatically by Adabas Review when you save the report. It is constructed by combining the words "Adabas Pulse Report" and the database ID of the report. Only one Adabas Pulse Report can be defined for a database.

    Field Specify:
    DBID The database ID of the database on which the report is to run. When a DBID is entered into this field and the report is saved, the DBID is automatically added to the report name.
    Adabas Collection Interval The number of minutes between each report. Report data will be written to the Adabas Review history file once for each interval. The minimum interval is one minute and the maximum is 1440 minutes.
    Autostarted Whether the report should be started when Adabas Review is initialized. Specify "N" if you do not want it autostarted; specify "Y" if you do.
    Collect History Whether history data should be collected. Specify "N" if you do not want history data collected; specify "Y" if you do.
    History Interval The number of minutes between each history data collection.
    Repository DBID The database ID of the database that contains the Adabas Review history file.
    Repository File The file number of the Adabas Review history file.
    Repository Database SVC The SVC currently being used by the Adabas Review history database.
  3. Press PF5 to save your changes to the report; press PF6 to save the report and manually start it.

Editing an Adabas Pulse Report

Start of instruction setTo edit an Adabas Pulse Report:

  1. Locate the report on any of the list function screens (LR, LS, and LH) and enter the ER command in the Sel column associated with the report.

    Or:
    Enter the ER rptname or the EL rptname command on the command line of any screen.

    The Edit Adabas Pulse Report window appears for the report you selected.

  2. Optionally modify the values for the following input fields on the Edit ADABAS Pulse Report screen:

    Note:
    You cannot manually alter the name of the Adabas Pulse Report shown in the Report Name field. The Adabas Pulse Report name is generated automatically by Adabas Review when you save the report. It is constructed by combining the words "Adabas Pulse Report" and the database ID of the report. So if you change the database ID for a field, the report name will change. Only one Adabas Pulse Report can be defined for a database.

    Field Specify:
    DBID The database ID of the database on which the report is to run. When a new DBID is entered into this field and the report is saved, the new DBID automatically replaces the DBID originally included in the report name.
    Adabas Collection Interval The number of minutes between each report. Report data will be written to the Adabas Review history file once for each interval. The minimum interval is one minute and the maximum is 1440 minutes.
    Autostarted Whether the report should be started when Adabas Review is initialized. Specify "N" if you do not want it autostarted; specify "Y" if you do.
    Collect History Whether history data should be collected. Specify "N" if you do not want history data collected; specify "Y" if you do.
    History Interval The number of minutes between each history data collection.
    Repository DBID The database ID of the database that contains the Adabas Review history file.
    Repository File The file number of the Adabas Review history file.
    Repository Database SVC The SVC currently being used by the Adabas Review history database.
  3. Press PF5 to save your changes to the report; press PF6 to save the report and manually start it.

Running an Adabas Pulse Report

To define the Adabas Pulse Report, you choose the DBID where the report will run and the interval (in minutes), as well as some additional settings and information. Only one Adabas Pulse Report may be started per database. In the Adabas Review hub environment, you may have several Adabas Pulse Reports active, but only one for each of the monitored databases.

Start of instruction setTo run an Adabas Pulse Report:

  1. Access the Edit ADABAS Pulse Report screen, as described in Accessing the Edit Adabas Pulse Report Screen, and press PF6.

    Or:
    Start the report as described in Running Reports Online.

    The Adabas Pulse Report is listed as a started report and, after the first collection interval is reached, you can enter the Pulse Statistics screen , as shown below:

    12:18:55                  A D A B A S  -  R E V I E W               2016-03-17
                                   Pulse Statistics                  Target=15690
                                                                           
           
                        Select one Pulse interval and press Enter                 
    +----------------------------------------------------------------------------+
    ! _ 2015-06-18 11:37:54     _ __________ ________      _ __________________  !
    ! _ 2015-06-18 11:41:29     _ __________ ________      _ __________________  !
    ! _ 2015-06-18 12:13:44     _ __________ ________      _ __________________  !
    ! _ 2015-06-18 12:18:33     _ __________ ________      _ __________________  !
    ! _ __________ ________     _ __________ ________      _ __________________  !
    ! _ __________ ________     _ __________ ________      _ __________________  !
    ! _ __________ ________     _ __________ ________      _ __________________  !
    ! _ __________ ________     _ __________ ________      _ __________________  !
    ! _ __________ ________     _ __________ ________      _ __________________  !
    ! _ __________ ________     _ __________ ________      _ __________________  !
    ! _ __________ ________     _ __________ ________      _ __________________  !
    ! _ __________ ________     _ __________ ________      _ __________________  !
    +----------------------------------------------------------------------------+
           
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit                                                  Menu
  2. Selecting a pulse interval line displays an additional Pulse Statistics screen listing details about the pulse interval, as shown below:

    12:18:55                  A D A B A S  -  R E V I E W               2016-03-17
                                   Pulse Statistics                  Target=15690
                                                                           
           
                                              High           Low          Avg      
        Allocated Size ------------------------------------------------------      
                   Format Pool                7600          7600         7600      
                   Work Pool                     0             0            0      
                   Table of ISNs                 0             0            0      
                   Table of Seq Cmds             0             0            0      
                                                                                  
        Allocated Entries ---------------------------------------------------      
                   Attached Buffers              2             2            2      
                   Command Queue                 1             1            1      
                   Hold Queue                    0             0            0      
                   User Queue                    5             5            5      
                                                                                 
        Buffer Efficiency ---------------------------------------------------      
                   Percent                     5.0           5.0          5.0      
                                                                           
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit  Delta                                           Menu
  3. Pressing PF4 (Delta) displays the Delta Statistics screen , as shown below:

    12:18:55                  A D A B A S  -  R E V I E W               2016-06-18
                                   Pulse Statistics                  Target=15690
                                                              
           
                                   Delta Statistics
           
      
    +-----------------------------------------------------------------------+
    !  Buffer Waits                     0      User Commands           22   !
    !  Buffer Flushes                   2      Asso Reads               0   !
    !  Format Overwrites                0      Asso Writes              0   !
    !  Format Translations              0      Data Reads              11   !
    !  System Commands                  2      Data Writes              0   !
    !  Total Commands                  24      Work Reads               0   !
    !  Throwbacks                       0      Work Writes              0   !
    !  Thread Switches                110      Total IOS               11   !
    +-----------------------------------------------------------------------+  
                                                                            
           
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit                                                  Menu

Maintaining Cluster Services Reports

A Cluster Services report displays information about cache and locks in an Adabas Cluster Services environment. Adabas writes the report information directly to the Adabas Review history file. This information is sent to Adabas Review on an interval basis that is chosen when the report definition is created. This feature is only available for the z/OS platforms.

A subtask attached as separate unit of work from the Adabas nucleus address space collects Adabas Cluster Services statistics on a user-specified timer interval. The subtask will calculate the delta of lock and cache statistics over the interval. These delta values will be written directly to the Adabas Review repository file as history data at every interval. The statistics can be viewed and maintained online through the history data menus.

Approximately 2 kilobytes of data will be written to the repository file every interval. For this reason, Software AG recommends that the DBA reexamine and closely monitor the size of this file when the report is running. Minimal data is written for those intervals that have no statistical change. The Cluster Services Report timer interval can be set in the report options and must be specified in minutes. The minimum interval is one minute and the maximum is 1440 minutes (24 hours). Once the report is started, the interval remains in effect until the report is stopped. A new interval can be set prior to restarting the report.

Only one Cluster Services Report may be started per database (cluster). In the Adabas Review hub environment, you may have several Cluster Services Reports active, but only one for each of the monitored databases.

Accessing the Edit Cluster Services Report Screen

Start of instruction setTo access the Edit Cluster Services Report screen:

  1. Enter the EX command on the command line.

    Or:
    Enter the ES command on the command line to access the Specialty Report Types menu.

    10:25:53                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)          Specialty Report Types            Hub Target: 296  
                                                                                   
                                                                                   
                                                                                   
                      Code               Description                               
                      ----     ---------------------------------                   
                       CM           Review Client Management                       
                       EB           Edit Buffer Pool Report                        
                       EC           Edit Client Report                             
                       EL           Edit Pulse Report                              
                       EX           Edit Cluster Services Report                   
                      ----     ---------------------------------                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit                                                  Menu

    Then enter the EX command on the command line.

    The Edit Cluster Services Report screen appears.

    10:26:26                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)        Edit Cluster Services Report        Hub Target: 296  
                                                                                   
                                                                                   
                                                                                   
                +-------------------------------------------------------+          
                !                                                       !          
                !   Report Name: ..... CLUSTER SERVICES REPORT          !          
                !   DBID: ...................... _____                  !          
                !   Interval: (mins) ...........  ____                  !          
                !   Autostarted: ...............     N                  !          
                !                                                       !          
                !   Repository DBID: ........... _____                  !          
                !   Repository File: ...........  ____                  !          
                !   Repository Database SVC: ...   ___                  !          
                !                                                       !          
                +-------------------------------------------------------+          
                                                                                   
                                                                                   
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit        Save  Start                               Menu

Creating a Cluster Services Report

Start of instruction setTo create a Cluster Services Report:

  1. Access the Edit Cluster Services Report screen, as described in Accessing the Edit Cluster Services Report Screen.

    The Edit Cluster Services Report screen displays.

    10:26:26                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)        Edit Cluster Services Report        Hub Target: 296  
                                                                                   
                                                                                   
                                                                                   
                +-------------------------------------------------------+          
                !                                                       !          
                !   Report Name: ..... CLUSTER SERVICES REPORT          !          
                !   DBID: ...................... _____                  !          
                !   Interval: (mins) ...........  ____                  !          
                !   Autostarted: ...............     N                  !          
                !                                                       !          
                !   Repository DBID: ........... _____                  !          
                !   Repository File: ...........  ____                  !          
                !   Repository Database SVC: ...   ___                  !          
                !                                                       !          
                +-------------------------------------------------------+          
                                                                                   
                                                                                   
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit        Save  Start                               Menu
  2. Supply values for the following input fields on the Edit Cluster Services Report screen:

    Note:
    You cannot manually specify the name of the Cluster Services Report shown in the Report Name field. The Cluster Services Report name is generated automatically by Adabas Review when you save the report. It is constructed by combining the words "Cluster Services Report" and the database ID of the report. Only one Cluster Services Report can be defined for a database.

    Field Specify
    DBID The database ID of the database on which the report is to run. When a DBID is entered into this field and the report is saved, the DBID is automatically added to the report name.
    Interval The number of minutes between each report. Report data will be written to the Adabas Review history file once for each interval. The minimum interval is one minute and the maximum is 1440 minutes.
    Autostarted Whether the report should be started when Adabas Review is initialized. Specify "N" if you do not want it autostarted; specify "Y" if you do.
    Repository DBID The database ID of the database that contains the Adabas Review history file.
    Repository File The file number of the Adabas Review history file.
    Repository Database SVC The SVC currently being used by the Adabas Review history database.
  3. Press PF5 to save your changes to the report; press PF6 to save the report and manually start it.

Editing a Cluster Services Report

Start of instruction setTo edit a Cluster Services Report:

  1. Locate the report on any of the list function screens (LR, LS, and LH) and enter the ER command in the Sel column associated with the report.

    Or:
    Enter the ER rptname or the EX rptname command on the command line of any screen.

    The Edit Cluster Services Report window appears for the report you selected.

  2. Optionally modify the values for report on the Edit Cluster Services Report screen:

    Note:
    You cannot manually alter the name of the Cluster Services Report shown in the Report Name field. The Cluster Services Report name is generated automatically by Adabas Review when you save the report. It is constructed by combining the words "Cluster Services Report" and the database ID of the report. So if you change the database ID for a field, the report name will change. Only one Cluster Services Report can be defined for a database.

    Field Specify
    DBID The database ID of the database on which the report is to run. When a DBID is entered into this field and the report is saved, the DBID is automatically added to the report name.
    Interval The number of minutes between each report. Report data will be written to the Adabas Review history file once for each interval. The minimum interval is one minute and the maximum is 1440 minutes.
    Autostarted Whether the report should be started when Adabas Review is initialized. Specify "N" if you do not want it autostarted; specify "Y" if you do.
    Repository DBID The database ID of the database that contains the Adabas Review history file.
    Repository File The file number of the Adabas Review history file.
    Repository Database SVC The SVC currently being used by the Adabas Review history database.
  3. Press PF5 to save your changes to the report; press PF6 to save the report and manually start it.

Maintaining Standard Database and Client Reports

Adabas Review standard database reports and client reports are maintained in very similar fashions, although separate SYSREVDB screens are provided to do so:

  • The standard database report definitions are created using the Edit Report (ER) screen.

  • The client reporting report definitions are created using the Edit Client Report (EC) screen.

These screens provide a series of fill-in-the-blank fields and allow you to access other selection screens to help you select the field information, processing rules, and report option parameters that make up the report definition.

The Edit Report and Edit Client Report screens are used to define field information; that is, the field name and order of selection. If the field type is numeric, you can specify whether the values are to be rounded, totaled, averaged, expressed as a percentage or rate of commands per second, or whether a cost should be calculated for the field. You can also specify that the minimum or maximum values are to be displayed.

Field information may either be entered directly on the screens or selected from additional screens containing lists of fields. You can access a list of field categories using the PF11 key, the FLDS command, or the LF command. After selecting appropriate field categories, a series of additional screens appear from which you can select fields for the report. As you select fields, you can specify the order they appear in the report by typing a number in front of the field. The selected fields are then transferred to the Edit Report or Edit Client Report screen (as appropriate) in the order specified.

New reports can be created from existing reports by editing the original report, changing the name of the report, and saving it under a new name. New reports can also be created by using the Copy Report Definition (CR) command from the List Report Definitions (LR) screen.

This section covers the following topics:

Accessing the Edit Report Screen for Standard Database Reports

Start of instruction setTo access the Edit Report (ER) screen:

  1. Enter the ER command on the command line.

    The Edit Report screen appears.

    10:27:49                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)               Edit Report                  Hub Target: 296  
                                                                                   
    Detail/Summary: S   Report Name: ________________________________   DBID: _____
                                                                                   
    +-----------------------------------------------------------------------------+
    |  Field     Order   Sum   Min   Max   Avg   Pct   Rate      Cost      Round  |
    |-----------------------------------------------------------------------------|
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    +-----------------------------------------------------------------------------+
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help  Optns Exit  SOnly Save  Start  -     +    Sched Rules Flds  Menu

    For more information about the function keys, commands, and input fields available on this screen, read Edit Report and Edit Client Report Screen Function Keys and Commands and Edit Report and Edit Client Report Screen Input Fields.

Accessing the Edit Client Report Screen for Client Reports

Start of instruction setTo access the Edit Client Report (EC) screen:

  1. Enter the EC command on the command line.

    The Edit Client Report screen appears.

    10:28:44                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)            Edit Client Report              Hub Target: 296  
                                                                                   
    Detail/Summary: S   Report Name: ________________________________   DBID: ALL__
                                                                                   
    +-----------------------------------------------------------------------------+
    |  Field     Order   Sum   Min   Max   Avg   Pct   Rate      Cost      Round  |
    |-----------------------------------------------------------------------------|
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    +-----------------------------------------------------------------------------+
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help  Optns Exit  SOnly Save  Start  -     +    Sched Rules Flds  Menu

    For more information about the function keys, commands, and input fields available on this screen, read Edit Report and Edit Client Report Screen Function Keys and Commands and Edit Report and Edit Client Report Screen Input Fields.

    Note:
    For client reports, the DBID default setting is "ALL".

Edit Report and Edit Client Report Screen Function Keys and Commands

The following function keys are provided on the Edit Report and Edit Client Report screens:

Function Key Command Description
PF1 Help Access help for the screen.
PF2 Optns Accesses the Report Options screen, including scheduling definition.
PF3 Exit Exits the screen, returning to the most recently-accessed menu.
PF4 SOnly Saves the current report definition without generating a display program.
PF5 Save Saves the current report definition.
PF6 Start Saves the report defined on the screen and start it.
PF9 Sched Saves the report defined on the screen and schedules it.
PF10 Rules Accesses the Report Processing Rules screen.
PF11 Flds Accesses the Database Fields Selection screens.
PF12 Menu Access the Main Menu.

Edit Report and Edit Client Report Screen Input Fields

The Edit Report and Edit Client Report screens provide the following input fields:

Field Specify: For more information, read:
Report Name A unique name for the report. A maximum of 32 characters is allowed.

Note:
You cannot name a report "ALL".

Specifying the Report Name
DBID to Monitor The DBID of the database where the data is to be collected. Valid values are a valid database ID, the term "ALL" or a blank. Specifying the Report DBID
Field The fields to be selected by the report. A maximum of 20 fields is allowed for each report.

You can also comment out fields in a report.

Specifying Field Names

Commenting Out Fields in a Report

Order For summary reports, the order in which control breaks occur; at least one of the fields selected must be marked as an order field. For detailed reports, the order in which the fields are displayed. Specifying the Field Order
Sum Indicates whether the values for the field are totaled. Specifying Numeric Options for Summary Reports

Numeric Field Calculations

Min Indicates whether the minimum value for the field is displayed.
Max Indicates whether the maximum value for the field is displayed.
Avg Indicates whether the average value is calculated for the field.
Pct Indicates whether the percentage is calculated for the field.
Rate Indicates whether the rate per second is calculated for the field.
Cost The calculation to be used to determine the resource cost for the field. There are two fields on the screen to specify the cost. The first one-byte field specifies the operator for the calculation; the second field specifies the cost factor to be used for the calculation. For more information, read Numeric Field Calculations.

Note:
Costs cannot be calculated for a field unless the values of the field are also totaled (Sum is also specified).

Round The amount by which the values of the field are rounded.

For each report, you can also specify report processing rules (read Using the Report Processing Rules Screen) and report options (read Using the Report Options Screen).

Specifying the Report Name

A report name is required for both standard database reports and client reports; otherwise, the report cannot be saved to the Adabas Review repository. A report name may be up to 32 characters long and must be unique. Alphanumeric and some special characters may be used in report names.

The following list of special characters may not be used in report names:

Character Description
(') Apostrophe
(¢) Cent sign
(:) Colon
(,) Comma
($) Dollar sign
(=) Equal sign
(%) Percent sign
(.) Period
(/) Slash

Specifying the Report DBID

Use this field to identify the database for which the standard database report or the client reporting report is to be created. Valid values are described in the following table:

Value Description
a valid database ID (DBID)

The report runs for the newly-specified database.

A valid database ID is between 1 and 65534. The value zero will be changed automatically to blank.

ALL A DBID=ALL report is triggered.
  • In hub mode, a DBID=ALL report collects data from all databases running on the same SVC as the hub (the databases must have been started with the ADARUN REVIEW parameter set to a hub ID). For such reports, the reporting link is automatically established with Adabas Review. You can specify DBID=ALL for user-defined reports and for most of the predefined Adabas Review reports except for the Buffer Pool reports, the Pulse reports, and the Cluster Services reports.

  • In local mode, a DBID=ALL report collects data only from the local database.

Notes:

  1. Depending on your environment, a DBID=ALL report may initiate communications with many databases, all of which will then send data for the report. If too many databases send too much data at the same time, hub performance problems may result. In such cases, you might consider excluding specific databases from the DBID=ALL report. To do so, define a report processing rule (INCLUDE statement or EQ) that does not include some databases.
  2. Once DBID=ALL reports are started, we do not recommend that you use the REVIEW=hubid operator command to alter the hub ID of an active database. If you do, unpredictable results will occur in the processing of the DBID=ALL reports that have been started.
  3. For client reports, DBID=ALL is the default.
blank If you leave the DBID blank, you will be prompted to enter the DBID when you start the report online via SYSREVDB. Starting such a report via AUTOSTARTED or the Natural batch command START without further specification a DBID=ALL report will be started

Specifying Field Names

Up to 20 fields may be selected for a single database or client reporting report. You may enter field names directly on the appropriate screen or you may select the fields from lists provided on other screens (use PF11 to access these screens). The fields you choose from the screen lists are transferred automatically to the Edit Report or Edit Client Report screen (as appropriate).

A complete list of Adabas Review fields can be found in the Field Reference.

Note:
Alternate field names that you find in the Field Reference cannot be used in SYSREVDB (online) reports. Only field names that are listed on the SYSREVDB screen lists can be used.

You may also comment out fields listed in a report. This is especially useful if you are creating and testing a new report.

Start of instruction setTo select fields for the report from lists of fields:

  1. On the Edit Report or Edit Client Report screen, access the field selection screens by pressing PF11 or by entering the FLDS or LF command without a category code on the command line.

    Note:
    If you know the field category code, you can enter the LF or FLDS command followed by the category name to immediately see the fields in that category. For example, entering "LF NU" will immediately show you a screen displaying the fields in the Adabas Nucleus field category. If you elect to do this, skip this step and Step 2 and proceed with Step 3.

    The Report Field Selection screen appears, listing the field categories appropriate for the type of report. Different field categories are available for standard database reports than are available for client reports.

    For standard database reports, the following Report Field Selection screen appears:

    10:36:06                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)          Report Field Selection            Hub Target: 296                                                                                  
                                                                                   
     
                           Please Mark Categories to Select                        
                                                                                   
                     ADABAS Control Block Fields .............    _                
                     ADABAS Buffer Fields ....................    _                
                     Interval and Time Fields ................    _                
                     ADABAS I/O Fields .......................    _                
                     NATURAL Fields ..........................    _                
                     ADABAS Nucleus Fields ...................    _                
                     Operating System Fields .................    _                
                     Transaction Processing Monitor Fields ...    _                
                     Infrastructure ..........................    _                                                                                                
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
     Command: ______________________________________________________________________
     Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
           Help        Exit                                                  Menu

    For client reports, the following Report Field Selection screen appears:

    10:40:13                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)          Report Field Selection            Hub Target: 296  
                                                                                   
                                                                                   
                           Please Mark Categories to Select                        
                                                                                   
                     ADABAS Control Block Fields .............    _                
                     Interval and Time Fields ................    _                
                     NATURAL Fields ..........................    _                
                     ADABAS Nucleus Fields ...................    _                
                     Operating System Fields .................    _                
                     Transaction Processing Monitor Fields ...    _                
                     Client Reporting Fields .................    _                
                     Infrastructure ..........................    _                                                                                                
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
     Command: ______________________________________________________________________
     Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
           Help        Exit                                                  Menu

    If you need a description of a field category, use the online help system by placing a ? on the line opposite the category name.

    The field categories are also documented in the Field Reference.

  2. Choose the field category or categories containing the fields you want to use by typing an X in the input field associated with the category name. More than one category can be selected at a time

    Field lists for the selected categories are displayed. For example, the following screen shows the fields available for standard database reports in the Natural fields category:

    10:41:15                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)               NATURAL Fields                Hub Target 296  
                                                                                    
     Sel Name     Description                   Sel Name     Description            
     ___ NATAPPL  NATURAL Application ID                                            
     ___ NATCLTID NATURAL Client ID                                                 
     ___ NATCOUNT Call nr for stmt nr                                               
     ___ NATEXEC  NAT EXEC                                                          
     ___ NATGRP   NAT Group                                                         
     ___ NATLEVEL LEVEL OF NATURAL PGM                                              
     ___ NATLIB   NATURAL Library ID                                                
     ___ NATPROG  NATURAL program id                                                
     ___ NATRPCCO NATURAL RPC Conv                                                  
     ___ NATRPCID NATURAL RPC Server                                                
     ___ NATSTMT  NATURAL statement nr                                              
     ___ NATUID   NATURAL userid (*USER)                                            
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
                                                                                    
     Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
           Help        Exit              Accpt                               Menu

    Note:
    The fields available for client reports are not the same as those available for regular database reports. All fields are not available for client reports and client reporting-specific fields are not available for regular database reports.

    If you need a description of a field on any category screen, use the online help system by placing a ? in the Sel column associated with the field name.

    This information is also documented in the Field Reference.

  3. Choose the fields you wish to use on any field selection screen by typing an X in the Sel column associated with the field name.

    You can also specify the field order by typing a number in the Sel column associated with the field name. For more information, refer to the section Specifying Field Order.

  4. After completing your selections for the fields in that category, press PF6 or enter the accept (ACCPT) command to hold your selections temporarily while you continue working on your report.

    If you selected more than one field category in Step 2, the screen of fields for the next field category you selected appears. Use this screen to select fields from the new field category.

    When you have had an opportunity to select fields from all of the categories you selected in Step 2, you are returned to the Edit Report or Edit Client Report screen (as appropriate)with all of your field selections transferred automatically. If you specified a field order, the numbers you entered are listed in the Order column on the Edit Report or Edit Client Report screen.

Commenting Out Fields in a Report

You can comment out fields in a report. This is especially useful while you are creating and testing a new report.

When a field is commented out, data for the field is not collected for the report. However, the field can still be seen in the report definition.

Start of instruction setTo comment out a field in a report:

  1. Type an asterisk (*) as the first character of the field name. If you type the asterisk anywhere else in the field name, errors will result.

    The field is commented out of the report. The next time the report is started, data will not be collected for the field. You must stop and restart the report to see the change.

Start of instruction setTo uncomment a field in a report:

  • Remove the asterisk at the start of the field name.

    The comment for the field is removed. The next time the report is started, data will be collected for the field. You must stop and restart the report to see the change.

Specifying Field Order

The order you specify for fields in your report affects the output differently depending on the type of report:

  • For detailed reports , which are straight recordings of commands processed, the order indicates the order in which the fields are displayed.

  • For summary reports , which display summarized data, the order indicates the order in which control breaks occur (in other words, the order in which the data is summarized). At least one of the fields selected must be marked with an order number. Order numbers are not required for all fields; fields on which calculations are performed (such as a field marked as a SUM field) are generally not used as control breaks.

    For example, in a summary report that displays command name and response code data (in that order), the data is grouped first by command name, and within each command name group, the data is grouped by response code.

    If you add or delete a field, the remaining fields are reordered accordingly.

Start of instruction setTo specify the field order of a report:

  • Type a unique number in the Order column for that field and press Enter.

    Duplicate order numbers are not accepted.

Start of instruction setTo change the field order:

  • Change the order numbers in the appropriate Order columns and press Enter.

    The fields are displayed in the new order.

Specifying Numeric Options for Summary Reports

Note:
These options are valid only for standard database or client reporting summary reports.

Numeric Fields

For the following numeric fields, the order will not affect control break or sort processing:

Option Explanation
Commands The number of commands accounted for in the control break.
Strtdate The date of the first command encountered in the control break.
Strttime The time of the first command encountered in the control break.
Enddate The date of the last command encountered in the control break.
Endtime The time of the last command encountered in the control break.
Seconds The total number of seconds that the account entry has been active.

Read Report Options in Specifying Reporting Options for more information about sorting reports by COMMANDS (USAGE), or by STRTDATE or STRTTIME (DATETIME).

Numeric Field Calculations

For numeric fields with which calculations may be performed (such as number of I/Os or command response time), the following mathematical operations may be performed for each control break on numeric field values:

Operation At each control break, this operation...
Sum Calculates and displays a total of the field's values. When the total of the field's value exceeds the defined field size then Adabas Review will automatically cut the needed positions after the decimal point. In case the field does not have any decimal places or there are no more positions after the decimal point to cut, then the value will be cut and a "K" for thousand or an "M" for million is displayed instead.
Min Displays the minimum value for a field.
Max Displays the maximum value for a field.
Avg Calculates and displays the average value for a field.
Pct Calculates and displays the percentage for a field's values.
Rate

Calculates and displays the rate per second for a field's value.

The number of seconds for this calculation is taken from the number of seconds this specific account entry was active, it is the same number that is displayed in the field SECONDS.

The only exception is if the first account field is either 1M, 5M or 15M. Then the fixed value of either 60 seconds, 300 seconds or 900 seconds is used.

For the Grand Total calculation of current report control break the difference between ENDTIME and STRTTIME is taken.

Cost Calculates and displays the calculated resource costs of the field's values.

Note:
Costs cannot be calculated for a field unless the values of the field are also totaled (Sum is also specified).

Round Rounds the field's values by the amount you specify in this column. A value in this column tells Adabas Review to take the actual field value and increment it by some value so that the result is evenly divisible by the round value.

Start of instruction setTo use the calculation operations:

  1. For all operations except Round and Cost, mark the appropriate column with an X and press Enter.

    Or:
    For the Round option, type a number in the appropriate column and press Enter. For example, to round the Adabas duration up to .05 of a second, type in .05 in the Round column for the DURATION field.

    Or:
    The Cost option consists of two Edit Report screen fields: the first field is a one-character operator field; the second field is a cost factor field used with the operator to calculate the resource cost of the numeric field:

    • The operator for the calculation must be one of the following operators and be specified in the first Cost field (the one-character field): "*" (multiplication), "+" (addition), "-" (subtraction), or "@" (fixed cost). The "@" operator can only be used when the COMMANDS field name is specified in the Field column.

    • The cost factor value is specified in the second Cost field and can be a positive numeric value containing up to four decimal places. These cost factors are multiplied, added, or subtracted from the value of the data field.

    • The COMMANDS field can be used with the "@" (fixed cost) operator and a fixed cost factor to be applied to each command selected by the report. (This is the equivalent of specifying the FIXED keyword in batch reporting).

    Note:
    Costs cannot be calculated for a field unless the values of the field are also totaled (Sum is also specified).

    The following screen shows examples of a report with the following cost fields:

    • The cost factor for the CMDRESP field is determining by multiplying the value of the CMDRESP field by 2.

    • The cost factor of the ASSOIO field is determined by adding 1.5 to the value of the ASSOIO field.

    • A fixed cost (COMMANDS field) of 5.00 is applied to each command selected by the report.

    10:49:19                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)               Edit Report                  Hub Target: 296  
                                                            
    Detail/Summary: S   Report Name: MY REPORT_______________________   DBID: 00559
                                                                                   
    +-----------------------------------------------------------------------------+
    |  Field     Order   Sum   Min   Max   Avg   Pct   Rate      Cost      Round  |
    |-----------------------------------------------------------------------------|
    | CMD_____    10_     _     _     _     _     _     _     _ _______    ______ |
    | FILE____    20_     _     _     _     _     _     _     _ _______    ______ |
    | CMDRESP_    ___     X     _     _     _     _           * 2______    ______ |
    | ASSOIO__    ___     X     _     _     _     _     _     + 1.5____    ______ |
    | COMMANDS    ___     X     _     _     _     _     _     @ 5.00___    ______ |
    | ________    ___     _     _     _     _     _     _     _ _______    ______ |
    | ________    ___     _     _     _     _     _     _     _ _______    ______ |
    | ________    ___     _     _     _     _     _     _     _ _______    ______ |
    | ________    ___     _     _     _     _     _     _     _ _______    ______ |
    | ________    ___     _     _     _     _     _     _     _ _______    ______ |
    +-----------------------------------------------------------------------------+
                                                                                   
    Command: ______________________________________________________________________
                                                                                                       
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help  Optns Exit  SOnly Save  Start  -     +    Sched Rules Flds  Menu

    Note:
    The number of decimal positions shown for a cost field in the output report in SYSREVDB is based on the number of decimal places assigned for the field itself. For example, if the field shows data with four decimal places normally (without the cost option), the cost value (when specified) also shows data with four decimal places.

Using the Report Processing Rules Screen

Report processing rules determine how field values are selected for your standard database and for your client reports. These rules restrict the accumulated data to certain values or conditions. For example, a processing rule can be written to restrict data collection to commands that return a nonzero response code.

Start of instruction setTo access the Report Processing Rules screen:

  1. From the Edit Report or Edit Client Report screen, press PF10; or enter the command RULES on the command line.

    The Report Processing Rules screen appears as shown in the following example:

    10:51:20                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)          Report Processing Rules           Hub Target: 296  
                                                                                   
                                       MY REPORT                                   
    +-----------------------------------------------------------------------------+
    !  Field    Op        Value                                            And/Or !
    !-----------------------------------------------------------------------------!
    ! ________  __  ________________________________________________________  AND !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    +---------------------------------- Page 1 ----------------------------------- 
                                                                                   
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help  Optns Exit  SOnly Save  Start  -     +    Sched       Flds  Menu

    Note:
    For each report, a total of twenty (20) lines are available for processing rules.

    An explanation of the input fields on this screen is provided in the table below:

    Field Explanation
    Field The name of the field for which the restriction applies.

    Note:
    Reporting fields STARTDATE and STARTTIME cannot be used in processing rules.

    Op The conditional operand that specifies how the restriction applies. The following operands may be used:
    • = or EQ: equal to

    • < or LT: less than

    • > or GT: greater than

    • : or NE: not equal to

    Value The field that allows you to restrict the information accumulated by the report to a subset of the values in a particular field. Values may be specified in several formats and may be single values or ranges.
    And/Or Specifies the Boolean operators AND or OR to define the relationship between multiple processing rules.

Guidelines for Specifying Values

The following guidelines describe acceptable ways to specify values in a processing rule:

  • Depending on the field, a value may be numeric or alphanumeric.

  • A value may be specified as a single value, a range of values, or a list of values.

  • When specified as a list, values are enclosed in parentheses and separated by commas; when specified as a range, the two values are enclosed in parentheses and separated by a hyphen.

  • When a hyphen (-) is used as part of a value, the whole value must be enclosed in apostrophes (').

  • When mixed alphanumeric signs are part of a value, the whole value must be enclosed in apostrophes (').

  • For alphanumeric fields, an asterisk (*) may be used to indicate wildcard prefixing and suffixing (see examples below).

  • Values may be expressed in decimal or hexadecimal format. If using hexadecimal format, the value is preceded by an "X" and enclosed in single quotes.

  • The length to be compared in the rule is taken from the field length, not the length of the rule value.

  • When using a wildcard rule value, the length to be compared in the rule is taken from the length of the rule value.

  • Rules cannot be specified for Adabas Buffer Segments fields such as VBSEG01. Use the actual buffer fields instead of the segment fields.

Example Processing Rules

The following table shows examples of processing rules:

Example Explanation
RSP>0 Single numeric value; response code greater than zero.
CMDNAME=FIND Single alphanumeric value; command name equal to FIND.
FNR EQ (10-50) Numeric range value; file number equals 10 to 50.
TRANSID=(BAT1,BAT2,BAT3) Alphanumeric list of values; transaction ID equal to BAT1, BAT2, or BAT3.
JOBNAME=*TEST Use of wildcard prefixing; all job names ending in "TEST".
ACBUSER EQ X'00370014' Use of hexadecimal format; ACBUSER equal to the hexadecimal value 00370014.
NATPROG='N-REVADA' Alphanumeric value with hyphen included

DATE=('2015-06-14'-'2015-06-26') or

DATE=('2015/06/14'-'2015/06/26')

Date value range with hyphen

Entering Processing Rules

Start of instruction setTo complete the Report Processing Rules screen:

  1. If you know which field or fields you plan to use, enter them directly on the screen in the Field column.

  2. To choose fields using the field selection screens, press PF11 or enter the FLDS or LF command on the command line.

    Refer to the section Specifying Field Names for more information.

  3. Enter the appropriate operand, using the guidelines in the tables above.

  4. Enter the appropriate value, using the guidelines and table above.

Using the Report Options Screen

Report options describe additional processing aspects of the standard database and client reports. These include such things as whether the report is a detailed or summary report, whether it will perform physical command logging, and whether the data it collects will be written to the Adabas Review repository and stored as history data.

Adabas Review is delivered with report options defaults:

  • You can modify these defaults for all subsequent reports; or

  • You can modify the default values for a particular report, either new or existing.

The Report Options screen lists the default settings for each option; changes may be made directly on this screen. To access this screen press the PF2 key or enter the OPTNS command on the command line of the Edit Report or Edit Client Report screens.

Note:
One of two different Report Options screens may appear in Adabas Review, depending on whether you have selected a summary report or a detail report. The following sample is for a summary report.

Page 1

10:52:10                  A D A B A S  -  R E V I E W                2020-02-10
REVIEW-DB (10,252)                 MY REPORT                  Hub Target: 296  
                                                                              
+-- Summary Rpt Options ------- Summary Logging ------------ History ---------+
|  AutoStart .......... N    Summary Log ........ N    History ............ N |
|  Break .............. Y    Summary File ... RVSUM    History Int ... ______ |
|  Wrapping ........... N    Num of Logs ....... _2    History DBID ... __123 |
|  Print .............. Y    Log Size ....  __99999    History FNR .... ___45 |
|  Rstrt/Intrvl Y  ______    Log Full Exit ________    History SVC ...... 234 |
|  Max Restarts .. 999999                                                     |
|  Max K ......... _____8    -- Raw Data Output ---    --- Summary Exit ----- |
|  ADALimit ...... _____1    Write Raw Data ..... N    Exit Name ... ________ |
|  Display By ..   SORTED    Write Header ....... N    Cmd ............... CL |
|  Entries ....... 999999    Data Dlmitrs ..... N #    Sum ................ Y |
|  Limit ....... 99999999    Raw Data File .. RAWSM                           |
|  Page/Line .. _55 / 133    Num of Files ...... _2                           |
|                            Log Size ..... ___9999                           |
|                            Switch Exit . ________                           |
+-----------------------------------------------------------------------------+
                                                                               
Command: ______________________________________________________________________
                                                                              
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit              Accpt        +    Dflts             Menu

Page 2 (pressing PF8)

10:52:55                  A D A B A S  -  R E V I E W                2020-02-10
REVIEW-DB (10,252)                 MY REPORT                  Hub Target: 296  
                                                                               
+-- Scheduling Options ------------------------------------------------------ +
|  Scheduling Active .. Y                                                     |
|  Date/Time From ..... 2017-09-28 15:05                                      |
|  Date/Time To ....... 2017-09-29 15:05                                      |
|  Duration ........... 5_____ M (Min/Hour/Day)                               |
|  Interval ........... 1_____ H (Min/Hour/Day)                               |
|                                                                             |
|                                                                             |
|                                                                             |
|                                                                             |
|                                                                             |
|                                                                             |
|                                                                             |
|                                                                             |
|                                                                             |
+-----------------------------------------------------------------------------+
                                                                             
Command: ______________________________________________________________________
                                                                             
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
      Help        Exit              Accpt  -          Dflts PrSet Clear Menu

For detail information about the parameters on the Report Options screen, read Specifying Reporting Options.

Modifying Report Defaults

Adabas Review allows you to modify and save the default report options settings.

After the report options have been modified, all new reports will have report options that default to the new settings. This will affect all new reports created by any user.

Start of instruction setTo modify the report default settings:

  1. Create a new empty report by entering ER on the Adabas Review command line.

  2. Press PF2 or enter the command OPTNS on the command line to display the Report Options screen.

  3. Make any desired changes.

  4. Press PF9 (Dflts) to save the modifications.

    You are returned to the Edit Report screen.

Editing Options for a Particular Report

Start of instruction setTo change the options for a particular report:

  1. Create a new empty report or access and existing report by entering ER on the Adabas Review command line.

  2. Press PF2 or enter the command OPTNS on the command line to display the Report Options screen.

  3. Enter the changes directly on the Report Options screen.

  4. After completing your changes, press PF6 or enter the ACCPT command.

    The ACCPT command stores your selections temporarily while you continue working on your report.

    You are returned to the Edit Report screen.

Editing Existing Reports

Report definitions that have been saved or started may be modified at any time.

Start of instruction set To access a report definition:

  1. If you know the report name, enter the command ER followed by the report name.

    Or:
    If you do not know the report name, access the List Report Definition (LR) function and enter the command ER in the selection column preceding the report name.

    Or:
    If the report has been started, you may use the List Started Report (LS) function and enter the ER command in the selection column preceding the report name.

    Or:
    If the report writes history data to the Adabas Review repository, you may use the List History Reports (LH) function and enter the ER command in the selection column preceding the report name.

    The ER command invokes the Edit Report screen for the specified report. The following example shows the "Commands by Hour" report:

    10:53:47                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)               Edit Report                  Hub Target: 296  
                                                                                   
    Detail/Summary: S   Report Name: COMMANDS BY HOUR________________   DBID: _____
                                                                                   
    +-----------------------------------------------------------------------------+
    |  Field     Order   Sum   Min   Max   Avg   Pct   Rate      Cost      Round  |
    |-----------------------------------------------------------------------------|
    | HOUR____    _10     _     _     _     _     _     _     _ ________   ______ |
    | CMD_____    _20     _     _     _     _     _     _     _ ________   ______ |
    | IOS_____    ___     X     _     _     X     _     _     _ ________   ______ |
    | COMMANDS    ___     X     _     _     _     _     _     _ ________   ______ |
    | CMDRESP_    ___     X     _     _     X     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    | ________    ___     _     _     _     _     _     _     _ ________   ______ |
    +-----------------------------------------------------------------------------+
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help  Optns Exit  SOnly Save  Start  -     +    Sched Rules Flds  Menu

This section covers the following topics:

Changing Field Information

Start of instruction setTo change the field information displayed on the Edit Report screen:

  1. Type over the existing information.

    Note:
    You cannot name a report "ALL".

Start of instruction setTo change or add fields to the report:

  1. You may also use the field selection screens.

    Refer to the section Specifying Field Names for more information.

Start of instruction setTo make additional changes after finishing changes on the Edit Report screen:

  1. You may access the Report Processing Rules screen or the Report Options screen.

Start of instruction setTo finish your changes to the report definition:

  1. Press PF5 or enter the SAVE command on the command line.

Changing Processing Rules

If the report contains processing rules, a message is displayed at the bottom of the Edit Report screen. You may change existing rules or create new rules, if desired.

Start of instruction setTo change processing rules or create new rules:

  1. Display the Report Processing Rules screen by pressing PF10 or entering RULES on the command line.

    10:54:48                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)          Report Processing Rules           Hub Target: 296
                                                                                   
                                   COMMANDS BY HOUR                                
    +-----------------------------------------------------------------------------+
    !  Field    Op        Value                                            And/Or !
    !-----------------------------------------------------------------------------!
    ! ADADURA_  GT  3.0_____________________________________________________  AND !
    ! IOS_____  GT  200_____________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    ! ________  __  ________________________________________________________  ___ !
    +---------------------------------- Page 1 ----------------------------------- 
                                                                                   
                                                                                   
                                                                                   
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help  Optns Exit  SOnly Save  Start  -     +    Sched       Flds  Menu
  2. Change the rules by typing over the existing information; add rules by entering them on the screen.

    For more information, see section Using the Report Processing Rules Screen.

  3. Edit the Report Options screen by pressing PF2 or entering OPTNS on the command line.

    Or:
    If no other changes to the report definition are required, press PF5 or enter SAVE on the command line.

    Or:
    Return to the Edit Report screen by pressing PF3 or entering EXIT on the command line.

Your changes are not deleted unless you exit the Edit Report function without first entering the SAVE command.

Changing Report Options

Start of instruction setTo change report options:

  1. Access the Report Options screen by pressing PF2 or entering OPTNS on the command line.

    10:56:06                  A D A B A S  -  R E V I E W                2020-02-10
    REVIEW-DB (10,252)              COMMANDS BY HOUR              Hub Target: 296
                                                                                  
    +-- Summary Rpt Options ------- Summary Logging ------------ History ---------+
    |  AutoStart .......... Y    Summary Log ........ N    History ............ N |
    |  Break .............. Y    Summary File ... RVSUM    History Int ... _____1 |
    |  Wrapping ........... N    Num of Logs ....... _2    History DBID ... 20000 |
    |  Print .............. Y    Log Size ....  __99999    History FNR .... __149 |
    |  Rstrt/Intrvl Y  _____1    Log Full Exit ________    History SVC ...... 249 |
    |  Max Restarts .. 999999                                                     |
    |  Max K ......... _____8    -- Raw Data Output ---    --- Summary Exit ----- |
    |  ADALimit ...... _____1    Write Raw Data ..... N    Exit Name ... ________ |
    |  Display By ..   SORTED    Write Header ....... N    Cmd ............... CL |
    |  Entries ....... 999999    Data Dlmitrs ..... N #    Sum ................ Y |
    |  Limit ....... 99999999    Raw Data File .. RAWSM                           |
    |  Page/Line .. _55 / 133    Num of Files ...... _2                           |
    |                            Log Size ..... ___9999                           |
    |                            Switch Exit . ________                           |
    +-----------------------------------------------------------------------------+
            
                                                                          
    Command: ______________________________________________________________________
    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
          Help        Exit              Accpt        +    Dflts             Menu
  2. To change the report options, type over the existing information.

    For an explanation of the report options, refer to the section Using the Report Options Screen.

  3. After making changes to the Report Options screen, use either of the following procedures:

    To save the changes temporarily while you make changes to other components of the report, press PF6 or enter ACCPT on the command line.

Saving a Report Definition

Start of instruction setTo save a new or modified report definition:

  1. Press PF5 or enter the SAVE command on the command line.

    When a report definition is saved, it is written to the Adabas Review repository and a Natural display program is generated. For a modified report definition, the existing display program will automatically be overwritten, unless the display program name has been changed to a user-defined display program as described under Changing to a Different Display Program.

    Or:
    Press PF4 (SOnly).

    In this case the report definition is written to the Adabas Review repository, but no Natural display program is generated.

Note:
You cannot name a report "ALL".

Additional information concerning user-defined display program names

When saving a modified report definition it will be checked if the used display program has been renamed to a name which does not begin with SR-*, SX-*, RD-*, RX-*, CR-*, CX*, CS*, PU-* or BUFFERPOOL. For such a user-defined display program a pop-up window will ask for either overwriting the existing display program or generating a new display program.

If you choose the overwrite option, a new program with the existing user-defined program name will be generated. This newly generated program will overwrite the existing code – the previous changes to this program are lost.

If you choose the generate option, a new standard display program with an RD-* (or RX-* for Software AG Editor, if DISPLAY=EDITOR) name will be generated and will then be used. Your user-defined program will still exist, but it will not be used or displayed. If you like to use your user-defined program again you need to change the display program name again, see Changing to a Different Display Program.