Including additional fields


Almost every VistaPoint view contains more fields than can be displayed on a single screen. Although performance data is collected, the fields displaying this data are not shown in the default views. This section shows how to customize a view to include some fields that are normally excluded.

  1. Display the DSOVER view. If your site does not have BMC AMI Ops Monitor for Db2, use IMS or CICS instead.

    The following figure shows DSOVER with the fields displayed on the default view distributed with VistaPoint:

    08NOV2000----06:59:35 ----------- INFORMATION DISPLAY ---------------------------
    COMMAND ===>                                                SCROLL ===> PAGE
    CURR WIN ===> 1 ALT WIN ===>
    W1 =DSOVER============DB2L=====*========08NOV2000====06:59:34====MVDB2=========5
    CMD Serv  Parm           Avg % Warning  Avg     Avg      Area Count
    --- ----- --------       0.....50...100 Value-- Warning- ---- -----
        @ELTM PAYROLLD  77.4 ***********       0.39     0.50 WKLD     1
        
    DSOPN           24.0 ***              48.00   200.00 DSYS     1
        
    SQLAC            0.5                  13.62  3000.00 USER     1
        
    COMSY                                  0.05          USER     1
        
    THDAC                                  4.00          USER     1
  2. Enter cust to invoke the view customization facility.
  3. Enter E in the OPTIONS field to show the excluded fields of the DSOVER view.

    The following figure shows some of the excluded fields of the DSOVER view. The excluded fields' column headings are colored differently from the fields normally included in the view:

     ------------------------ VIEW CUSTOMIZATION - DSOVER --------------------------
    OPTION ===> E                                              SCROLL ===> CSR
    Options: (that require column selection)    Other options:
    F - Format  M - Move       I - Include      G - Graph       S - Save view
    O - Order   R - Repeat     X - Exclude      P - Parameters  E - Hide excluded
    L - Filter  T - Threshold  H - Hyperlink    Z - Summarize   K - Show template
    ------------------------< Show excluded columns >------------------------------
    The view is now displaying all the excluded (or hidden) columns. Excluded
    columns are marked with highlighted column letters. You can customize an
    excluded column (for instance, place a filter on it). You may also make the
    column permanently displayable by using the Include option.
    If you select E - Hide excluded, the excluded columns will again be hidden.
    -------------------------------------------------------------------------------
        A      B       C       D        E     F              G       H        I
    CMD Serv   SSI      SSI     Parm           Avg % Warning  Avg     Avg      Are
    --- -----  Target   System  --------       0.....50...100 Value-- Warning- ---
       CSAP   DB****** SJS*****         32.2                   43.00    80.00 DMV
       ECSAP  DB****** SJS*****         23.1                   27.00    70.00 DMV
       LOGUT  DB****** SJS*****          7.3                   10.33    85.00 LOG
       CONUT  DB****** SJS***** BATCH    3.7                    5.00    80.00 USE
       THDUT  DB****** SJS*****          2.1                    3.00    85.00 USE
       DSUTL  DB****** SJS*****          0.5                    0.67    85.00 DSY
       EDMUT  DB****** SJS*****          0.2                    0.33    85.00 EDM
       DSOPN  DB****** SJS*****          0.1                   19.67  8000.00 DSY
       DB2DP  DB****** SJS***** DB2      0.0                    0.01  1800.00 DMV
  4. Press your RIGHT key to see more excluded fields beyond the original screen border.In addition to SSI Target and SSI System, as you scroll right, you see the following sequence of normally excluded fields of the DSOVER view:

    I       Area

    J      Count

    K     Description

    L      Application

    M     Max/Min Value

    N     Max/Min Type

    O     Number Samples

  5.  Include the Number Samples field in DSOVER by typing I O.The column heading of the Number Samples field changes color to show that the field is now included.
  6. Enter e to remove the remaining excluded fields.
    After adding the Number Samples field and removing the other fields that you temporarily included, your final DSOVER view should look .

    ------------------------ VIEW CUSTOMIZATION - DSOVER --------------------------
    OPTION ===> E                                               SCROLL ===> CSR
    Options: (that require column selection)   Other options:
    F - Format  M - Move       I - Include     G - Graph       S - Save view
    O - Order   R - Repeat     X - Exclude     P - Parameters  E - Show excluded
    L - Filter  T - Threshold  H - Hyperlink   Z - Summarize   K - Show template
    ------------------------< Hide excluded columns >------------------------------
    The view has now removed all the excluded (or hidden) columns from the display.
    An excluded column that has a filter associated with it will still be used in
    the selection of data to be displayed.
    If you select E - Show excluded, the excluded columns will again be displayed.
    -------------------------------------------------------------------------------
       A     D         E      F              G       H        I     J     O
    CMD Serv  Parm             Avg % Warning  Avg     Avg      Area Count Number
    --- ----- --------         0.....50...100 Value-- Warning- ---- ----- Samples
       CSAP           32.2                     43.00   80.00  DMVS    5   24382
       ECSAP          23.1                     27.00   70.00  DMVS    5   24382
       LOGUT           7.3                     10.33   85.00  LOG     5   24382
       CONUT BATCH     3.7                      5.00   80.00  USER    5   24382
       THDUT           2.1                      3.00   85.00  USER    5   24382
       DSUTL           0.5                      0.67   85.00  DSYS    5   24382
       EDMUT           0.2                      0.33   85.00  EDM     5   24382
       DSOPN           0.1                     19.67 8000.00  DSYS    5   24382

    Do not press your END key yet.

Summary of Steps to Include Additional View Fields

Include additional view fields by performing the following steps:

  1. Display the view for which you want to display additional fields.
  2. Start the view customization facility
  3. Enter e in the OPTION field to show all view fields that are excluded from the current view
  4. Find the column identifier of the view field you want to include in the view
  5. Include the view field by entering Ix, where x is the column indentifier of the field you want to display.
  6. Remove the remaining fields that were not included in the view by entering e again to exclude them.
  7. Press your END key.
  8. Save your changes to the view.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*