5.4.1.4 HSBBAC Retrieval Examples

5. FILES › 5.4 DFHSM Inventory Backup Information Area Files › 5.4.1 BACKUP Data File (HSBBAC) › 5.4.1.4 HSBBAC Retrieval Examples

5.4.1.4 HSBBAC 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 backup statistics for SMS management class APFLIB
    reflecting the utilization of incremental backup
    facilities last month.

    DATA;
    SET &PHSBM..HSBBAC01;
    IF STORMGTC=:'APFLIB';
    PROC PRINT;
    VAR BACMNASP BACMXASP BACAVASP BACCOST;

2.  Show department level statistics regarding the number of
    backup versions being maintained by DFHSM.

    %LET BY = HSMACT3;
    %LET BREAK = HSMACT3;
    PROC SORT DATA=&PHSBD..HSBBAC01 OUT=SUMFILE;
         BY &BY;
    DATA;
         SET SUMFILE;
    %BACSUM;
    PROC PRINT NOOBS LABEL UNIFORM;
         VAR HSMACT3 BACDSNNO BACALLSP BACMNASP
         BACAVASP BACMXASP;
         SUM BACDSNNO BACALLSP;
         LABEL HSMACT3 = 'DEPARTMENT';
    TITLE1 'HSM BACKUP SUMMARY BY DEPARTMENT';

AA1 ACC ADM AD1 AIC ALL ASX ATM AXC BAC BST BUN CAP CAT CA1 CA2 CDL CD1 CJ1 CK1 CMP CM1 CNM CSS CST CSU CS1 CT1 DA1 DA2 DD1 DEM DOC DPM DPO DPW DSI DSM DST DSX DXB EDU EMG END ESA FDL HSA HSM BACKUP SUMMARY BY DEPARTMENT 16:07 MONDAY, JUNE 17, 1991 1 DEPARTMENT Number of Total Size of Minimum Backup Avg Backup Maximum Backup Data Sets Backup Versions Version Size Size Version Size Backed Up (MBytes) (MBytes) (MBytes) (MBytes) 110 3.5 0.01638 0.032 0.573 316 857.7 0.01638 2.714 154.465 7 0.1 0.01638 0.016 0.016 1 0.0 0.01638 0.016 0.016 27 7.3 0.01638 0.272 3.129 2 0.0 0.01638 0.016 0.016 59 630.7 0.01638 10.689 95.926 887 1665.0 0.00000 1.877 124.715 2 0.1 0.03277 0.033 0.033 213 41.2 0.01638 0.194 2.179 1983 3422.9 0.01638 1.726 116.113 1707 1621.9 0.00000 0.950 88.766 470 2963.9 0.01638 6.306 414.438 2 5.4 0.16383 2.679 5.194 888 1076.9 0.01638 1.213 39.121 60 1.2 0.01638 0.020 0.066 342 781.7 0.01638 2.286 28.406 5 0.1 0.01638 0.016 0.016 120 4.1 0.01638 0.034 0.868 21 0.7 0.01638 0.032 0.066 128 278.4 0.01638 2.175 56.262 37 9.5 0.01638 0.255 2.572 3 4.2 1.39258 1.393 1.393 286 12807.1 0.00000 44.777 948.000 287 566.4 0.01638 1.973 25.133 742 3975.1 0.00000 5.357 198.063 188 46.8 0.01638 0.249 14.074 108 8.5 0.01638 0.079 1.311 2093 796.3 0.01638 0.380 38.535 241 30.6 0.01638 0.127 0.934 20 1.1 0.01638 0.053 0.704 3 0.0 0.01638 0.016 0.016 8 0.5 0.01638 0.066 0.131 7 40.1 0.01638 5.729 13.992 309 238.2 0.01638 0.771 8.962 68 8.7 0.01638 0.127 0.639 10047 10267.8 0.01638 1.022 170.605 1 0.2 0.24576 0.246 0.246 536 2163.9 0.01638 4.037 236.238 4 0.8 0.01638 0.197 0.360 10239 16368.4 0.01638 1.598 214.270 106 16.2 0.01638 0.153 2.277 29 12.0 0.01638 0.414 3.850 34 18.6 0.01638 0.546 1.720 2 0.1 0.01638 0.033 0.049 502 327.4 0.01638 0.652 26.395 1 0.0 0.01638 0.016 0.016

HSM BACKUP SUMMARY BY DEPARTMENT 16:07 MONDAY, JUNE 17, 1991 2 DEPARTMENT Number of Total Size of Minimum Backup Avg Backup Maximum Backup Data Sets Backup Versions Version Size Size Version Size Backed Up (MBytes) (MBytes) (MBytes) (MBytes) IAM 311 3122.7 0.01638 10.041 432.750 IDP 7 1.1 0.06552 0.159 0.344 IIN 190 234.2 0.01638 1.232 26.902 INF 9 977.2 0.96664 108.578 267.750 IPO 274 202.1 0.01638 0.738 27.375 ISP 5 0.6 0.01638 0.118 0.360 ISR 12 12.5 0.0164 1.0376 6.717 ITS 209 304.1 0.0164 1.4551 36.402 JAP 4 0.1 0.0164 0.0246 0.033 JOB 241 366.4 0.0164 1.5200 8.716 LCM 114 153.5 0.0164 1.3464 32.129 LGT 2 0.0 0.0164 0.0164 0.016 MA1 146 24.2 0.0164 0.1657 2.539 MB1 21 0.4 0.0164 0.0211 0.033 MDG 7 4.9 0.0328 0.7068 2.179 MD1 7 0.1 0.0164 0.0164 0.016 MEI 28 5.8 0.0164 0.2054 0.754 MIC 86 25.3 0.0164 0.2947 1.688 MIM 259 921.5 0.0164 3.5579 82.605 MLG 3 0.1 0.0164 0.0273 0.033 MSP 5 5.2 0.0164 1.0320 2.081 MSS 498 1370.4 0.0164 2.7517 49.395 MS6 338 774.2 0.0164 2.2903 77.559 MVS 36 120.3 0.0164 3.3413 10.715 NA1 81 6.2 0.0164 0.0764 1.507 NCP 3 27.0 6.9795 8.9946 10.453 NET 680 7130.7 0.0164 10.4861 291.563 NJL 3 0.0 0.0164 0.0164 0.016 NPG 4 1.7 0.3932 0.4260 0.459 NPM 1 0.0 0.0492 0.0492 0.049 NTC 161 180.3 0.0164 1.1199 11.501 OA1 91 28.0 0.0164 0.3082 14.369 ONL 213 656.5 0.0164 3.0818 80.199 OPR 234 855.9 0.0164 3.6577 39.977 OVM 179 99.8 0.0164 0.5576 10.731 O1A 1 0.0 0.0164 0.0164 0.016 PAS 116 1083.7 0.0164 9.3420 146.520 PER 422 1202.1 0.0000 2.8484 129.660 POR 9 3.2 0.0164 0.3549 1.442 PRO 1152 20673.3 0.0000 17.9453 649.750 QCA 2083 6442.2 0.0164 3.0925 124.777 QCM 50 16.5 0.0164 0.3296 2.720 QMF 65 2.2 0.0164 0.0335 0.180 RCS 67 60.9 0.0164 0.9094 7.029 SAR 140 193.7 0.0164 1.3831 120.520 SAS 1 26.6 26.6211 26.6211 26.621 SA1 179 78.3 0.0164 0.4373 9.568 SER 4 0.1 0.0164 0.0164 0.016

HSM BACKUP SUMMARY BY DEPARTMENT 16:07 MONDAY, JUNE 17, 1991 3 DEPARTMENT Number of Total Size of Minimum Backup Avg Backup Maximum Backup Data Sets Backup Versions Version Size Size Version Size Backed Up (MBytes) (MBytes) (MBytes) (MBytes) SMD 83 33.7 0.0164 0.4064 3.064 SMR 25 14.9 0.0164 0.5950 4.882 SMS 26 117.1 0.0164 4.5049 13.861 STX 292 733.9 0.0164 2.5132 91.551 SYS 1371 2731.9 0.0164 1.9924 55.195 TA1 39 1.9 0.0164 0.0496 0.147 TD1 17 8.7 0.0164 0.5127 2.572 TEC 152 349.4 0.0164 2.2988 38.008 TIM 14 0.9 0.0164 0.0655 0.197 NSM 209 17.1 0.0164 0.0818 0.819 TPX 344 2406.8 0.0164 6.9963 277.063 TSO 373 1034 0.000000 2.77295 64.5820 UIS 7 1 0.016383 0.16383 0.5079 USE 8 4 0.016383 0.54268 3.2766 VMD 1 0 0.229370 0.22937 0.2294 VOS 16 9 0.016383 0.56111 1.5728 XDC 3 3 0.589813 0.99390 1.6055 XVS 2 0 0.016383 0.02458 0.0328 ============ ============ 44984 115936


 Figure 5-16.  Sample HSM Backup Summary by Department Report