4. Operation › 4.5 Integrating CA MICS Data to NSM › 4.5.2 Integration with NSM Performance Trend › 4.5.2.2 Performance Trend Inquiry

4.5.2.2 Performance Trend Inquiry

To create a Performance Trend inquiry, complete the following
checklist:

____ 1.  Add a new member in sharedprefix.MICS.PARMS to
         specify what to extract.  See "Parameter
         Specification" for details.

____ 2.  Add a MICF inquiry through the MICF Inquiries panel
         of the CA MICS Workstation Facility (MWF):  (Or you
         can copy an existing Performance Trend inquiry such
         as RMFTD1 or RMFTD2 and modify it.)

         a.  Choose "Structured Inquiry".

         b.  Go to "Data Manipulation", "External File
             Facilities", and choose "External Program
             Invocation".  Enter the following:

             Program Name            ==> BASUCPXT
             CA MICS Library DD NAME ==> SOURCE

             Press END to save.  Press END again until
             you are back to "Structured Inquiry".

         c.  Choose "CA MICS File Selection".  Select the
             CA MICS file, timespan, and optionally,
             cycle(s) and database.  Enter the output file
             name.  It must be the same as the one defined
             in Step 1.  Press END to save.

         d.  Go to "Data Manipulation", "Advanced Data
             Manipulation", and choose "SAS System
             Statement".  Enter the following statement:

             %SELECT;

             Press END to save.  Press END again to return
             to the "Data Manipulation" panel.

         e.  Select "Data Element Derivation" and create a
             new element, DATE, with the following
             attributes for the file defined in Step 2.3:

             Element Name  ===> DATE
                    Label  ===> Date
             Element Type  ===> D
             Value Length  ===> 7
             Output format ===> DATE8.
             Element Derivation:
              ===> DATE = MDY(MONTH,DAY,%YEAR4);

             Press END to save.

         f.  Select "Advanced Data Manipulation" and choose
             "Independent Source Statements".  Create a
             macro %TNGGEN as follows at the "Independent
             Source Statements" panel:

             %MACRO TNGGEN;
                %LET UCPIPARM = xxxxxx;
                %INCLUDE SOURCE(BASUCP)/NOSOURCE2;
             %MEND TNGGEN;
             %TNGGEN;

             where xxxxxx is the member name you defined in
              Step 1.

             Press END to save.

         g.  Save the inquiry.

         You are now ready to run the inquiry.