Re: REORG

Hello,

We've made some research and experiments on reorgs a while ago. Let me
share our experience:

1. The number of deleted records matters as much as the number of LFs
2. Using ALWCANCEL *YES is considerably more time consuming.
3. It is suggested to perform the task in restricted state for a better
performance
4. Even in restricted state, there is a limited number of threads for path
rebuild process. We've optimized it setting all the entries with *OPN and
submitting jobs with OPNDBF command for each one of the paths increasing
the number of parallel threads.
5. The best results came with RBDACCPTH(*OPTIMIZE) ALWCANCEL(*NO) within
the item 4.

This is my own opinion and may not match IBM's.

My best regards,

Bruno A. M. Clemente
Mainframe Support Brazil Team Leader
IT Service Management Foundations Certified (ITIL)
IBM i 6.1 Administration Certified

"Follow the path of the unsafe, independent thinker. Expose your ideas to
the danger of controversy.
Speak your mind and fear less the label of "crackpot" than the stigma of
conformity." - Thomas J. Watson





From: Alan Shore <ashore@xxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 04/01/2016 03:44 PM
Subject: RE: REORG
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



There is a way that you can run RGZPFM with the parameter in the command
of ALWCANCEL *YES
Provided the file you want to do this to is journalled otherwise that file
cannot be touched while the RGZPFM is running,


Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Hoteltravelfundotcom
Sent: Friday, April 01, 2016 2:24 PM
To: Midrange Systems Technical Discussion
Subject: REORG

I am going to run A file reorg, RGZPFM on Sunday early.
my question is, what happens if it's still running at the nightly backup
time which would be nearly 24 hours later?

I don't have figures yet but does it matter if there are large amt of
deleted records or is the time consuming more, if there are multiples of
logicals that have to be rebuilt
--
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.





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