Re: Backups taking longer after reorg

Full, or change, backup?


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: Richard Reeve <rjrjr64@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 01/08/2016 09:47 AM
Subject: Re: Backups taking longer after reorg
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



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.