× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Gerald is the one with the problem
....he should just try it and see if it helps him out
....it will affect each system a little differently
....at the very least he will know it is something he should do from time to
time

It's not really a debate issue

TN


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Oberholtzer
Sent: Thursday, September 13, 2012 1:04 PM
To: Midrange Systems Technical Discussion
Subject: Re: BRMS suddenly requires second tape? - please read

Rob,

If your database is kept reasonably clean the reorg will not reclaim much in
space, but it will impact BRMS performance. There is a price to pay for
BRMS (it varies from system to system, but it will cost more time to do the
backups) keeping track of everything, and the exit programs that get in
between the tape and the save command. I think the overhead is well worth
it particularly in a Domino shop like yours, but there is a price to pay.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 9/13/2012 12:49 PM, rob@xxxxxxxxx wrote:
We run this daily
STRMNTBRM RMVMEDI(*REUSE) PRTEXPMED(*NO) PRTVSNRPT(*NO) PRTBKUACT(*NO)
PRTRCYRPT(*RCYANL *SAVEXCP)

I see we're missing the
RgzBrmDb(*Yes)

From a DSPOBJD to an output file:
SELECT ODLBNM, ODOBNM, ODOBTP, ODOBAT, ODOBSZ FROM routines/dskdt
where odlbnm='QUSRBRM'
ORDER BY odobsz desc

Library Object Object Object Object
Type Attribute Size
QUSRBRM QA1ALI2 *FILE PF 3,635,482,624
QUSRBRM QA1AOD *FILE PF 1,972,502,528
QUSRBRM QA1ADI2 *FILE PF 223,727,616
QUSRBRM QA1A5OD *FILE LF 177,262,592
QUSRBRM QA1ANET2 *FILE PF 173,084,672
...
Deleted
Member Size Records Records
QA1ALI2 3635441664 2615266 597480
QA1AOD 1972465664 2130765 370724
QA1ADI2 223686656 181377 0
QA1ANET2 173064192 0 78184

I can see where that reorg can make a difference. Any drawback to
doing it daily?

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: "Terry
Nonamaker" <TNonamaker@xxxxxxxxxxxxxxxx> To: "'Midrange Systems
Technical Discussion'" <midrange-l@xxxxxxxxxxxx>, Date: 09/13/2012
12:16 PM Subject: RE: BRMS suddenly requires second tape? - please
read Sent by: midrange-l-bounces@xxxxxxxxxxxx Possibly the expired
idea is not the appropriate thought ....but the following should be
run from time to time ....we run it once a week ....you would be
surprised what a difference it can make ....as we had a situation
similar to this when we went to v6r1 StrMntBrm RgzBrmDb(*Yes) Right
now, I can't remember what it was ......but a policy parameter changed
defaults on v6r1 and this was part of it Although the physical tapes
actually expire ....the data containing that info in QUSRBRM does not
get cleared out Try this, I bet it helps TN -----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jim Oberholtzer
Sent: Thursday, September 13, 2012 5:28 AM To: Midrange Systems
Technical Discussion Subject: Re: BRMS suddenly requires second tape?
Interesting thought Terry but I can't think of any process in BRMS
maintenance that might cause an extra tape mount. If one file on the
tape is still current (not expired) then BRMS will not expire the tape
volume either. Still, running BRMS maintenance every day is still a
best practice. Jim Oberholtzer Chief Technical Architect Agile
Technology Architects On 9/13/2012 7:12 AM, rob@xxxxxxxxx wrote:
BRMS tells you what tapes to mount. It's not going to tell you to
mount a tape if the tape has unexpired files on it. For example,
if I use BRMS to back up my daily data and put 14 days retention
on it, and my quarterly data and put 400 days retention on it,
BRMS won't tell me to call Iron Mountain and ask for those tapes
until those days are
past.

I suppose you could have done something outside of BRMS, like
stored a file on there with permanent retention.


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 46755http://www.dekko.com From: "Terry
Nonamaker"<TNonamaker@xxxxxxxxxxxxxxxx> To: "'Midrange Systems
Technical Discussion'"<midrange-l@xxxxxxxxxxxx>, Date: 09/12/2012
05:43 PM Subject: RE: BRMS suddenly requires second tape? Sent by:
midrange-l-bounces@xxxxxxxxxxxx I have not read all the other
responses But, are you sure the tapes are being properly expired
thru BRMS maintenance ......has anything, however subtle, changed
in your normal process that this might not run? Just a thought
Terry Nonamaker -----Original Message-----
From:midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John McKee Sent:
Wednesday, September 12, 2012 2:14 PM To: Midrange Systems
Technical Discussion Subject: Re: BRMS suddenly requires second
tape? I know you esponded that it was not likely. I am wondering
what using the tape less might do to accumulating temporary write
errors. Wouldn't the tape still wear out, even if it took a lot
longer to do so? I was just tossing that out from my ancient
experience with 9 track tape.
Watching the drive toss several feet for a temporary write was
interesting to watch. Running a PRTERRLOG and checking the general
errors and errors specific to tapes from the past few days still
might show something, wouldn't it? I have no knowledge of BRMS,
so, again, this goes back to old experience. John McKee On Wed,
Sep 12, 2012 at
3:42 PM, Gerald Kern<jp2558@xxxxxxxxx> wrote:
> "I'm not a BRMS expert but to me having that QUSRBRM on a
separate
> tape would be a big advantage if you had to do a full system
restore."
>
> Agreed Larry - but the cost for tapes just for that would be
prohibitive.
>
> "Could tape have temporary write errors? I'm wondering if bad
> areas are being skipped."
>
> Not likely John since we use different tapes each day.
>
> " I print this to a PDF file on a daily basis and store it on
3
> servers in multiple countries."
>
> Whoa Rob - I thought I was cool just by having my reports in
pdf's
> in gmail and yahoo...;) But three countries = uber cool!
>
> --
> Thanks, Jerry
>
> Gerald Kern - Information Technology Programming Supervisor
IBM
> Certified RPG IV Developer Lotus Notes/Domino Administrator
The > Toledo Clinic, Inc.
> 4235 Secor Road
> Toledo, OH 43623
> Phone 419-479-5535
> --
--
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.