Previous Topic: 3.3.1.5.6 TCP/IP Monthly Bytes Trans./Zone (CSV)Next Topic: 4. EXCEPTION REPORTING


3.3.2 How to Modify Standard MICF Inquiries


See the MICF Tutorial in the MICF User Guide for information
on modifying cataloged inquiries.

You may want to tailor the distributed MICF inquiries for
your installation, and particularly to change the labels of
subtitle headings for the distributed inquiries for files
with user-defined account codes in the NVS Information Area
(for example, NVSRTM and NVSNSA).  The inquiries for these
files generate graphs or reports for the value of each
account code.  The account codes are labeled on the graphs by
generic name (for example, SNTACT1).  The inquiry SNTCDF, for
example, provides a stacked vertical bar chart of data
character traffic (by direction) for each unique value of
SNTACT1 in the NVSNSA File if your installation has assigned
a specific network component type, such as primary logical
unit (PLU), to be the value of SNTACT1.  The procedure below
identifies the steps you must follow to change titles and
subtitles to reflect your installation's choice for SNTACT1.
Assuming that SNTACT1 contains PLU, this procedure shows you
how to change SNTACT1 to PLU.

 1 - Determine the value assigned to SNTACT1 at your site by
     referring to the NVSNSA data element list in Chapter 5.
     Verify with your CA MICS System Administrator that the
     value is correct.

 2 - Copy the inquiry from the MICF shared catalog to your
     private catalog and change the inquiry name.  (See
     Figure 3-36.)

 3 - For this example, we have changed the inquiry's name
     to SNT001.  Enter the author's name.  Change the title
     to NetView Daily Chars/1000 by PLU by overkeying the
     current title.  (See Figure 3-36A.)

 4 - Select Modify Mode by typing MODIFY in the Select Mode
     field.  Select the new inquiry by typing an S opposite
     the name of the inquiry you want to modify.  (See
     Figure 3-36B.)

 5 - Select Color Vertical Bar Chart by typing an S
     opposite that field.  (See Figure 3-36C.)

 6 - Enter a Y in the extended options field at the bottom
     of the screen.  Change the report title to NetView
     Daily Chars/1000 by PLU by overkeying the current
     title.  (See Figure 3-36D.)

 7 - Enter a Y opposite the Specify Subheading Text and
     Data Formats field.  (See Figure 3-36E.)

 8 - Type PLU in the Subheading Text field for the element
     SNTACT1.  (See Figure 3-36F.)

 9 - Type END at the command prompt, pressing ENTER until
     you return to the MICF Inquiry Step Display screen.
     At the command prompt, type V and press ENTER to
     validate the inquiry that you just created.  (See
     Figure 3-36G.) The message 'Inquiry Validated' will
     appear in the upper righthand corner of the screen
     (not shown).

10 - Type END at the command prompt and you will be
     prompted by the Active Inquiry Save Confirmation
     screen to 'Press ENTER key to save the current, active
     MICF Inquiry'.  Press ENTER and you will return to the
     Data Base Inquiries screen.  (See Figure 3-36H.)

11 - Select Execute Mode by typing EXECUTE in the Select
     Mode field, then type an S opposite the inquiry that
     you just created and modified to execute it.  (See
     Figure 3-36I.)


 /-------------------------------------------------------------------------------\
 |----------------------------  Data Base Inquiries  ----------------------------|
 |Command ===>                                                  Scroll ===> PAGE |
 |                                                                               |
 |Catalog     ===> SHARED  (PRIVATE/SHARED)  Catalog Group         ===> *        |
 |Select Mode ===> EXECUTE (EXECUTE/MODIFY)  Name (subset display) ===> ________ |
 |                                                                               |
 |Line Cmds: S Select  I Insert   R Repeat  C Copy  D Delete                     |
 |                                                                               |
 |Cmd   Name                   Title                       Date     Time         |
 | -   ------  ----------------------------------------  ---------  -----        |
 | -   SNTCDC  NetView Daily Connect Time by SNTACT1     87/05/08   17:00        |
 | C   SNTCDD  NetView Daily Chars/1000 by SNTACT1       87/05/08   17:05        |
 | -   SNTCDE  NetView DAily Chars/1000 by VR            87/05/08   17:10        |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |****************************** BOTTOM OF DATA *********************************|
 [assign the value for vfor in your book]-------------------------------------------------------------------------------[assign the value for vinf in your book]


 Figure 3-36.  Copying an Inquiry to a Private Catalog

 /-------------------------------------------------------------------------------\
 |----------------------------  Inquiry Repeat/Copy  --------------- Copy Inquiry|
 |Command ===>                                                                   |
 |                                                                               |
 |Catalog:  SHARED                                                               |
 |                                                                               |
 |     Inquiry Name   ===> SNT001                                                |
 |             Title  ===> NetView Daily Chars/1000 by PLU                       |
 |             Author ===> Your Name                                             |
 |                                                                               |
 |Catalog Group Name  ===> WORKLOAD                                              |
 |              Title ===> Workload Analysis                                     |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |Press ENTER to add the new inquiry to your private inquiry catalog.            |
 |or                                                                             |
 |Press END to cancel.                                                           |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 [assign the value for vfor in your book]-------------------------------------------------------------------------------[assign the value for vinf in your book]


 Figure 3-36A.  Adding an Inquiry to a Private Library

 /-------------------------------------------------------------------------------\
 |----------------------------  Data Base Inquiries  ----------------------------|
 |Command ===>                                                  Scroll ===> PAGE |
 |                                                                               |
 |Catalog     ===> PRIVATE (PRIVATE/SHARED)  Catalog Group         ===> *        |
 |Select Mode ===> MODIFY  (EXECUTE/MODIFY)  Name (subset display) ===> ________ |
 |                                                                               |
 |Line Cmds: S Select  I Insert   R Repeat  C Copy  D Delete                     |
 |                                                                               |
 |Cmd   Name                   Title                       Date     Time         |
 | -   ------  ----------------------------------------  ---------  -----        |
 | S   SNT001  NetView Daily Chars/1000 by PLU           87/05/08   17:05        |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |****************************** BOTTOM OF DATA *********************************|
 [assign the value for vfor in your book]-------------------------------------------------------------------------------[assign the value for vinf in your book]


 Figure 3-36B.  Selecting an Inquiry for Modification

 /-------------------------------------------------------------------------------\
 |-------------------------  MICF Inquiry Step Display  -------------------------|
 |Command ===>                                                  Scroll ===> CSR  |
 |                                                                               |
 |Modifying CA MICS Inquiry: SNT001 - NetView Daily Chars/1000 by PLU            |
 |                                                                               |
 |Execute the Inquiry in ===> FOREGROUND (BATCH/FOREGROUND) Mode ===> N (Y/N)    |
 |                                                                               |
 |Line Cmds: S Select  I Insert  D Delete  M Move  R Repeat  C Copy              |
 |                                                                               |
 |Cmd                         Inquiry Step                           Input File  |
 | -   ------------------------------------------------------------  ----------- |
 | _   CA MICS File Selection                                        DAYS NSC    |
 | _   Common Data Selection - Select Previous Day                   FILE1       |
 | _   Execution-Time Data Selection - Select NETWRKID               FILE1       |
 | _   Execution-Time Data Selection - Select SYSID                  FILE1       |
 | _   Execution-Time Data Selection - Select SNTACT1                FILE1       |
 | _   Data Element Derivation - Characters/1000                     FILE1       |
 | S   Color Vertical Bar Chart - Characters/1000 by HOUR            FILE1       |
 |                                                                               |
 |****************************** BOTTOM OF DATA *********************************|
 [assign the value for vfor in your book]-------------------------------------------------------------------------------[assign the value for vinf in your book]


 Figure 3-36C.  Selecting an Inquiry Step for Modification

 /-------------------------------------------------------------------------------\
 |---------------------------  Color Vertical Bar Chart  ------------------------|
 |Command ===>                                                                   |
 |Enter a ? in any data entry field for more information on valid values.        |
 |Modifying CA MICS Inquiry: SNT001 - NetView Daily Chars/1000 by PLU            |
 |Inquiry Step ===> Color Vertical Bar Chart - Chars/1000 by HOUR                |
 |Input File   ===> FILE1    - Intermediate File Number 1    (From:  DAYS NSC   )|
 |Report Title ===> NetView Daily Chars/1000 by PLU                              |
 |                                                                               |
 |Chart of      ===> CHARS    (Y-Axis)   Grouped by  ===>          (Element)     |
 |Charted by    ===> HOUR     (X-Axis)   Weighted by ===> ________ (Element)     |
 |Type of Chart ===> SUM  (SUM/MEAN/FREQ/PCT)                                    |
 |                                                                               |
 |Generate Graph for Each Value of   ===>     NETWRKID _ SYSID___ _ SNTACT1_ _   |
 |________ _ ________ _ ________ _ ________ _ ________ _ ________ _ ________ _   |
 |                                                                               |
 |Graph a Discrete X-Axis   ===> Y (Y/N)  X-Axis Bar Size Sequence  ===> _ (A/D) |
 |Graph Cumulative Values   ===> N (Y/N)                                         |
 |                                                                               |
 |                                                                               |
 |Specify Extended Options ===> Y (Y/N)  ** Specified **                         |
 [assign the value for vfor in your book]-------------------------------------------------------------------------------[assign the value for vinf in your book]


 Figure 3-36D.  Specifying Extended Options

 /-------------------------------------------------------------------------------\
 |---------------------------  Extended Options Menu  ---------------------------|
 |Command ===>                                                                   |
 |                                                                               |
 |Inquiry Step:  Color Vertical Bar Chart - Characters/1000 by HOUR              |
 |Input File:    File1 - Intermediate File Number 1 (From:  DAYS NSC)            |
 |                                                                               |
 |Specify Data Element Labels and Formats      ===> N (Y/N/R)  ** Specified **   |
 |Specify Subheading Text and Data Formats     ===> Y (Y/N/R)  ** Specified **   |
 |Specify Axis Scale                           ===> N (Y/N/R)  ** Specified **   |
 |Specify Reference Lines                      ===> N (Y/N/R)                    |
 |Specify Chart Group Values                   ===> N (Y/N/R)                    |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |Begin Chart With Record Number ===> ________   Stop After ===> _______ Records |
 [assign the value for vfor in your book]-------------------------------------------------------------------------------[assign the value for vinf in your book]


 Figure 3-36E.  Selecting a Specify Option

 /-------------------------------------------------------------------------------\
 |-------------------------Subheading Text and Data Formats----------------------|
 |Command ===>                                                                   |
 |                                                                               |
 |Inquiry Step:  Color Vertical Bar Chart - Characters/1000 by HOUR              |
 |Input File:    File1 - Intermediate File Number 1 (From:  DAYS NSC)            |
 |                                                                               |
 |  Element           Subheading Text                   Output Format            |
 |  ________  _______________________________________  _______________           |
 |  NETWRKID  N                                        $CHAR8.                   |
 |  SYSID     S                                        $CHAR4.                   |
 |  SNTACT1   PLU                                                                |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 [assign the value for vfor in your book]-------------------------------------------------------------------------------[assign the value for vinf in your book]


 Figure 3-36F.  Specifying Subheading Text in Extended Options

 /-------------------------------------------------------------------------------\
 |-------------------------  MICF Inquiry Step Display  -------------------------|
 |Command ===> V                                                Scroll ===> CSR  |
 |                                                                               |
 |Modifying CA MICS Inquiry: SNT001 - NetView Daily Chars/1000 by PLU            |
 |Inquiry validation is required.  Enter VALIDATE to validate the inquiry.       |
 |Execute the Inquiry in ===> FOREGROUND (BATCH/FOREGROUND) Mode ===> N (Y/N)    |
 |                                                                               |
 |Line Cmds: S Select  I Insert  D Delete  M Move  R Repeat  C Copy              |
 |                                                                               |
 |Cmd                         Inquiry Step                           Input File  |
 | -   ------------------------------------------------------------  ----------- |
 | _   CA MICS File Selection                                        DAYS NSC    |
 | _   Common Data Selection - Select Previous Day                   FILE1       |
 | _   Execution-Time Data Selection - Select NETWRKID               FILE1       |
 | _   Execution-Time Data Selection - Select SYSID                  FILE1       |
 | _   Execution-Time Data Selection - Select SNTACT1                FILE1       |
 | _   Data Element Derivation - Characters/1000                     FILE1       |
 | _   Color Vertical Bar Chart - Characters/1000 by HOUR            FILE1       |
 |                                                                               |
 |****************************** BOTTOM OF DATA *********************************|
 [assign the value for vfor in your book]-------------------------------------------------------------------------------[assign the value for vinf in your book]

 Figure 3-36G.  Validating a Modified Inquiry

 /-------------------------------------------------------------------------------\
 |----------------------  Active Inquiry Save Confirmation  ------ Confirm Save. |
 |Command ===>                                                                   |
 |                                                                               |
 |                                                                               |
 |   Active MICF Inquiry:  SNT001 - NetView Daily Chars/1000 by PLU              |
 |                Author:           Your Name                                    |
 |                                                                               |
 |                                                                               |
 |   Do you wish to save the current, active MICF Inquiry? ===> YES (YES/NO)     |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |Instructions:                                                                  |
 |                                                                               |
 |   Press ENTER  key to save the current, active MICF Inquiry.                  |
 |                                                                               |
 |   Reply NO and press ENTER key to delete the current, active inquiry.         |
 [assign the value for vfor in your book]-------------------------------------------------------------------------------[assign the value for vinf in your book]


 Figure 3-36H.  Saving a Modified Inquiry

 /-------------------------------------------------------------------------------\
 |----------------------------  Data Base Inquiries  ----------------------------|
 |Command ===>                                                  Scroll ===> PAGE |
 |                                                                               |
 |Catalog     ===> PRIVATE (PRIVATE/SHARED)  Catalog Group         ===> *        |
 |Select Mode ===> EXECUTE (EXECUTE/MODIFY)  Name (subset display) ===> ________ |
 |                                                                               |
 |Line Cmds: S Select  I Insert   R Repeat  C Copy  D Delete                     |
 |                                                                               |
 |Cmd   Name                   Title                       Date     Time         |
 | -   ------  ----------------------------------------  ---------  -----        |
 | S   SNT001  NetView Daily Chars/1000 by PLU           87/05/08   17:05        |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |                                                                               |
 |****************************** BOTTOM OF DATA *********************************|
 [assign the value for vfor in your book]-------------------------------------------------------------------------------[assign the value for vinf in your book]


 Figure 3-36I.  Selecting a Modified Inquiry for Execution