5. FILES › 5.3 DFHSM Inventory Primary Information Area Files › 5.3.1 Migrated Data File (HSMMIG) › 5.3.1.4 HSMMIG Retrieval Examples

5.3.1.4 HSMMIG Retrieval Examples

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.  List all data sets for TSO user TPR030 that have been
    migrated from primary DASD since the beginning of the
    year.

    DATA;
    SET &PHSMX..HSMMIG01;
    IF DSNAME=:'TPR030';
    IF YEAR(DATEPART(MIGRATTS)) = YEAR(TODAY());
    PROC PRINT; VAR DSNAME MIGRATTS MIGDSIZE;

2.  Show the amount of data migrated by management class.  In
    this example, we have included the JCL (procedure) you
    should use to run the SAS job.  In this example, the
    small "x" in the EXEC statement and the PROC SORT
    statement would need to be replaced by the identifier of
    the unit data base you are accessing (previous examples
    have used "P" for the value of "x").  Also note the use
    of the MIGSUM macro providing summarization for the
    HSMMIG file.

 //MIG1     JOB ....
 //REPORT  EXEC  MICSSHRx
 //SYSIN    DD  *
     %LET BY = STORMGTC;
     %LET BREAK = STORMGTC;
     PROC SORT DATA=&xVCAD..HSMMIG01 OUT=SUMFILE;
          BY &BY;
     DATA;
          SET SUMFILE;
     %MIGSUM;
     PROC PRINT NOOBS LABEL;
          VAR STORMGTC MIGDSNNO MIGALLSP;
     TITLE1 'MIGRATION SUMMARY BY MANAGEMENT CLASS';
 /*

An example of the output produced follows.  The first detail
line represents 2471 data sets that do not have a value for
MGMTCLAS (STORMGTC = ' ').


         MIGRATION SUMMARY BY MANAGEMENT CLASS

      DFSMS Management     Count of     Migration
      Class Name           Migrated     Copy Size
                           Data Sets    (MBytes)

                              2471        1732.0
          DUMP                 213        2805.9
          LARGE               1213       12635.1
          NOMIG                  1           0.3
          STANDARD           18088        9094.1

 Figure 5-9.  Sample Migration Summary Report