5. FILES › 5.3 DFHSM Inventory Primary Information Area Files › 5.3.3 Tape Planning File (HSMTAP) › 5.3.3.4 HSMTAP Retrieval Examples

5.3.3.4 HSMTAP 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.  Display the number of tapes under DFHSM that were either
    full or partially full of HSM Level 2 migration data as
    of yesterday.

    PROC PRINT DATA=&PHSMX..HSMTAP01;
    VAR SYSID YEAR MONTH TAPMFULL TAPMPART;


2.  Plot the change in usage of DFHSM-owned backup tapes over
    the past 4 days.  An output sample follows the code.

  DATA;
    SET &PHSMD..HSMTAP01 &PHSMD..HSMTAP02
        &PHSMD..HSMTAP03 &PHSMD..HSMTAP04;
        DATE = DATEPART(ENDTS);
        FORMAT DATE DATE7.;
  PROC PLOT NOLEGEND;
       PLOT TAPBFULL*DATE = 'F' TAPBNULL*DATE = 'E'
            TAPBPART*DATE = 'P' / OVERLAY;
       LABEL TAPBFULL = 'NUMBER OF TAPES';
       TITLE1 'HSM BACKUP TAPE USAGE';
       FOOTNOTE1 'F = FULL BACKUP VOLUMES   ';
       FOOTNOTE2 'P = PARTIAL BACKUP VOLUMES';
       FOOTNOTE3 'E = EMPTY BACKUP VOLUMES  ';

                                                     HSM BACKUP TAPE USAGE                        13:15 MONDAY, JUNE 17, 1991
 
      |E
      |                                       E
      |                                                                                E
  450 +                                                                                                                         E
      |
      |
      |
      |
  400 +
      |
      |
      |
N     |
U 350 +
M     |
B     |
E     |
R     |
  300 +
O     |
F     |
      |
T     |
A 250 +
P     |
E     |
S     |
      |                                                                                                                         P
  200 +                                       P                                        P
      |P
      |
      |
      |
  150 +                                                                                                                         F
      |                                       F                                        F
      |F
      |
      |
  100 +
      -+--------------------------------------+----------------------------------------+----------------------------------------+-
    10MAY91                                11MAY91                                  12MAY91                                13MAY91
 
                                                                DATE
 
                                                   F = FULL BACKUP VOLUMES
                                                   P = PARTIAL BACKUP VOLUMES
                                                   E = EMPTY BACKUP VOLUMES

 Figure 5-14.  Sample HSM Backup Tape Usage Report