5. FILES › 5.3 SCP Information Area Files › 5.3.12 Virtual Storage System Usage File (SCPVSM) › 5.3.12.4 Retrieval Examples

5.3.12.4 Retrieval Examples

This section presents typical SCPVSM 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.
1. Display minimum and maximum Common Service Area (CSA)
   usage of virtual storage during the prime zone for each
   day or the past week:

   DATA;
     SET &PSCPD..SCPVSM01 &PSCPD..SCPVSM02
         &PSCPD..SCPVSM03 &PSCPD..SCPVSM04
         &PSCPD..SCPVSM05;
     IF ZONE EQ '1';
   PROC PRINT; VAR SYSID DAY HOUR
     VSMNBCSH VSMNBCSL VSMNCSAH VSMNCSAL
     VSMMBCSH VSMMBCSL VSMMCSAH VSMMCSAL;

2. Display average Common Service Area (CSA) usage of virtual
   storage during yesterday's prime zone for all subpools in
   protect keys 8 through F:

   DATA;
     SET &PSCPX..SCPVSM01;
     IF SYSID EQ 'SYSA'; IF ZONE EQ '1';
   PROC PRINT; VAR SYSID ENDTS
     VSMA8CSH VSMA8CSL VSMA827L VSMA828L
     VSMA831L VSMA841L;