5. FILES › 5.4 WLM Information Area Files › 5.4.1 Service Definition File (WLMSDE) › 5.4.1.4 Retrieval Examples

Previous Topic: 5.4.1.3 Usage Considerations

Next Topic: 5.4.2 Resource Group File (WLMRGP)

5.4.1.4 Retrieval Examples


This section presents a typical WLMSDE 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 Definition History

    TITLE1 "SERVICE DEFINITION HISTORY";

    PROC SORT NODUPKEY
      OUT=WORK.SDE
      DATA=&PWLMX..WLMSDE01 (KEEP=
        SYSPLEX SYSNAME SYSID WLMSDFNM
        WLMSDFTS WLMSDFDE WLMSDUSR);
      BY SYSPLEX SYSNAME SYSID WLMSDFNM WLMSDFTS;
    RUN;

    PROC PRINT DATA=WORK.SDE;
      BY SYSPLEX; PAGEBY SYSPLEX; ID SYSNAME;
      VAR SYSID WLMSDFNM WLMSDFTS WLMSDFDE WLMSDUSR;
    RUN;