2. Administrative Information Area Files › 2.5 Space Utilization File › 2.5.3 Usage Considerations

2.5.3 Usage Considerations

 
 This section identifies any special considerations or
 techniques related to using the ADMSPC file.  Additionally,
 retrieval examples are provided to facilitate the use of this
 file.  MICF inquiry BASLA5 is also available to report on
 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.  This file is only available at the DAYS timespan.  It
         is sequenced by the SPCRUNTS data element but is not
         summarized.
 
     2.  This file is a spin file.  This means only one cycle
         can exist, so when new observations are added to the
         file, older observations are removed based on the
         SPCUTILLIMIT specified in prefix.MICS.PARMS(EXECDEF).
 
     3.  Each observation is a snapshot of the space used by
         the file type (see SPCTYPE) during the operational
         update job step.  The space utilization of the CA
         MICS database itself is reported prior to cycle
         aging, and may not reflect the space used at the end
         of the step (and job).
 
     Retrieval Examples
 
     1.  Retrieve the work space usage for the DAY030 step
         executed yesterday:
 
         DATA TEMP ;
         SET &PADMD..ADMSPC01;
          IF DATEPART(SPCRUNTS)=TODAY()-1 AND
             LIBNAME =: 'WORK' and SPCSTEP = 'DAY030' ;
         RUN;
         PROC PRINT;
         VAR MICSCOMP SPCSTEP LIBNAME
             SPCALLOC SPCUSED SPCMXUSD SPCPCUSD SPCPCMAX ;
         RUN;
 
     2.  Retrieve all the observations from yesterday and
         order by MICS Component, step and execution
         date/time:
 
         DATA TEMP ;
          SET N0days.ADMSPC01;
           IF DATEPART(SPCRUNTS)=TODAY()-5 ;
         RUN;
         PROC SORT IN=TEMP OUT=SORTED ;
           BY MICSCOMP SPCSTEP descending spcrunts ;
         RUN;
         PROC PRINT;
         VAR MICSCOMP SPCSTEP SPCRUNTS LIBNAME
             SPCALLOC SPCUSED SPCMXUSD SPCPCUSD SPCPCMAX ;
         RUN;