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

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.