5. FILES › 5.4 WLM Information Area Files › 5.4.9 Service Class Response Time (WLMSEM) › 5.4.9.4 Retrieval Examples

5.4.9.4 Retrieval Examples

This section presents a typical WLMSEM 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 Class Average Response Time

    TITLE1 "Service Class Average Response Time";

    DATA WORK.SEM1
     (KEEP=SYSPLEX WLMSDFNM WLMSDFTS SYSNAME WLMWRKLD
      WLMCLASS WLMCLSPD WLMPOLCY WLMCLSDE ENDTS
      WLMGOLRT SEMTORCP SEMAVTET);
      MERGE
        &PWLMX..WLMSEA01 (IN=SEA)
        &PWLMX..WLMSEM01 (IN=SEM
         WHERE=(WLMGOLTP="RESP TIME AVG"));
      BY SYSID ENDTS WLMSDFNM WLMSDFTS
        WLMCLASS WLMCLSPD WLMPOLCY;
      IF (SEA & SEM) THEN OUTPUT WORK.SEM1;
    RUN;

    PROC SORT NODUPKEY OUT=WORK.SEM2 DATA=WORK.SEM1;
      BY SYSPLEX WLMSDFNM WLMSDFTS SYSNAME ENDTS
        WLMCLASS WLMCLSPD WLMPOLCY;
    RUN;

    PROC PRINT LABEL DATA=WORK.SEM2;
      BY SYSPLEX WLMSDFNM;
      ID SYSNAME ENDTS;
      VAR WLMWRKLD WLMCLASS WLMCLSPD WLMPOLCY
        WLMGOLRT SEMTORCP SEMAVTET;
    RUN;