Re: Backups taking longer after reorg

Is your reorg process done as part of every nights backup or was that
something you did outside of your backup process and now backups are
running longer?

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Richard Reeve
Sent: Friday, January 08, 2016 9:47 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Backups taking longer after reorg

All,

I did a simple dspfd to an outfile and looked at the percentage of
deleted records to total. I did the reorg on those that had more than 10%
deleted. All of the rebuilding of indexes is done but my backup time is
still 30 minutes longer than it had been. I am NOT using the save while
active stragegy.

I am doing an IPL tomorrow. Don't know what else to do. Any help is
much appreciated.

Rich

On Sat, Jan 2, 2016 at 1:17 PM, Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>
wrote:

Richard,

Are you doing reorg or reorg while active?
We run a similar process using reorg while active.
Reorg will be quicker, but requires exclusive use of the files, and I
believe will cause the index rebuilds.
Reorg while active will be longer, users can remain on, index rebuilds
are less, done concurrently.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Richard Reeve
Sent: Friday, January 01, 2016 10:58 AM
To: Midrange Systems Technical Discussion
Subject: Backups taking longer after reorg

All,

First, let me wish everyone a happy new year. I hope that each
of you is blessed this year with good health and prosperity. Now to
my issue
- I wrote a program that scans through libraries and reorgs files that
have many deleted records. Sounds reasonable enough.....However,
since running this program, my backups are running much longer. Why
would this be? Is there something that I can do to get the time
needed to save these libraries back to a reasonable timeframe?

I have considered saving the libs to a save file and making the
system available while backing the save files up to tape (which I'm
assuming would be faster given the I/o rate of disk vs. tape). But
I'm perplexed as to why the reorg would add time to my backup.

Any thoughts/suggestions are much appreciated.

Sincerely,

Richard Reeve
--
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.

--
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.

--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.
--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.