Sorting View Data
Sorting arranges rows of view data in either numerical or alphabetical order. You can sort in either ascending or descending order. By default, numerical data is sorted in descending order. The default for character data is ascending order, A through Z.
You select a field within a view as the basis for your sort. Depending on the type of data in the field you select, view rows are sorted either alphabetically or numerically.
This section sorts 78 rows of an ISERV view. You will sort the rows in ascending and descending order by the Avg % Warning field.
Display your ISERV view. If your site does not have BMC AMI Ops Monitor for IMS installed, us BMC AMI Ops Monitor for CICS or BMC AMI Ops Monitor for Db2 instead.
ISERV View with Rows Sorted in Descending Order shows an example of the first screen of an ISERV view. Toward the right, the window information line shows that the view has 78 rows of data. Your view, of course, reflects the number of active monitors in the context of your view.08NOV2000 13:37:16 ----------- INFORMATION DISPLAY ---------------------------
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
>W1 =ISERV=============ALL======*=========08NOV2000====13:36:52=MVIMS========78===
CMD Serv Parm % Warning Curr Warn Area Target
--- ---- ------- 0.......50.....100 Value- Value- ------ ------
LGMSG 134.0 *****************+ 88.00 80 00 STOR IMSA
#PROC FINANCE 150.0 *****************+ 1.00 50.00 WKLD IMSA
LGMSG 122.4 *****************+ 88.00 80 00 STOR IMSB
@RESP PAYROLL 119.0 ************* 1.18 1.50 WKLD IMSB
@RESP PAYROLL 116.9 ************* 1.18 1.50 WKLD IMSA
DBIO 70.0 ************ 56.00 80.00 STOR IMSA
@RESP WPAYROLL 50.0 ********* 212.00 425.00 WKLD IMSA
ECSAT 10.0 ** 9.00 90.00 STOR IMSA
DBIO 70.0 ************ 56.00 80.00 STOR IMSA
@RESP WPAYROLL 50.0 ********* 212.00 425.00 WKLD IMSA
ECSAT 10.0 ** 9.00 90.00 STOR IMSA
@RESP PAYROLL 75.0 ************* 1.18 1.50 WKLD IMSA
DBIO 70.0 ************ 56.00 80.00 STOR IMSA
@RESP WPAYROLL 50.0 ********* 212.00 425.00 WKLD IMSA
ECSAT 10.0 ** 9.00 90.00 STOR IMSA
ECSAT 10.0 ** 9.00 90.00 STOR IMSA
ECSAT 10.0 ** 9.00 90.00 STOR IMSA
#PROC FINANCE 1.0 1.00 100.00 WKLD IMSA- Type SOrt a but do not press Enter.
Move the cursor over the Avg % Warning field and press Enter.
ISERV View Sorted in Ascending Order by Percentage Warning Threshold shows the same ISERV view after you have sorted the rows in ascending order by the values shown in the Avg % Warning field.08NOV2000 13:37:16 ----------- INFORMATION DISPLAY ---------------------------
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
>W1 =ISERV=============ALL======*=========08NOV2000====13:36:52=MVIMS========78===
CMD Serv Parm % Warning Curr Warn Area Target
--- ---- ------- 0.......50.....100 Value- Value- ---- --------
#PROC FINANCE 1.0 1.00 100.00 WKLD IMSA
#PROC FINANCE 1.0 1.00 100.00 WKLD IMSB
ECSAT 5.0 * 9.00 90.00 STOR IMSA
ECSAT 7.0 * 9.00 90.00 STOR IMSB
ECSAT 8.9 ** 9.00 90.00 STOR IMSC
ECSAT 9.3 ** 9.00 90.00 STOR IMSF
DBIO 9.5 ** 56.00 80.00 STOR IMSA
ECSAT 10.2 ** 9.00 90.00 STOR IMSG
@RESP WPAYROLL 50.0 ********* 212.00 425.00 WKLD IMSB
@RESP WPAYROLL 52.4 ********* 212.00 425.00 WKLD IMSC
DBIO 63.0 ************ 56.00 80.00 STOR IMSA
@RESP PAYROLL 64.9 ************ 1.18 1.50 WKLD IMSG
@RESP WPAYROLL 66.0 ************ 212.00 425.00 WKLD IMSA
DBIO 70.0 ************* 56.00 80.00 STOR IMSA
DBIO 70.0 ************* 56.00 80.00 STOR IMSB
@RESP PAYROLL 75.0 ************* 1.18 1.50 WKLD IMSB
@RESP PAYROLL 75.0 ************* 1.18 1.50 WKLD IMSA
LGMSG 76.4 ************** 88.00 80 00 STOR IMSBAlthough you can sort rows by any view field, you should restrict your sorts to only those fields whose values have the same meaning for every monitor shown in the view. It does not make sense to sort on the Curr Value field because different monitors collect data whose values are unrelated to each other. The @RESP monitor's response time in milliseconds is unrelated to the DBIO monitor's count of IMS database I/Os.
- Enter Order d but do not press Enter.
Move the cursor over the Avg % Warning field and press Enter.
You should see the rows of the ISERV view sorted in descending order by the values shown in the Avg % Warning field.Move the cursor over the Avg % Warning field and press your HELP key.
You should see a pop-up help window that describes the Avg Warning field, as shown below. Find the sentence that gives the element name of the Avg % Warning field. Scroll forward if you do not see it in the first help screen. MONIPWRN is the element name of the Avg % Warning field.Help Interval Percent Warning Help
Command ==> Scroll ==> CSR
--------------------------------------------------
The Interval Percent Warning field displays the
percentage of the warning threshold set for the
data displayed on the view row.
The field displays the percent warning for data
collected over the current interval.
The element name for this field is MONIPWRN.
There are no hyperlinks defined for this element.
There are no filters defined for this element.
There are no thresholds defined for this element.- Close the Help window; type SOrt monipwrn.a.
The rows of the ISERV view are sorted in ascending order by the values shown in the Avg % Warning field. In this form of the SOrt and Order commands, you select the sort field by its element name.
Summary of Sort Commands
The SOrt and Order commands can be issued two ways:
- Type SOrt or Order A|D in the COMMAND line, position the cursor over the sort field, and press Enter.
- Specify the SOrt or Order command with the element name and either the A or D parameter in the following format:
SOrt element_name[A | D]
Related topic