5. FILES › 5.4 WLM Information Area Files › 5.4.3 Service Client File (WLMSVC) › 5.4.3.4 Retrieval Examples
5.4.3.4 Retrieval Examples
This section presents a typical WLMSVC 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.
Service Client Activity
TITLE1 "Service Client Activity";
DATA WORK.SVC1
(KEEP=SYSPLEX WLMSDFNM WLMSDFTS WLMCLASS WLMPOLCY
WLMCLSDE SVCCLTNM SVCCLTSC SVCCLTRT ENDTS);
MERGE
&PWLMX..WLMSEA01 (IN=SEA)
&PWLMX..WLMSVC01 (IN=SVC);
BY SYSID ENDTS WLMSDFNM WLMSDFTS WLMCLASS WLMPOLCY;
IF (SEA & SVC) THEN OUTPUT WORK.SVC1;
RUN;
PROC SORT NODUPKEY OUT=WORK.SVC2 DATA=WORK.SVC1;
BY SYSPLEX WLMSDFNM WLMSDFTS ENDTS
WLMCLASS WLMPOLCY SVCCLTNM;
RUN;
PROC PRINT LABEL DATA=WORK.SVC2;
BY SYSPLEX WLMSDFNM WLMSDFTS; ID ENDTS;
VAR WLMCLASS WLMCLSDE WLMPOLCY
SVCCLTNM SVCCLTSC SVCCLTRT;
RUN;