This document describes the commands you can use to process the results of started or scheduled reports. It covers the following topics:
The VW or the
VX command enables you to view the data accumulated
by a history report or a report that has been started or scheduled. The command
may be issued from any of the list function screens (LS, LC, LR and LH).
The VW command starts the traditional
display program generated in report mode. This module may be (re-) generated
when DISPLAY
is set to BASIC.
The VX command starts the display
program generated in structured mode, using the Software AG Editor. This module
may be (re-)generated when DISPLAY
is set to EDITOR. The Software AG Editor offers
extended functionality for browsing and sorting data.
When you issue the VW command, the
display program associated with the report is executed, and the collected data
is displayed online.
To view report results from the report list screen:
Enter the command VW on the
selection line preceding the name of a history report or a report that has been
started.
The results of the report appear. An example of report
results available using the VW command is shown in
the Thread Activity screen below:
11:22:03 APPLICATION FILE FIELD USAGE 2020-02-10
2020-02-10 11:16:01 - 2020-02-10 11:22:02
Page: 1
Total Total Total
NAT-Appl File Fld-Name Num-of-IOs Commands Cmd-Resp
-------- ------ -------- ------------- ------------ --------------
0 0 1 0.001920
50 0 3 0.387072
50 OA 0 3 0.387072
50 OB 0 3 0.387072
50 OC 0 3 0.387072
50 OD 0 3 0.387072
50 OG 0 3 0.387072
50 OH 0 3 0.387072
50 OI 0 3 0.387072
50 OJ 0 3 0.387072
50 OK 0 3 0.387072
50 OL 0 3 0.387072
50 O1 0 3 0.387072
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Sort Exit -- + ===> Menu |
You can scroll forward through the report using the PF8 key. For information on scrolling backwards and forwards through the report data, read Scrolling Through Report Results in Redisplay Mode
When you issue the VX command, the
display program associated with the report is executed, and the collected data
is displayed online.
To view report results from the report list screen:
Enter the command VX on the
selection line preceding the name of a history report or a report that has been
started.
The results of the report appear. An example of report
results available using the VX command is shown in
the Thread Activity screen below:
11:23:44 APPLICATION FILE FIELD USAGE 2020-02-10
2020-02-10 11:16:01 - 2020-02-10 11:23:43 Columns 010 072
=====> Scroll ===> PAGE
***** ****************************** top of data *****************************
00001 -------- ----- -------- ------------ ------------- ------------------- -
00002 Total Total Total
00003 NAT-Appl File Fld-Name Num-of-IOs Commands CMD-Resp
00004 -------- ----- -------- ------------ ------------- ------------------- -
00005 0 0 13 0.003250
00006 7 LL 0 2 0.002750
00007 7 LM 0 9 0.054000
00008 8 LL 0 1 0.001375
00009 8 LM 0 1 0.006000
00010 1007 LC 1 2 0.012000
00011 1007 LG 1 2 0.012000
00012 1007 LL 0 6 0.008250
00013 1007 LM 0 18 0.108000
00014 1008 LM 25 9 0.064625
00015 ******** ***** ******** 27 63 0.272250
00016 DAEFONE 0 0 4 0.001000
00017 1007 LM 0 12 0.072000
00018 1008 LL 0 4 0.005500
00019 1008 LM 0 4 0.024000
00020 ******** ***** ******** 0 24 0.102500
00021 SMART 137 AA 0 2 0.002250
00022 137 AB 0 2 0.002250
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help RVSrt Exit Updat Rfind - + <=== ===> Canc |
You can browse the report using Software AG Editor commands,
e.g. PF7, PF8 or the main commands
TOP, BOT,
+, ++,
-, --. Enter
PF1 to get help about all allowed Editor commands.
Note:
Restrictions apply to the commands that may be issued while
viewing reports. For more information, refer to the
Command
Reference.
When reports have more columns than will fit on a screen, PF10 and PF11 may be used to scroll the display to the left or right. When available, these keys are marked with left and right arrows. PF10 scrolls the display to the left, and PF11 scrolls the display to the right. The first column is repeated on each screen.
In mode DISPLAY=EDITOR it is possible for the user
to define the output format of fields in a report, e.g. to reduce the output
length for a clearly arranged output according to the user’s needs. For more
information refer to section
Display
Programs Using Software AG Editor.
Note:
If you are using an external application, such as a session
manager like Software AG's NETPASS, that assigns PF10 and
PF11 to functions of the external application, you may have problems
viewing report results. If this is the case, you can use PF22
instead to scroll the report results to the left and PF23 instead to
scroll the report results to the right.
You can view more than one report. More than one VW or VX command can be entered at a time on the Report Definitions or Started Reports screens. The reports are opened in the order they appear on the report list screen. You can only view them one at a time; the first report must be closed before the next one can be viewed.
Note:
You cannot view multiple history reports. In other words, you
cannot issue more than one VW or
VX command on the
History
Reports (LH) screen.
To view multiple report results from the report list
screen:
Enter the command VW or VXon the selection line preceding the name of more than one report that has been started.
The results of the first report appear.
When you have finished viewing the results of the first report, press PF3 to close it.
The results of the second report you selected for viewing appear.
Repeat Step 2 until all reports have been viewed and closed.
The numeric field calculation SUM does calculate and display a total of a field´s value.
In case this total value exceeds the size of the numeric field display, the total value will be cut from right.
In case the field value has digits after the decimal point, these digits will be cut.
If digits before the decimal point need to be cut, a K (for 1.000) or M (for 1.000.000) will be printed instead.
When you view report data that spans multiple screens, you can normally only scroll forward through the data. If you need to scroll both backwards and forwards through the data, you must enter redisplay mode.
In redisplay mode, a copy of the most recently-collected data is displayed and is not refreshed until you leave redisplay mode. However, while you are in redisplay mode, Adabas Review continues to collect and summarize data, depending on the report definition and the frequency at which the data for the report changes. So it is possible that the report data you observe in redisplay mode may not match the data you see when you leave redisplay mode.
Note:
After displaying 5000 lines, redisplay mode is disabled for
this view.
To enter redisplay mode and scroll backward and forward through
your report data:
While viewing the report, click PF7 to enter redisplay mode.
The colors of the report on the screen change.
Use the PF7 and PF8 keys to scroll forward and backward through the report data in redisplay mode.
To leave redisplay mode:
Press PF3 to end redisplay mode.
Redisplay mode ends and the next screen of the report (the screen after the one from which you originally entered redisplay mode) appears. If you were on the last screen of the report when you entered redisplay mode, the first screen of the report appears.
The VIEW/VIEWX command comes with a SORT command that enables you to dynamically change the setting of the "Display By" report option.
The following settings are available within the SORT command:
| Setting | Sorts the data in . . . | Display Option |
|---|---|---|
| Account (Ascend) | ascending order by control break | SORTED |
| Number of Commands | descending order by the "Number of Commands" | USAGE |
| First Summary Field | descending order by the first field designated as a summary field in the report definition | SUMFIELD |
| Account (Descend) | descending order by control break | SORTEDDE |
| Date and Time | ascending order by the start date and time of the control break interval | DATETIME |
| Physical Sequence | the physical sequence in which it was collected
Note: |
LINEAR |
This section covers the following topics:
To issue the SORT command:
Enter the VW/VX command on the selection line preceding the name of a started report.
From the display of the report results, press PF2. Using VW, you may also enter SORT on the command line.
A window is displayed, listing the sort options. The option preceded by an arrow (>) is the current sorting sequence report option.
Change the sort option by placing the cursor on your selection and pressing ENTER.
The order of the data in the display is changed according to the sort option you selected.
Note:
Using VX with
the Software AG Editor, you have an additional sort possibility, the Software
AG Editor SORT command. This sort
operates on the data in the editor area and sorts rows according to specified
column and row ranges.
The "Sample Sort Displays" report example illustrates the differences in data presentation that occur when the SORT command is used with the VIEW/VIEWX command. This example collects and calculates the following statistics on Adabas commands:
| Field | Statistic | Designated as the . . . |
|---|---|---|
| 15M | 15 minute interval in which the command was issued | first control break |
| CMD | command code | second control break |
| CMDRESP | total response time for the command | first summary field |
| IOS | total number of I/Os issued by the command | second summary field |
| COMMANDS | total number of commands | third summary field |
| CMDRESP | average response time used per command | — |
| IOS | average number of I/Os issued per command | — |
11:36:34 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: SAMPLE SORT DISPLAYS____________ DBID: _____
+-----------------------------------------------------------------------------+
| Field Order Sum Min Max Avg Pct Rate Cost Round |
|-----------------------------------------------------------------------------|
| 15M_____ _10 _ _ _ _ _ _ _ ________ ______ |
| CMD_____ _20 _ _ _ _ _ _ _ ________ ______ |
| CMDRESP_ ___ X _ _ X _ _ _ ________ ______ |
| IOS_____ ___ X _ _ X _ _ _ ________ ______ |
| COMMANDS ___ X _ _ _ _ _ _ ________ ______ |
| ________ ___ _ _ _ _ _ _ _ ________ ______ |
| ________ ___ _ _ _ _ _ _ _ ________ ______ |
| ________ ___ _ _ _ _ _ _ _ ________ ______ |
| ________ ___ _ _ _ _ _ _ _ ________ ______ |
| ________ ___ _ _ _ _ _ _ _ ________ ______ |
+-------------------------------- Page 1 --------------------------------------+
Command: ______________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Optns Exit SOnly Save Start - + Sched Rules Flds Menu |
Using the "Account (Ascend)" sort option (equivalent to setting the Display By parameter to "SORTED"), the results of the "Sample Sort Displays" report are displayed as follows:
12:40:22 SAMPLE SORT DISPLAYS 2020-02-10
2020-02-10 12:38:38 - 2020-02-10 12:40:21
Page: 1
Total Total Total Avg
Time Cmd Cmd-Resp Num-of-IOs Commands Cmd-Resp
----- --- -------------- ------------- ------------ --------------
20:00 RC 0.005760 0 3 0.001920
S1 0.774144 0 6 0.129024
***** *** 0.779904 0 9 0.086656
20:15 L3 0.838656 0 12 0.069888
RC 0.003840 0 2 0.001920
S1 0.774144 0 6 0.129024
***** *** 1.616640 0 20 0.080832
***** *** 2.396544 0 29 0.082639
***** E N D O F R E P O R T *****
REV00245 - PF-KEY NOT DEFINED
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Sort Exit -- + ===> Menu |
Data is grouped in ascending order by the first control break, the 15M field. Within the hour group, the data is grouped in ascending order by the second control break, the CMD field.
Using the "Number of Commands" sort option (equivalent to setting the Display By parameter to "USAGE"), the results of the "Sample Sort Displays" report are displayed as follows:
12:45:20 SAMPLE SORT DISPLAYS 2020-02-10
2020-02-10 12:38:38 - 2020-02-10 12:45:19
Page: 1
Total Total Total Avg
Time Cmd Response IOs Commands Response
----- --- -------------- ------------- ------------ --------------
16:30 N1 0.086016 747 168 0.000512
16:15 N1 0.232544 540 97 0.002397
16:30 L6 0.006640 533 24 0.000276
16:30 ET 0.028688 22 11 0.002608
16:15 L6 0.036960 261 9 0.004106
16:15 S1 0.026304 7 3 0.008768
16:15 ET 0.008320 6 3 0.002773
***** *** 0.425472 2116 315 0.001350
***** E N D O F R E P O R T *****
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Sort Exit + ===> Menu |
Data is grouped in descending order by the "Number of Commands".
Note:
In Adabas Review, COMMANDS is now a
selectable field. The "Number of Commands" sort option may be used to sort the
display, even if the COMMANDS field is not displayed in
the report.
Using the "First Summary Field" sort option (equivalent to setting the "Display By" parameter to "SUMFIELD"), the results of the "Sample Sort Displays" report are displayed as follows:
12:46:40 SAMPLE SORT DISPLAYS 2020-02-10
2020-02-10 12:38:38 - 2020-02-10 12:46:40
Page: 1
Total Total Total Avg
Time Cmd Response IOs Commands Response
----- --- -------------- ------------- ------------ --------------
16:15 N1 0.232544 540 97 0.002397
16:30 N1 0.086016 747 168 0.000512
16:15 L6 0.036960 261 9 0.004106
16:30 ET 0.028688 22 11 0.002608
16:15 S1 0.026304 7 3 0.008768
16:15 ET 0.008320 6 3 0.002773
16:30 L6 0.006640 533 24 0.000276
***** *** 0.425472 2116 315 0.001350
***** E N D O F R E P O R T *****
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Sort Exit + ===> Menu |
Data is grouped in descending order by the Total Response column, because the CMDRESP field was designated as the first summary field.
Using the "Account (Descend)" sort option (equivalent to setting the Display By parameter to "SORTEDDE"), the results of the "Sample Sort Displays" report are displayed as follows:
12:47:19 SAMPLE SORT DISPLAYS 2020-02-10
2020-02-10 12:38:38 - 2020-02-10 12:47:18
Page: 1
Total Total Total Avg
Time Cmd Response IOs Commands Response
----- --- -------------- ------------- ------------ --------------
16:30 N1 0.086016 747 168 0.000512
L6 0.006640 533 24 0.000276
ET 0.028688 22 11 0.002608
***** *** 0.121344 1302 203 0.000597
16:15 S1 0.026304 7 3 0.008768
N1 0.232544 540 97 0.002397
L6 0.036960 261 9 0.004106
ET 0.008320 6 3 0.002773
***** *** 0.304128 814 112 0.002715
***** *** 0.425472 2116 315 0.001350
***** E N D O F R E P O R T *****
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Sort Exit + ===> Menu |
Data is grouped in descending order by the first control break, the 15M field. Within the 15 minute interval, the data is grouped in descending order by the second control break, the CMD field.
Using the "Date and Time" sort option, the results of the "Sample Sort Displays" report are displayed as follows:
12:47:38 SAMPLE SORT DISPLAYS 2020-02-10
2020-02-10 12:38:38 - 2020-02-10 12:47:37
Page: 1
Total Total Total Avg
Time Cmd Response IOs Commands Response
----- --- -------------- ------------- ------------ --------------
16:15 N1 0.232544 540 97 0.002397
16:15 S1 0.026304 7 3 0.008768
16:15 L6 0.036960 261 9 0.004106
16:15 ET 0.008320 6 3 0.002773
16:30 L6 0.006640 533 24 0.000276
16:30 N1 0.086016 747 168 0.000512
16:30 ET 0.028688 22 11 0.002608
***** *** 0.425472 2116 315 0.001350
***** E N D O F R E P O R T *****
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Sort Exit + ===> Menu |
Data is grouped in ascending order by the start date and time of the control break interval.
Using the "physical sequence" sort option, the results of the "Sample Sort Displays" report are displayed as follows:
12:48:20 SAMPLE SORT DISPLAYS 2020-02-10
2020-02-10 12:38:38 - 2020-02-10 12:48:19
Page: 1
Total Total Total Avg
Time Cmd Response IOs Commands Response
----- --- -------------- ------------- ------------ --------------
15:45 L6 0.008064 123 63 0.000128
E4 0.001344 7 6 0.000224
E1 0.002880 54 12 0.000240
RI 0.000800 0 25 0.000032
CL 0.026160 7 3 0.008720
***** *** 0.583040 4188 7553 0.000077
16:00 S4 0.023760 12 135 0.000176
A1 0.033968 125 193 0.000176
ET 0.003040 85 95 0.000032
L3 0.038560 156 482 0.000080
RC 0.011296 0 706 0.000016
L9 0.006912 22 108 0.000064
S1 0.008832 47 69 0.000128
Command: _____________________________________________________________________
Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
Help Sort Exit + ===> Menu |
Data is grouped in the order of the physical sequence in which it was collected.
The HC command enables you to send report results to a printer, if the hard copy feature of Natural is available. The HC command may be issued from the list of history reports or the list of started or scheduled reports (LH, LS or LC functions).
To print report results:
Enter the command HC on the selection line preceding the report name.
Note:
Using the mode DISPLAY=EDITOR, you
can also enter a printer name. The output will be written to report 1, defined
with the Natural statement DEFINE PRINTER (1) OUTPUT
<printer-id>.
Notes:
DISPLAY=BASIC, this
command requires that you have Entire Connection installed. In mode
DISPLAY=EDITOR, data may be downloaded to a Natural
work file too.
The DL
command enables you to download report output to a personal computer. This
command may be issued from the Started Reports screen
(LS function), the Scheduled
Reports screen (LC function) or the
History Reports screen (LH function).
Using the Software AG Editor the DL command additionally allows you to enter a column delimiter and route the output to a personal computer or to a Natural Work File, specified in CONFIGDB.
To download report results to a PC (work file 7):
Enter the DL command on the selection line preceding the report name.
Entire Connection prompts you for a file name. A default directory name is displayed; you may specify a different directory name, if desired.
Press ENTER to begin the download procedure.
You are notified when the download procedure is completed.
The data downloaded to your personal computer contains only the contents of the fields in the report. The headings and edit masks supplied by the display program do not appear in the downloaded data.
The data accumulated by a report that has been started
or scheduled may be purged by issuing the PS command from the Started
Reports screen (LS
function) or the Scheduled Reports screen (LC
function). The PS command also
deactivates the started or scheduled report so that no further data is
accumulated.
To purge accumulated data:
Enter the PS command on the selection line preceding the report name from the Started Reports or the Scheduled Reports screen.
Depending on your profile setting, you may be prompted to confirm the purge request.
Confirm the purge request, if required.
If a report definition will be changed and saved while the report is running, the definition and the display program may differ from the running report. Before executing a VW/VX command, the running report and saved report definition will be checked. Thus unpredictable errors caused by incompatible data may be avoided.
The check is done by comparing the Account Record Length. For a running report this value is returned from the IN command. For the saved definition this value is calculated. If the calculation is not possible, e.g. because a user-defined variable is missing, the check will be ignored and the VW/VX will be executed without check.
Note:
Since the Account Record Length is not unique, running reports
and the saved definition may differ, although the Account Record Length is
equal.
If the definition and the display program differs from the running report and a REV00525 cones up, refresh the running report and/or regenerate the report and the display program with its original definition.