Re: How to check the duration of a backup list in BRMS in an easy way

Hi Rob,

You are right. I found finally a logical file by checking the open
files using DSPBRMLOG command, it is QUSRBRM/QA1A2LG.

First I ran a query over this file, filtering the records by BRM1413,
then BRM1414, both of them to a separate output file. Then I ran a
query over the two output files, matching them by job, user, number,
and backup list. Thus I had the result, which contained one record by
backup list per job, with the beginning and end dates and times. From
that point I only had to subtract the beginning time form the end
time. Of course I faced the problem with jobs/backup lists starting
before midnight, and ending after, giving me negative durations.
Finally I had to create timestamps of the dates and times, then
subtract them, then convert the result to date and time format by
using a pile of substr statement.

On Tue, 3 Feb 2015 07:45:14 -0500, rob@xxxxxxxxx wrote:

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