This document describes the commands you can use to process the results of started reports. It covers the following topics:
The VW command enables you to view the data accumulated by a history report or a report that has been started. The command may be issued from any of the list function screens (LR, LS, and LH).
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:
Enter the command VW on the selection line preceding the name of a history report or a report that has been started.
An example of report results available using the VW command is shown in the Thread Activity screen below:
19:57:10 APPLICATION FILE FIELD USAGE 2009-06-18
19:56:36 2009-06-18 Thru 19:56:43 2009-06-18 HUB=15690
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 |
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.
The VIEW command has within it 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 command on the selection line preceding the name of a started report.
From the display of the report results, press PF2 or 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.
The "Sample Sort Displays" report example illustrates the differences in data presentation that occur when the SORT command is used with the VIEW 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 | — |
20:02:18 A D A B A S - R E V I E W 2009-06-18
Edit Report HUB=15690
Detail/Summary: S
Report Name: SAMPLE SORT DISPLAYS____________ DBID to Monitor: _____
+-----------------------------------------------------------------+
! Field Order Sum Min Max Avg Pct Rate 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 Save Start - + 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:
20:16:51 SAMPLE SORT DISPLAYS 2009-06-18
20:02:01 2009-06-18 Thru 20:15:47 2009-06-18 HUB=15690
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:
16:43:10 SAMPLE SORT DISPLAYS 2003-07-07
16:28:44 04-22-1996 Thru 16:31:06 04-22-1996 LOCL=00009
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:
16:43:21 SAMPLE SORT DISPLAYS 2003-07-07
16:28:44 04-22-1996 Thru 16:31:06 04-22-1996 LOCL=00009
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:
16:43:33 SAMPLE SORT DISPLAYS 2003-07-07
16:28:44 04-22-1996 Thru 16:31:06 04-22-1996 LOCL=00009
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:
16:43:42 SAMPLE SORT DISPLAYS 2003-07-07
16:28:44 04-22-1996 Thru 16:31:06 04-22-1996 LOCL=00009
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:
16:01:50 SAMPLE SORT DISPLAYS 2003-07-07
15:46:24 06-14-1996 Thru 16:01:46 06-14-1996 LOCL=00009
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 reports (LH or LS functions).
To print report results:
Enter the command HC on the selection line preceding the report name.
Notes:
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) or the History Reports screen (LH function).
To download report results:
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 may be purged by issuing the PS command from the Started Reports screen (LS function). The PS command also deactivates the started 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 screen.
Depending on your profile setting, you may be prompted to confirm the purge request.
Confirm the purge request, if required.
