5. FILES › 5.3 SCP Information Area Files › 5.3.13 Virtual Storage Private Usage File (SCPVSU) › 5.3.13.4 Retrieval Examples

5.3.13.4 Retrieval Examples

This section presents typical SCPVSU 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 maximum usage of virtual storage for the user
   region and the combined area of LSQA, SWA, Subpool 229 and
   Subpool 230, during the prime zone during the past week of
   program PGMNM018:

   DATA;
     SET &PSCPD..SCPVSU01 &PSCPD..SCPVSU02
         &PSCPD..SCPVSU03 &PSCPD..SCPVSU04
         &PSCPD..SCPVSU05;
     IF ZONE EQ '1' AND PROGRAM EQ 'PGMNM018';

   PROC PRINT; VAR SYSID DAY HOUR
     VSUMAUSH VSUMAUSL VSUMALSH VSUMALSL;

2. Display average usage of virtual storage, by subpool,
    during the prime zone yesterday by program PGMBZZZY:

   DATA;
     SET &PSCPD..SCPVSU01;
     IF ZONE EQ '1' AND PROGRAM EQ 'PGMBZZZY';

   PROC PRINT; VAR SYSID ENDTS
     VSUA000L VSUA229L VSUA230L VSUA236L
     VSUA237L VSUA251L VSUA252L VSUA255L;