Re: BRMS - how to see objects actually backed up?

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

Michael, I ran this in STRSQL but I ran into a problem because of the 
"SUM(BKHSIZ)".  With that in place, STRSQL didn't like the RowNumber 
because BKSSVT was invalid.  If I changed SUM(BKHSIZ) to BKHSIZ, the SQL 
worked nicely.  Am I missing the reason for the SUM(BKHSIZ)?

Thank you!

On 7/22/2020 7:24 AM, Mayer, Michael via MIDRANGE-L wrote:
> Run DSPLOGBRM, F4 and plug in the parms as needed is 1 way to go about it although that's the long route.
>
> You can also run an SQL over file QA1AHS.QUSRBRM. I run this daily on all of our BRMS backups using ACS
> Run SQL Scripts.
>
> Select Row_Number() over (Order by BKSSVT) as "Row #",
> SUBSTR(BKHSVT, 2, 6) AS "Bkup Date", BKVOL AS "Tape #", BKHSYS AS "System",
>         BKHLIB AS "Lib", BKHSEQ AS "Seq#", BKHSAV AS "Obj Sv", BKHERR AS "Obj N Sv", BKHSTA AS "Sts 0=N 1=S",
>         SUM(BKHSIZ) AS "Blk Sz Bytes", BKHMSG AS "Error Msg ID", BKTYPS AS "Save Type", BKHGRP AS "Ctl Grp", BKHCMD AS "B/Up Cmd",
>         BKSAVT AS "Tape Y/N", SUBSTR(BKSSVT, 8, 6) AS "Start Time", SUBSTR(BKESVT, 8, 6) AS "End Time", BKHTIM AS "Bkup Time",
>         BKHTXT AS "Text"
>      FROM QUSRBRM.QA1AHS
>        WHERE SUBSTR(BKHSVT, 2, 6) = '200722'
>
> The output will look like this:
>
> Row #            Bkup Date Tape #  System       Lib           Seq#   Obj Sv   Obj N Sv St Blk Sz Bytes             Error Msg  Save Type Ctl Grp            B/Up Cmd   Tape Start T  End Tim  Bkup Time  Text
> 1                    200722      00885B FLABARP  PDPDDB      1      98          0        1      28526407680                             *CUM         BKUP_DAILY SAVCHGOBJ  Y  003641 003839    3913
> 2                    200722      00885B FLABARP  YAFRDTA    2        4          0        1      89370624                                   *CUM         BKUP_DAILY SAVCHGOBJ  Y  003839 003841    3913
> 3                    200722      00885B FLABARP  TFBDB         3      32          0        1      2039324672                               *CUM         BKUP_DAILY SAVCHGOBJ  Y  003842 003851    3913
>
> Using this SQL as abase, I can adjust it for what was saved, what was not saved, what type of save, etc. It's very flexible.
>
> ----------------------------------------
>
> Or write a 5250 WRKQRY over QA1AHS/QUSRBRM and adjust the record selections as needed.
>
> Note; There is a difference between what regular commands see backed up in BRMS and using the files in BRMS. I ran into
> This a few years ago, was a bit confused and had IBM confirm that fact.
>
> QA1AHS is also over the top of BRMS command WRKMEDIBRM, which is also a nice way of looking at your backup.