5. DATABASE FILES › 5.2 SNT Information Area › 5.2.13 CA NetSpy Application (PLU) File (SNTNSP) › 5.2.13.3 Usage Considerations

5.2.13.3 Usage Considerations

This section identifies special considerations or techniques
related to using the SNTNSP File.  In addition, several
retrieval examples are provided to facilitate the use of this
file.


In the examples, a SAS macro variable is used to specify the
DDname part of the CA MICS file name. These macro variables
are a standard part of CA MICS and are available for all
files. The macro variable name has the form &diiit, where d
is the database identifier, iii is the information area
name, and t is the timespan.  For the examples, a database
identifier of P is used.  The identifier is installation
dependent, so you should find out what the identifiers are at
your installation.

Special Considerations/Techniques

1. Care must be exercised in using the special date and time
   data elements contained in each CA MICS file.  As file
   granularity increases in higher timespans, certain fields
   lose significance and should not be used in those cases.

   o HOUR should not be used in MONTHS.
   o DAY and DAYNAME should not be used in WEEKS or MONTHS.
   o WEEKS should not be used in MONTHS.

2. The following data elements are user-defined.  The value
   in each is dependent on user-selected options or
   user-supplied SAS code:

   o NETWRKID - Network Identifier.  A one to eight-character
     descriptive name for each network represented in the
     data.  NETWRKID is set in the Network Identifier Exit
     Routine, SNTNIDRT, discussed in Chapter 7.

   o TMOFFSET - TIME OFFSET applied to the data in the file.
     The user can associate a TIME OFFSET with each unique
     NETWRKID/SYSID combination.  This offset is used to
     adjust data times when data from multiple time zones is
     brought together in the CA MICS database.  To determine
     the original time at which the data was recorded,
     subtract TMOFFSET from the value.  TIME OFFSET is
     assigned in the SNTOPS member of prefix.MICS.PARMS,
     discussed in Chapter 7.

3. The following data elements lose significance once
   summarization has been performed.  These data elements
   should only be referenced when the last observed value in
   a summarization interval is significant.

   NSPYVER  - CA NetSpy Version and Release ID
   TMOFFSET - Time Offset
   NSPACID  - Application CID (network address)
   NSPHSA   - Host Subarea Address (VTAM V3)
   NSPLHRTM - Last Host Response Time
   NSPLNRTM - Last Network Response Time
   NSPRVAL1 - Response Distribution Limits 1
   NSPRVAL2 - Response Distribution Limits 2
   NSPRVAL3 - Response Distribution Limits 3
   NSPRVAL4 - Response Distribution Limits 4

4. Two CA NetSpy Initialization parameters determine the
   values for the elements NSPMXHTM, NSPMXNTM, NSPHRSTM,
   NSPNRSTM, NSPAVHTM, NSPAVNTM, and NSPAVTTM.  These two
   parameters are:

   o HCUTOFF - Host response time cutoff boundary.  CA NetSpy
     discards host response times greater than this boundary.
     This prevents exceptionally long response times from
     skewing the average host response time for the
     application or terminal.

   o NCUTOFF - Network response time cutoff boundary.  CA
     NetSpy discards network response times greater than this
     boundary.  This prevents exceptionally long response
     times from skewing the average network response time for
     the application or terminal.

Retrieval Examples

Chart response time for Primary Logical Unit (PLU) ACICS10.
Break the chart bars into host and network response time.
Use yesterday's data.

       %LET BY = PLU HOUR ;
       %LET BREAK = HOUR ;

       PROC SORT DATA=&PSNTD..SNTNSP01 OUT=WKNSP;
         BY &BY;

       DATA WKNSP;
         SET WKNSP;
         %NSPSUM
       RUN;

       DATA WKNSP;
         SET WKNSP;
         IF PLU='ACICS10';
         RESPONSE=NSPAVNTM; TYPERESP='NETWORK'; OUTPUT;
         RESPONSE=NSPAVHTM; TYPERESP='HOST '; OUTPUT;

       PROC CHART DATA=WKNSP;
         VBAR HOUR / SUMVAR=RESPONSE
                     SUBGROUP=TYPERESP
                     DISCRETE;RUN;