Creating an Archive Database report

By running a single batch job, you can generate a report that provides a list the data sets that are currently in the Archive Database, a list the tapes where the inactive data sets are archived, and summary information.

About this task

The JCL for the Archive Database report job resides in member AXQDBRPT of the product JCL sample library. Unless you specify selection criteria to restrict the report to only those data sets whose attributes match the criteria, running the AXQDBRPT job generates a report that includes information for all records in the Archive Database.
Note: Alternative methods of confirming that all of the appropriate data sets were archived are described in Verifying the contents of the archive.

Procedure

  1. To the JCL in AXQDBRPT, add appropriate job card information for your site.
  2. Replace all occurrences of @HLQ with your data set prefix.
  3. If you want all of the Archive Database records included in the report, ignore this step and go directly to step 4. Otherwise, provide the data set selection criteria that will identify the data sets whose Archive Database records you want included in the report and the criteria that will identify the data sets whose Archive Database records you want excluded from the report. Use the information and examples that are provided in Selection criteria keyword reference for Archive Database reporting function, as a guide for criteria keyword specification.
    • You may code the data set selection criteria in member CRITERIA of the product parameter library.
    • Alternatively, you may code the data set selection criteria in the job itself.
  4. When you have finished modifying the AXQDBRPT JCL, submit the job for execution.

Results

The following figure shows an example of the Archive Data Set Report that is written to the DSETRPT DD. Note the summary information at the end of the report.
VER X.X                                           A D V A N C E D   A R C H I V E  FOR  DFSMShsm                   AXQDBRPT JOBXXXXX
                                                                                                                                    
DATE: XX/XX/XXXX.XXX  TIME: XX:XX:XX                  ARCHIVE DATA SET REPORT FOR COMPANY_NAME                           PAGE      1
                                                                                                                                    
DATA SET NAME                                 ARCHVOL  ARCH DATE   ARCHSIZE IN K  CREATE DATE  LASTUS DATE  MGMT CLASS  CALC EXPDT  
--------------------------------------------  -------  ----------  -------------  -----------  -----------  ----------  ----------  
AXBW0101.COPY                                 VD0997   XX/XX/XXXX            868   XX/XX/XXXX   XX/XX/XXXX   STANDARD   PERMANENT   
AXBW0101.HTTT.WORK1                           VD0997   XX/XX/XXXX          3,260   XX/XX/XXXX   XX/XX/XXXX   TMMBKUP    XX/XX/XXXX  
AXBW0101.HTTT.WORK2                           VD0997   XX/XX/XXXX          3,490   XX/XX/XXXX   XX/XX/XXXX   TMMBKUP    XX/XX/XXXX  
AXBW0101.RZZ.MS.CLUSTER                       VD0997   XX/XX/XXXX             82   XX/XX/XXXX   XX/XX/XXXX   TMMBKUP    PERMANENT   
AXBW0101.RZZ.MS.CLUSTER1                      VD0997   XX/XX/XXXX             82   XX/XX/XXXX   XX/XX/XXXX   STANDARD   PERMANENT   
AXBW0101.RZZ.Z00.CLUSTER                      VD0997   XX/XX/XXXX             82   XX/XX/XXXX   XX/XX/XXXX   STANDARD   PERMANENT   
AXBW0101.RZZ.Z00.CLUSTER1                     VD0997   XX/XX/XXXX             82   XX/XX/XXXX   XX/XX/XXXX   STANDARD   PERMANENT   
CSTS.CST1.B1.D140506.T030429.U415434          VD0710   XX/XX/XXXX             66   XX/XX/XXXX   XX/XX/XXXX   STANDARD   PERMANENT   
CSTS.CST1.B1.D141028.T040339.U013474          VD0710   XX/XX/XXXX             49   XX/XX/XXXX   XX/XX/XXXX   STANDARD   PERMANENT   
CSTS.CST1.B1.D141028.T040507.U379072          VD0710   XX/XX/XXXX             66   XX/XX/XXXX   XX/XX/XXXX   STANDARD   PERMANENT   
.
.
.
VER X.X                                           A D V A N C E D   A R C H I V E  FOR  DFSMShsm                   AXQDBRPT JOBXXXXX
                                                                                                                                    
DATE: XX/XX/XXXX.XXX  TIME: XX:XX:XX                  ARCHIVE DATA SET REPORT FOR COMPANY_NAME                           PAGE      5
                                                                                                                                    
DATA SET NAME                                 ARCHVOL  ARCH DATE   ARCHSIZE IN K  CREATE DATE  LASTUS DATE  MGMT CLASS  CALC EXPDT  
--------------------------------------------  -------  ----------  -------------  -----------  -----------  ----------  ----------  
TK.NO2310B.B1.D151023.T025532.U637697         VD0234   XX/XX/XXXX             49   XX/XX/XXXX   XX/XX/XXXX              PERMANENT
TK.NO2310B.B1.D151027.T025041.U069081         VD0234   XX/XX/XXXX             49   XX/XX/XXXX   XX/XX/XXXX              PERMANENT
TK.NO2310B.B1.D151028.T032536.U179692         VD0234   XX/XX/XXXX             49   XX/XX/XXXX   XX/XX/XXXX              PERMANENT
TK.NO2310B.B1.D151028.T072506.U808042         VD0234   XX/XX/XXXX             49   XX/XX/XXXX   XX/XX/XXXX              PERMANENT
TK.NO2310B.B1.D160412.T064600.U474755         VD0234   XX/XX/XXXX             49   XX/XX/XXXX   XX/XX/XXXX              PERMANENT
                                                                                                                                 
                                                                                                                                 
                                                                                                                                 
       TOTALS BY DATA SET EXPIRATION DATE                                                                                        
                                                                                                                                 
          DATA SETS EXPIRING THIS YEAR    NUMBER OF DATA SETS:         2    TOTAL SIZE IN MB:           7                        
          DATA SETS EXPIRING NEXT YEAR    NUMBER OF DATA SETS:         0    TOTAL SIZE IN MB:           0                        
          DATA SETS EXPIRING 3 - 5 YRS    NUMBER OF DATA SETS:         0    TOTAL SIZE IN MB:           0                        
          DATA SETS EXPIRING 5-10 YRS     NUMBER OF DATA SETS:         0    TOTAL SIZE IN MB:           0                        
          DATA SETS EXPIRING 10-20 YRS    NUMBER OF DATA SETS:         0    TOTAL SIZE IN MB:           0                        
          DATA SETS EXPIRING PAST 20YR    NUMBER OF DATA SETS:       247    TOTAL SIZE IN MB:         891                        
                                                                                                                                 
                                                                                                                                 
       TOTALS FOR ALL DATA SETS                                                                                                  
                                                                                                                                 
                                          NUMBER OF DATA SETS:       249    TOTAL SIZE IN MB:         898                        
1VER X.X                          R O C K E T   A R C H I V E   M A N A G E R   FOR   Z/OS                   MXQDBRPT JOBXXXXX

 DATE: XX/XX/XXXX.XXX  TIME: XX:XX:XX                  ARCHIVE DATA SET REPORT FOR COMPANY_NAME                           PAGE      1

 DATA SET NAME                                 ARCHVOL  ARCH DATE   ARCHSIZE IN K  CREATE DATE  LASTUS DATE  MGMT CLASS  CALC EXPDT
 --------------------------------------------  -------  ----------  -------------  -----------  -----------  ----------  ----------
 AAWP.CATERING.AAWP0301.DT.AP.DIS.G0352V00     V00001   XX/XX/XXXX            492   XX/XX/XXXX   XX/XX/XXXX   GDG          -NONE-
 AAWP.CATERING.AAWP0301.DT.AP.DIS.G0353V00     V00001   XX/XX/XXXX            524   XX/XX/XXXX   XX/XX/XXXX   GDG        XX/XX/XXXX
 AAWP.CATERING.AAWP0301.DT.AP.DIS.G0355V00     V00001   XX/XX/XXXX            524   XX/XX/XXXX   XX/XX/XXXX   GDG        XX/XX/XXXX
 AAWP.CATERING.AAWP0304.CH.LWN.GL.G0087V00     V00001   XX/XX/XXXX            672   XX/XX/XXXX   XX/XX/XXXX   GDG        XX/XX/XXXX
 AAWP.CATERING.AAWP0304.CH.LWN.GL.G0091V00     V00001   XX/XX/XXXX            492   XX/XX/XXXX   XX/XX/XXXX   GDG        XX/XX/XXXX
 AAWP.CATERING.AAWP0305.HOSP.LWN.GL.G0088V00   V00001   XX/XX/XXXX         13,009   XX/XX/XXXX   XX/XX/XXXX   GDG        XX/XX/XXXX
 AAWP.CATERING.AAWP0305.HOSP.LWN.GL.G0090V00   V00001   XX/XX/XXXX         13,238   XX/XX/XXXX   XX/XX/XXXX   GDG          -NONE-
 AAWP.CATERING.AAWP0306.FH.LWN.GL.G0084V00     V00001   XX/XX/XXXX          1,999   XX/XX/XXXX   XX/XX/XXXX   GDG        XX/XX/XXXX
 AAWP.CATERING.AAWP0306.FH.LWN.GL.G0085V00     V00001   XX/XX/XXXX          1,802   XX/XX/XXXX   XX/XX/XXXX   GDG        XX/XX/XXXX
 AAWP.CATERING.AAWP0306.FH.LWN.GL.G0086V00     V00001   XX/XX/XXXX          1,868   XX/XX/XXXX   XX/XX/XXXX   GDG        XX/XX/XXXX
 AAWP.CATERING.AAWP0306.FH.LWN.GL.G0087V00     V00001   XX/XX/XXXX            803   XX/XX/XXXX   XX/XX/XXXX   GDG        PERMANENT
 AAWT.ACS.AZ                                   V00001   XX/XX/XXXX         35,078   XX/XX/XXXX   XX/XX/XXXX   MT6        XX/XX/XXXX
 AAWT.ACS.AZ.FTP                               V00001   XX/XX/XXXX          3,801   XX/XX/XXXX   XX/XX/XXXX   MT6          -NONE-
 AAWT.AZ.BADGE                                 V00001   XX/XX/XXXX          3,801   XX/XX/XXXX   XX/XX/XXXX   MT6        XX/XX/XXXX
 AAWT.AZ.BADGE.FTP                             V00001   XX/XX/XXXX         35,078   XX/XX/XXXX   XX/XX/XXXX   MT6        XX/XX/XXXX
.
.
.
1VER X.X                              R O C K E T   A R C H I V E   M A N A G E R   FOR   Z/OS                   MXQDBRPT JOBXXXXX

 DATE: XX/XX/XXXX.XXX  TIME: XX:XX:XX                  ARCHIVE DATA SET REPORT FOR COMPANY_NAME                           PAGE    186

 DATA SET NAME                                 ARCHVOL  ARCH DATE   ARCHSIZE IN K  CREATE DATE  LASTUS DATE  MGMT CLASS  CALC EXPDT
 --------------------------------------------  -------  ----------  -------------  -----------  -----------  ----------  ----------
 CAMP.CHCODE.DKA0.Y02.CFV6GECM.S2              V00246   XX/XX/XXXX        840,532   XX/XX/XXXX   XX/XX/XXXX   CAMPYR15     -NONE-
 CAMP.CHCODE.DKA0.Y02.CFV6GECM.S9              V00246   XX/XX/XXXX        840,450   XX/XX/XXXX   XX/XX/XXXX   CAMPYR15   XX/XX/XXXX
 CAMP.CHCODE.DKA0.Y02.CFV6TC0J.S17             V00246   XX/XX/XXXX         43,418   XX/XX/XXXX   XX/XX/XXXX   CAMPYR15   XX/XX/XXXX
 CAMP.CHCODE.DKA0.Y02.CFV66BOJ.S4              V00246   XX/XX/XXXX        840,516   XX/XX/XXXX   XX/XX/XXXX   CAMPYR15   XX/XX/XXXX
 CAMP.CHCODE.DKA0.Y02.CFV7V80G.S17             V00246   XX/XX/XXXX         47,022   XX/XX/XXXX   XX/XX/XXXX   CAMPYR15   XX/XX/XXXX
 CAMP.CHCODE.DKA0.Y02.CFV8L6DS.S10             V00246   XX/XX/XXXX        840,450   XX/XX/XXXX   XX/XX/XXXX   CAMPYR15   EXPIRED
 CAMP.CHCODE.DKA0.Y02.CFV8Y41T.S13             V00246   XX/XX/XXXX        840,450   XX/XX/XXXX   XX/XX/XXXX   CAMPYR15     -NONE-
 CAMP.CHCODE.DKA0.Y02.CFV8Y41T.S3              V00246   XX/XX/XXXX        840,466   XX/XX/XXXX   XX/XX/XXXX   CAMPYR15   XX/XX/XXXX
 CAMP.CHCODE.DKA0.Y02.CFV8Y41T.S8              V00246   XX/XX/XXXX        840,450   XX/XX/XXXX   XX/XX/XXXX   CAMPYR15   UNKNOWN
 CAMP.CHCODE.DKA0.Y02.CFWARYDO.S6              V00246   XX/XX/XXXX        840,450   XX/XX/XXXX   XX/XX/XXXX   CAMPYR15   XX/XX/XXXX



        TOTALS BY DATA SET EXPIRATION DATE

           DATA SETS EXPIRING THIS YEAR    NUMBER OF DATA SETS:     2,857    TOTAL SIZE IN MB:     624,821
           DATA SETS EXPIRING NEXT YEAR    NUMBER OF DATA SETS:       121    TOTAL SIZE IN MB:       3,155
           DATA SETS EXPIRING 3 - 5 YRS    NUMBER OF DATA SETS:     1,920    TOTAL SIZE IN MB:     477,490
           DATA SETS EXPIRING 5-10 YRS     NUMBER OF DATA SETS:         8    TOTAL SIZE IN MB:          29
           DATA SETS EXPIRING 10-20 YRS    NUMBER OF DATA SETS:     1,891    TOTAL SIZE IN MB:     347,522
           DATA SETS EXPIRING PAST 20YR    NUMBER OF DATA SETS:     3,203    TOTAL SIZE IN MB:     716,478


        TOTALS FOR ALL DATA SETS

                                           NUMBER OF DATA SETS:    10,000    TOTAL SIZE IN MB:   2,169,496
An example of the Archive Tape Report, which is written to the TAPERPT DD, is shown in the following figure. Note the summary information at the end of the report.
VER X.X                                          A D V A N C E D   A R C H I V E  FOR  DFSMShsm                   AXQDBRPT JOBXXXXX
                                                                                                                                    
DATE: XX/XX/XXXX.XXX  TIME: XX:XX:XX                    ARCHIVE TAPE REPORT FOR COMPANY_NAME                             PAGE      1
                                                                                                                                    
ARCHVOL  ARCH DATE   ARCH TIME   GROUP     TARGET CAP     USED CAP     ACTIVE CAP   ACTIVE %  FULL  COPY2VOL  COPY3VOL  COPY4VOL    
-------  ----------  ---------  --------  ------------  ------------  ------------  --------  ----  --------  --------  --------    
VD0234   XX/XX/XXXX  XX:XX:XX   RTK         99,999,000             5             5      0%     Y     C10148    C60002               
VD0710   XX/XX/XXXX  XX:XX:XX   CATDS       99,999,000             7             7      0%     Y     C10139    C60000               
VD0955   XX/XX/XXXX  XX:XX:XX   NETSTHDS    99,999,000            10            10      0%     Y     C10144    C60001               
VD0981   XX/XX/XXXX  XX:XX:XX   CATDS       99,999,000         1,091         1,091      0%     Y                                    
VD0997   XX/XX/XXXX  XX:XX:XX   VSAM        99,999,000             8             8      0%     Y     C10152    C60003               
                                                                                                                                    
                                                                                                                                    
                                                                                                                                    
   TOTALS FOR TAPE RECORDS                                                                                                          
                                                                                                                                    
         ARCHIVE         NUM OF       TARGET         ACTIVE         ACTIVE                                                          
          GROUP          TAPES       MEGABYTES      MEGABYTES        PCT                                                            
         --------     ---------     -----------    -----------      ------                                                          
         RTK                  3     299,997,000             15         0%                                                           
         CATDS                4     399,996,000          1,112         0%                                                           
         NETSTHDS             3     299,997,000             30         0%                                                           
         VSAM                 3     299,997,000             24         0%                                                           
                                                                                                                                    
         --------     ---------     -----------    -----------      ------                                                          
         *TOTALS*            13     299,987,000          1,181         0%                                                           
1VER X.X                                           R O C K E T   A R C H I V E   M A N A G E R  FOR  Z/OS                   MXQDBRPT JOBXXXXX

 DATE: XX/XX/XXXX.XXX  TIME: XX:XX:XX                    ARCHIVE TAPE REPORT FOR COMPANY_NAME                             PAGE      5

 ARCHVOL  ARCH DATE   ARCH TIME   GROUP     TARGET CAP     USED CAP     ACTIVE CAP   ACTIVE %  FULL  COPY2VOL  COPY3VOL  COPY4VOL
 -------  ----------  ---------  --------  ------------  ------------  ------------  --------  ----  --------  --------  --------
 V00217   XX/XX/XXXX  XX:XX:XX   DEFAULT          1,000         2,258         2,258    226%     Y     W00217    X00217    Y00217
 V00218   XX/XX/XXXX  XX:XX:XX   GROUP2           1,000           828           828     83%     Y     W00218
 V00219   XX/XX/XXXX  XX:XX:XX   GROUP3           1,000           902           902     90%     Y     W00219    X00219
 V00220   XX/XX/XXXX  XX:XX:XX   GROUP4           1,000           341           341     34%     Y
 V00221   XX/XX/XXXX  XX:XX:XX   DEFAULT          1,000         2,259         2,259    226%     Y     W00221    X00221    Y00221
 V00222   XX/XX/XXXX  XX:XX:XX   GROUP3           1,000           828           828     83%     Y     W00222
 V00223   XX/XX/XXXX  XX:XX:XX   DEFAULT          1,000           838           838     84%     Y     W00223    X00223    Y00223
 V00224   XX/XX/XXXX  XX:XX:XX   GROUP4           1,000         2,477         2,477    248%     Y
 V00225   XX/XX/XXXX  XX:XX:XX   GROUP3           1,000           876           876     88%     Y     W00225    X00225
.
.
.


    TOTALS FOR TAPE RECORDS

          ARCHIVE         NUM OF       TARGET         ACTIVE         ACTIVE
           GROUP          TAPES       MEGABYTES      MEGABYTES        PCT
          --------     ---------     -----------    -----------      ------
          DEFAULT            328         328,000        387,564       118%
          GROUP2              82          82,000         76,000        93%
          GROUP3             165         165,000        181,748       110%
          GROUP4              61          61,000         69,296       114%

          --------     ---------     -----------    -----------      ------
          *TOTALS*           636         636,000        714,608       112%

What to do next

If the Database Report results are not as you expected them to be, you can modify the Archive job JCL to generate a candidate rejection report. For more information about candidate rejection reports, see Creating a candidate rejection report.