You may find this useful.
In Redbook, 'Backup Recovery Media Services: A Practical Approach' ,SG24-4840, there is an Appendix that list the PF's in QUSRBRM. I know it's an old book but the files haven't changed much.
--
Sherri Houck
Systems Administrator, Data Center
Susquehanna Bancshares, Inc.
26 N Cedar St, Lititz, PA 17543-7000 | Mailcode: DATAOPS
Tel: 717.625.6382 x56382 | Cell: 717.475.6064
Sherri.Houck@xxxxxxxxxxxxxxx | Web: www.susquehanna.net
Connect with us: Facebook | Twitter | YouTube | Blog
Confidentiality Notice: This e-mail is intended for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If you have received this communication in error, please notify me immediately at the above phone number or e-mail address and delete the original message. Thank you.
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, February 03, 2015 7:45 AM
To: Midrange Systems Technical Discussion
Subject: Re: How to check the duration of a backup list in BRMS in an easy way
Well, I looked at this the old fashioned way. I opened up two sessions.
On one I was in DSPLOGBRM. On the other I did a WRKUSRJOB ROB *ACTIVE.
Then I displayed the first job and looked at the open files. Had to hit the function key to see the I/O details. There's one file open in QBRM, but it's a display file so that's out. Hey, there's two files open in QUSRBRM and they are logical files. I bet they have some potential.
Well, maybe.
Both files are logicals. That being true, the 'meat' of the data is in the first field. This happens to be a 32k field of totally unformatted data with imbedded packed data and whatnot. It's almost as if the main programs processing that are RPG programs which handle the data internally via multiformat file logic. There are some columns at the end which may be applicable for record format id.
Now let's look at the call stack in DSPLOGBRM. First there's an ILE version of a CL program, Q1ACLG. Then there's an ILE version of an RPG program, Q1ARLG
Program . . . . . . . : Q1ARLG Library . . . . . . . : QBRM
Program attribute . . : RPGLE
Detail . . . . . . . . : *MODULE
Creation Optimization Debug
Module Library Attribute Date Level Data
Q1ARLG PTFBLD3 RPGLE 04/29/14 *BASIC *NO
Yep, you're going to play hell querying that data.
Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
From: Frigyes Szepesi <frigyes.szepesi@xxxxxxxxxx>
To: midrange-l@xxxxxxxxxxxx
Date: 02/03/2015 03:06 AM
Subject: How to check the duration of a backup list in BRMS in an
easy way
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>
Hi to the Gurus,
We have a customer, he is complaining about the duration of the backup. To
investigate it, I would like to know the duration of the separate backup
list. I could check for BRM1413 for the beginning, and BRM1414 for the end
in BRMS log, but it is very time consuming. I need to compare different
days, to figure out which part of the backup takes longer. Is there any
way
of query-ing of a specific database of BRMS?
Bon
midrange.com
