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 document 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 | — |
16:40:01 A D A B A S - R E V I E W 2003-07-07
Edit Report HUB=00221
Report Name: SAMPLE SORT DISPLAYS____________ DBID to Monitor:___
+-----------------------------------------------------------------+
| Field Order Sum Min Max Avg Pct Rate Round |
|-----------------------------------------------------------------|
| 15M_____ _1 _ _ _ _ _ _ ______ |
| CMD_____ _2 _ _ _ _ _ _ ______ |
| CMDRESP_ __ X _ _ X _ _ ______ |
| IOS_____ __ X _ _ X _ _ ______ |
| COMMANDS __ X _ _ _ _ _ ______ |
| ________ __ _ _ _ _ _ _ ______ |
+--------------------------- Page 1-------------------------------+
This report contains processing rules
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:
16:42:47 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 ET 0.008320 6 3 0.002773
L6 0.036960 261 9 0.004106
N1 0.232544 540 97 0.002397
S1 0.026304 7 3 0.008768
***** *** 0.304128 814 112 0.002715
16:30 ET 0.028688 22 11 0.002608
L6 0.006640 533 24 0.000276
N1 0.086016 747 168 0.000512
***** *** 0.121344 1302 203 0.000597
***** *** 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 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.
