5. FILES › 5.4 WLM Information Area Files › 5.4.13 Report Class Subsystem Delay States (WLM_EW) › 5.4.13.4 Retrieval Examples

5.4.13.4 Retrieval Examples

This section presents a typical WLM_EW 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.

Report Class Subsystem Delays

    TITLE1 "Report Class Subsystem Delays";

    DATA WORK._EW1
     (KEEP=SYSPLEX WLMSDFNM WLMSDFTS SYSNAME
      WLMRPTCL WLMPOLCY WLMRPTDE ENDTS
      SDSSUBNM SDSPHASE SDSPCACT SDSPCRDY SDSPCIDL
      SDSPCSSL SDSPCSSS SDSPCSSN);
      MERGE
        &PWLMX..WLM_EA01 (IN=_EA)
        &PWLMX..WLM_EW01 (IN=_EW);
      BY SYSID ENDTS WLMSDFNM WLMSDFTS WLMRPTCL WLMPOLCY;
      IF (_EA & _EW) THEN OUTPUT WORK._EW1;
    RUN;

    PROC SORT NODUPKEY OUT=WORK._EW2 DATA=WORK._EW1;
      BY SYSPLEX WLMSDFNM WLMSDFTS SYSNAME ENDTS
        WLMRPTCL WLMPOLCY SDSSUBNM SDSPHASE;
    RUN;

    PROC PRINT LABEL DATA=WORK._EW2;
      BY SYSPLEX WLMSDFNM;
      ID SYSNAME ENDTS;
      VAR WLMRPTCL WLMPOLCY
        SDSSUBNM SDSPHASE SDSPCACT SDSPCRDY
        SDSPCIDL SDSPCSSL SDSPCSSS SDSPCSSN;
    RUN;