Sorting and matching fault entries

You can use column attributes to display a subset of fault entries that satisfy a given match criteria, such as a similar job name or the same abend code. You can sort the complete list of fault entries or the subset of entries that matches your criteria in ascending or descending order. Matching and sorting column attributes can help you to find faults with a similar pattern, for example, or to collect entries into a contiguous group so that you can delete a range of entries.

To display the Column Attributes, tab to a column heading in the Fault Entry List display, place the cursor on the heading, and press Enter. Use the Column Attributes display to specify the column sort order, the column matching criteria, or both. Initially, the Column Attributes display shows a single match criterion that specifies the default match operator (=) and default match value(*). The default matching criterion matches all entries in the display.

In Figure 1, the Date column is selected.

Figure 1. Sample Column Attributes display with Date column selected

   File  Options  View  Services  Help                                          
 s ┌────────── Column Attributes ───────────┐ ──────────────────────────────────
 I │                                        │                   Line 1 Col 1 80 
 C │ Column Name:                           │                  Scroll ===> CSR  
   │   Date                                 │                                   
 F │                                        │                                   
   │ Sort:                                  │                                   
   │   Enter "/" to select                  │        MD_Pages Abend  Sys/Job  J 
   │      Ascending                         │ :58:57      146 S06F   FAE1     R 
   │      Descending                        │ :16:17      151 S06F   FAE1     R 
   │                                        │ :49:43      145 S06F   FAE1     R 
   │ Match (Date, YYYY/MM/DD): [1]          │ :17:16      198 S06F   FAE1     R 
   │   =  *                                 │ :55:06      361 S0C4   FAE1     S 
   │   +                                    │ :40:11       85 S0C7   FAE1     I 
   │  [2]                                   │ :58:18       81 S0C7   FAE1     I 
   └────────────────────────────────────────┘ :38:17       86 S0C7   FAE1     U 
      F02334 2020/07/23 11:41:55 2020/07/23 11:41:55       80 S0C7   FAE1     I 
      F02333 2020/07/23 11:39:39 2020/07/23 11:39:39       84 S0C7   FAE1     I 
      F02332 2020/07/08 14:58:09 2020/07/08 14:58:09      106 SNAP   FAE1     S 
      F02331 2020/07/08 14:58:07 2020/07/08 14:58:07      106 SNAP   FAE1     S 
      F02330 2020/07/08 14:58:05 2020/07/08 14:58:05      107 SNAP   FAE1     S 
      F02329 2020/07/08 14:58:04 2020/07/08 14:58:04      106 SNAP   FAE1     S

To sort all fault entries in the column, type a forward slash (/) in the ascending or descending attribute input field and press Enter.
To remove fault entries that do not match your criteria from the display, specify your matching criteria and press Enter.
To apply a sort order to the subset of fault entries that match your criteria, specify both your matching criteria and the order in which you want the matching entries sorted, and press Enter.

Match operators

Overtype the default match operator (=) to change it. Valid match operators are:

=: Equal
!=: Not equal
>: Greater than
>=: Greater than or equal to
<: Less than
<=: Less than or equal to

The match operator is restricted to = or != when either of the following is true:

The data type of the column is character.
The match value includes one or more wildcard characters, unless the entire match value is a single * character. See Match values for details about wildcard characters.

Match values

The match value is case-insensitive and can include wildcards:

*: An asterisk represents zero, one, or more characters.
%: A percent sign represents a single character.

The default match value * matches any data value.

When the match value includes wildcard characters, all data types are evaluated as character data, unless the entire match value is a single * character.

The Column Attributes display shows the data type of the selected column in parentheses in the Match header (see [1] in Figure 1). The Match values you supply must be valid for the data type of the column.

Table 1. Data types and values of column attributes
Data type	Valid values
Character	Any character.
Date, `date_format`	When the match value does not include wildcard characters, specify the date as one of the following: Day, month, and year, in locale-specific format. The current date, or a date relative to the current date, by using the `TODAY` keyword. Unless you use the TODAY keyword, the Date match-value must conform to the date format displayed in the Match header, including delimiters (such as the `/` character). `YY` 2-digit year. Values in the range 69-99 refer to years in the twentieth century (1969 to 1999); values in the range 00-68 refer to years in the twenty-first century (2000 to 2068). `YYYY` 4-digit year. `MM` Month (01-12). `DD` Day of the month (01-31). TODAY \| TODAY-`days` The TODAY keyword matches the current date (`TODAY`) or an earlier date, relative to the current date (`TODAY-days`). For example, if the Match header displays the date format as MM/DD/YYYY: `09/27/2020` is an example of a valid match value. `TODAY-2` and `TODAY` are examples of valid match values. `9/27/20` and `09.27.2020` are examples of invalid match values.
Time, `time_format`	When the match value does not include wildcard characters, specify the Time match-value in the format displayed in the Match header, including delimiters (such as the `:` character). `HH` Hours, 12-hour clock (1-12). `hh` Hours, 24-hour clock (0-24). `mm` Minutes (0-59). `ss` Seconds (0-59). `ampm` The locale-specific equivalent of AM or PM (12-hour clock). For example, if the Match header displays the time format as HH:mm:ss ampm `01:25:59 PM` is an example of a valid match value. `13:25:59` is an example of an invalid match value.
Date & Time, `date_format` `time_format`	A combined date and time value. When the match value does not include wildcard characters, specify the date value in the format indicated by the date format in the Match header. The time is optional. If included, specify the time value in the format indicated by the time format in the Match header.
Decimal	Decimal digits 0-9, decimal point period (.) or decimal comma (,) or negative sign (-).
Integer	Decimal digits 0-9 or negative sign (-).
Hex	Hexadecimal digits 0-9 or A-F.
Address	Hexadecimal digits 0-9 or A-F. Optionally, the address can include a single underscore (_) character. If included: Digits to the left of the underscore are right-aligned as bits 0-31 of a 64-bit address. Digits to the right of the underscore are right aligned as bits 32-63 of a 64-bit address. For example: `1_1` is equivalent to address `100000001`.

Using multiple matching criteria

You can specify up to 10 matching criteria per column. A data value must meet all criteria to match (logical AND).

To add matching criteria, position the cursor on the + point-and-shoot field and press Enter. (See [2] in Figure 1.)
To remove match criteria, clear the operator field and press Enter.

Figure 2 shows multiple matching criteria for the Date column.

Figure 2. Sample Column Attributes display specifying multiple matching criteria

   File  Options  View  Services  Help                                          
 ─ ┌────────── Column Attribute ────────────┐ ──────────────────────────────────
 I │                                        │                   Line 1 Col 1 80 
 C │ Column Name:                           │                  Scroll ===> CSR  
   │   Date                                 │                                   
 F │                                        │                                   
   │ Sort:                                  │                                   
   │   Enter "/" to select                  │        MD_Pages Abend  Sys/Job  J 
   │      Ascending                         │ :58:57      146 S06F   FAE1     R 
   │      Descending                        │ :16:17      151 S06F   FAE1     R 
   │                                        │ :49:43      145 S06F   FAE1     R 
   │ Match (Date, YYYY/MM/DD):              │ :17:16      198 S06F   FAE1     R 
   │   >= 2020/07/08                        │ :55:06      361 S0C4   FAE1     S 
   │   <  TODAY-7                           │ :53:33       83 S0C7   FAE1     I 
   │   != *31                               │ :34:40      193 S06F   FAE1     R 
   │   +                                    │ :40:11       85 S0C7   FAE1     I 
   │                                        │ :58:18       81 S0C7   FAE1     I 
   └────────────────────────────────────────┘ :38:17       86 S0C7   FAE1     U 
      F02334 2020/07/23 11:41:55 2020/07/23 11:41:55       80 S0C7   FAE1     I 
      F02333 2020/07/23 11:39:39 2020/07/23 11:39:39       84 S0C7   FAE1     I 
      F02332 2020/07/08 14:58:09 2020/07/08 14:58:09      106 SNAP   FAE1     S 
      F02331 2020/07/08 14:58:07 2020/07/08 14:58:07      106 SNAP   FAE1     S 
      F02330 2020/07/08 14:58:05 2020/07/08 14:58:05      107 SNAP   FAE1     S 
      F02329 2020/07/08 14:58:04 2020/07/08 14:58:04      106 SNAP   FAE1     S

Applying the column attributes

Sorting and matching is applied to the rows of data that are currently displayed. If you change the sort or match values for the same column twice, or for first one column, then another, the second sort or match is applied to the rows of data that are displayed after the first sort or match.

After fault entries that do not match the criteria are removed from the display, you must perform a reset to restore them. You can reset the display by either:

Placing the cursor on the reset point-and-shoot field and pressing Enter.
Entering the RESET command on the command line.

Figure 3 shows a sample result of applying the matching criteria in Figure 2.

Figure 3. Fault entries that match criteria in previous figure

   File  Options  View  Services  Help                                          
 ───────────────────────────────────────────────────────────────────────────────
 IBM Fault Analyzer - Fault Entry List                   13 of 322 rows matched 
 Command ===> ________________________________________________ Scroll ===> CSR                                                   
                                                                                
 Fault History File or View  : 'NWILKES.HIST'                                   
                                                                                
    Fault_ID Date       Time     Date_Time           MD_Pages Abend  Sys/Job  J 
      F60415 2020/08/07 09:55:06 2020/08/07 09:55:06      361 S0C4   FAE1     S 
      F02343 2020/08/04 09:53:33 2020/08/04 09:53:33       83 S0C7   FAE1     I 
      F02342 2020/08/03 15:34:40 2020/08/03 15:34:40      193 S06F   FAE1     R 
      F02340 2020/08/03 09:40:11 2020/08/03 09:40:11       85 S0C7   FAE1     I 
      F02335 2020/07/29 10:38:17 2020/07/29 10:38:17       86 S0C7   FAE1     U 
      F02334 2020/07/23 11:41:55 2020/07/23 11:41:55       80 S0C7   FAE1     I 
      F02333 2020/07/23 11:39:39 2020/07/23 11:39:39       84 S0C7   FAE1     I 
      F02332 2020/07/08 14:58:09 2020/07/08 14:58:09      106 SNAP   FAE1     S 
      F02331 2020/07/08 14:58:07 2020/07/08 14:58:07      106 SNAP   FAE1     S 
      F02330 2020/07/08 14:58:05 2020/07/08 14:58:05      107 SNAP   FAE1     S 
      F02329 2020/07/08 14:58:04 2020/07/08 14:58:04      106 SNAP   FAE1     S 
      F02328 2020/07/08 14:58:02 2020/07/08 14:58:02      106 SNAP   FAE1     S 
      F02327 2020/07/08 12:15:44 2020/07/08 12:15:44      211 S06F   FAE1     R 
                                                                                
 **  Bottom of data.