5. DATABASE FILES › 5.4 TCP Information Area › 5.4.11 Storage Statistics File (TCPSTG) › 5.4.11.3 Usage Considerations

5.4.11.3 Usage Considerations

This section identifies special considerations or techniques
related to using the TCPSTG file and provides a retrieval
example.


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. The Storage Statistics (TCPSTG) file provides information
   to analyze ECSA and authorized private storage used by the
   TCP/IP address space. Shortages of storage available for
   TCP/IP address space during peak times can be critical to
   business.


2. 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.

3. 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.

   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.

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

   TCPIPTYP - TCP/IP Type
   TCPSOCID - TCP Socket Resource ID
   TCPVRRL  - z/OS CS TCP/IP Version/Rel.
   TCPUID   - User ID

Retrieval Example
-----------------

Chart prime shift storage used for sysid PROD.  Use
yesterday's data.

   DATA SELECTED (KEEP=SYSID TCPSTACK DAY ZONE HOUR UDIDREC);
     SET &TCPD..TCPSTG01;
     IF SYSID = 'PROD';
     IF 9 GE HOUR LE 17; /* SELECT PRIME SHIFT */
   RUN;

   PROC CHART DATA=SELECTED;
        BY SYSID TCPSTACK;
        VBAR HOUR / SUMVAR=STGECSAU SUBGROUP=TCPSTACK
        DISCRETE;
   TITLE1 'DAYS TCPSTG01, PRIME SHIFT - TCP/IP STORAGE USED';
   RUN;