5. FILES › 5.3 SCP Information Area Files › 5.3.2 Logical Channel/CU Activity File (SCPLCA) › 5.3.2.4 Retrieval Examples
5.3.2.4 Retrieval Examples
This section presents a typical SCPARD 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.
1. Print total number of times all channel paths were taken
for logical control units 000B, 0001, 0002, and 0003.
DATA;
SET &PSCPX..SCPLCA01;
IF INDEX('000B 0001 0002 0003', LCUID);
PROC PRINT; VAR SYSID STARTTS ENDTS LCAPT;
2. Print yesterday's average and maximum percent of requests
deferred for each hour in zone 1 for all logical
channels:
DATA;
SET &PSCPD..SCPLCA01;
IF ZONE='1';
PROC PRINT; VAR SYSID YEAR MONTH DAY HOUR
LCAPSRQD LCAMSRQD;