5. DATABASE FILES › 5.2 SNT Information Area › 5.2.3 NCP Activity File (SNTNAF) › 5.2.3.3 Usage Considerations

5.2.3.3 Usage Considerations

This section identifies the special considerations or
techniques related to using the SNTNAF file, followed by
several retrieval examples.


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 the
   file's 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 WEEK should not be used in MONTHS.

2. The following data elements are user-defined.  The value
   in each depends 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.  For NPM,
     NETWRKID may be set to the value of PLU Network
     Identifier (PLUNETID).

   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 be referenced only when the last observed value in
   a summarization interval is significant.

   NPMTSFRU - Forward RU Send Time
   NPMTSLOG - Time Record Logged to SMF
   NPMTSEIS - Expected Interval Time
   NETNAME  - Network Name
   RESNAME  - Resource Generic Name

4. The following accumulated data elements exist above the
   detail timespan only for the purpose of recomputing their
   minimum, maximum, or average values at the higher
   timespans.  Do not use these accumulated elements above
   the detail timespan; instead, refer to the minimum,
   maximum, or average values that are derived from them.

   o NAFNRFBQ - Free Buffer Queue Length.  Above detail,
                refer to the elements for minimum, maximum,
                or average free buffer queue length

   o NAFNRHQL - NCP Channel Hold Queue Length.  Above detail,
                refer to the elements for minimum, maximum or
                average channel hold queue length

   o NAFNRIQL - NCP Channel Intermed.  Queue Len.  Above
                detail, refer to the elements for minimum,
                maximum or average channel intermed.  queue
                length

   o NAFNRSFB - Free Buffer Count At Slowdown.  Above detail,
                refer to the elements for minimum, maximum or
                average free buffer count at slowdown

5. If the data source for this file is the CA NetSpy SMF
   Record, then the following element will have missing
   values:

   o NPMTSFRU--Forward RU Send Time

6. Three elements in this file will have missing values,
   unless the data source is the CA NetSpy SMF record. The
   three elements are:

   o NAFCCUSP--CCU Speed
   o NAFNRCYC--Number of CCU Cycles Used
   o NAFTMFCT--Free Cycle Time


Retrieval Examples

1. Produce a chart showing the relationship of productive
   NCP processing time to Free Cycle time and time in
   slowdown.  Use week-to-date data:

     DATA  WKNAF  (KEEP=TIME  TIMETYPE  NCPNAME  ZONE HOUR);
     SET &PSNTW..SNTNAF00;
       TIME=NAFTMFCT;
       TIMETYPE='FREE  TIME';
       OUTPUT;
       TIME=NAFTMTIS;
       TIMETYPE='SLOWDOWN';
       OUTPUT;
       TIME=NPMTMAOT-NAFTMFCT-NAFTMTIS;
       TIMETYPE='PRODUCTIVE';
       OUTPUT;
       RUN;

   PROC  CHART  DATA= WKNAF;
       VBAR  HOUR  /  SUBGROUP=TIMETYPE
                   SUMVAR=TIME
                   DISCRETE;RUN;

2. Produce a chart showing 37xx free cycle time by hour,
   using yesterday's data:

   PROC CHART DATA=&PSNTD..SNTNAF01;
       VBAR  HOUR  /  SUBGROUP=NCPNAME
                   SUMVAR=NAFTMFCT
                   DISCRETE;RUN;