Very nice piece of SQL. My ACS is complaining about needing a group by
clause for each of the variables in the SQL. Was that omitted or is there a
magic incantation in SQL (I know enough SQL to be somewhat dangerous) to
avoid the "group by". I got it to work by adding the group by but I'm
curious about it.
--
Jim Oberholtzer
Agile Technology Architects
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Mayer,
Michael via MIDRANGE-L
Sent: Wednesday, July 22, 2020 7:25 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Cc: Mayer, Michael <MMayer@xxxxxxxxxxxxxx>
Subject: BRMS - how to see objects actually backed up?
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.
----------------------------------------
Very Respectfully,
Michael Mayer
IBM i Support / System Admin.
IT Operations.
The Florida Bar
651 E. Jefferson St
Tallahassee, Florida 32399-2300
mmayer@xxxxxxxxxxxxxx
https://www.floridabar.org
Office: 850.561.5761
Cell: 518.641.8906.
message: 3
date: Tue, 21 Jul 2020 21:46:29 +0000
from: "Howie, Bill" <BHowie@xxxxxxxxxxxxxxxx>
subject: BRMS - how to see objects actually backed up?
Hello all,
We are having an issue with seeing which objects that BRMS is actually
backing up during our nightly backup. If I go in through the BRMS options
and try to work with saved objects from the particular day and library in
question, what I see is actually the objects that were NOT backed up because
they were in use, and not the objects that were actually being saved. Is
the option that actually shows what was saved on a particular day hidden
somewhere in plain sight? Am I just blind? I'm using option 2 on the
"Display Backup History" menu. Any info is most appreciated. Thanks!
[Related image]<
https://www.hc-companies.com/>Bill Howie Senior ERP
Programmer/Analyst
Direct: 330.487.3739 | Cell: 330.888.8085 | Toll Free: 800.225.7712
2450 Edison Blvd, Suite 3, Twinsburg OH 44087
hc-companies.com<
https://www.hc-companies.com/>
Leader in Horticultural Containers
[cid:image003.png@01D65F86.DB226890]<
https://www.linkedin.com/company/the-hc
-companies> [cid:image004.png@01D65F86.DB226890]
<
https://www.facebook.com/HCCompanies/>
[cid:image005.png@01D65F86.DB226890]
<
https://www.instagram.com/hccompanies/>
[cid:image006.png@01D65F86.DB226890] <
https://twitter.com/hc_companies>
Disclaimer
The information contained in this communication from the sender is
confidential. It is intended solely for use by the recipient and others
authorized to receive it. If you are not the recipient, you are hereby
notified that any disclosure, copying, distribution or taking action in
relation of the contents of this information is strictly prohibited and may
be unlawful.
This email has been scanned for viruses and malware, and may have been
automatically archived by Mimecast Ltd, an innovator in Software as a
Service (SaaS) for business. Providing a safer and more useful place for
your human generated data. Specializing in; Security, archiving and
compliance. To find out more visit the Mimecast website.
------------------------------
re be subject to public disclosure.
________________________________
Please note: Florida has very broad public records laws. Many written
communications to or from The Florida Bar regarding Bar business may be
considered public records, which must be made available to anyone upon
request. Your e-mail communications may therefore be subject to public
disclosure.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
