

5. FILES › 5.3 SCP Information Area Files › 5.3.11 Logical Control Unit Activity File (SCPLCU) › 5.3.11.4 Retrieval Examples
5.3.11.4 Retrieval Examples
This section presents typical SCPLCU 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. Print yesterday's total I/O request rate to each logical
control unit, and the number of requests through each
channel to the logical control unit, for HOUR 13.
DATA;
SET &PSCPD..SCPLCU01;
IF HOUR EQ 13;
PROC PRINT;
VAR SYSID LCUID LCUAVPT LCUCH1 LCU1PT LCUCH2 LCU2PT
LCUCH3 LCU3PT LCUCH4 LCU4PT;
2. Print the percentage of I/O requests from each channel
connected to each logical control unit, for HOUR 8 of
yesterday, for SYSID PROD.
DATA;
SET &PSCPD..SCPLCU01;
IF HOUR EQ 8;
IF SYSID EQ 'PROD';
TOTAL=DURATION*LCUAVPT;
PERCENT1=100*(LCU1PT/TOTAL); PERCENT2=100*(LCU2PT/TOTAL);
PERCENT3=100*(LCU3PT/TOTAL); PERCENT4=100*(LCU4PT/TOTAL);
PERCENT5=100*(LCU5PT/TOTAL); PERCENT6=100*(LCU6PT/TOTAL);
PERCENT7=100*(LCU7PT/TOTAL); PERCENT8=100*(LCU8PT/TOTAL);
PROC PRINT;
ID LCUID;
VAR LCUCH1 PERCENT1 LCUCH2 PERCENT2
LCUCH3 PERCENT3 LCUCH4 PERCENT4
LCUCH5 PERCENT5 LCUCH6 PERCENT6
LCUCH7 PERCENT7 LCUCH8 PERCENT8;
Copyright © 2014 CA.
All rights reserved.
 
|
|