How to create a report of the files backed up in the last 24 hours?

Document ID : KB000015931
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

How to create a report of the files backed up in the last 24 hours?

Answer:

The information about when a backup is taken is contained in the DSNINDEX records that are created for each Backup or Archive.

Please check the following options to create a report on recent Backups:  

 

1) CA Disk RECOVER in SIMULATE Mode 

Run a RECOVER in SIMULATE mode with corresponding SELECT statements, here a sample:

//STEP01  EXEC FMS                                     

//SYSIN     DD *                                       

   SET MODE=SIMULATE                                   

   SCAN DSNINDEX                                       

   SELECT DSN=abc./,                               

     CRITERIA=(ARCDT,GE,TODAY-1,                       

          AND,ARCTYPE,EQ,BACKUP)                       

   RECOVER                                             

/*

Unfortunately, there is no similar option to check ARCTIME against the current time, like there is with TODAY for ARCDT.

So with the above sample you will get a list of all Backups created since yesterday 00:00, not just 24h back.

 

2) CA Vantage GUI view "DSNINDEX Records"

If the customer has CA Vantage, the best option would be to use the Vantage GUI view "DSNINDEX Records (DMSINDEX)" 

that is located in the GUI tree under 

=> Backup and Archive Management

 => CA Disk 

  => DSNINDEX Records

Please use the following filter to get the same result as in the RECOVER sample above: 

 "Data Set Name" INCL  abc./  AND  "Archive Dt" >  TODAY-1  AND  "Scr" =  N

Note: 

"Scr" =  N excludes the data sets scratched for ARCHIVE processing, leaving the BACKUP entries.

Again you will get a list of all Backups created since yesterday 00:00, not just 24h back.