Re: How much space will a reorg add?

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Bill,

From http://www-01.ibm.com/support/docview.wss?crawler=1&uid=nas8N1014683

*Question 10:*How much DASD space does*RGZPFM*use?

*Answer 10:*The answer to this question depends on the*ALWCANCEL*parameter.

Doing an*ALWCANCEL(*YES)*does not actually use any significant space.

Rows are moved from one RRN (relative row number) slot to another RRN 
slot - under commitment control. In the journal for the table being 
reorganized you will see R/DL and R/PX journal entries as the rows are 
moved.

On the other hand, doing an*ALWCANCEL(*NO)*_does_use significant DASD space.

We will create a temporary file in the recovery library (QRECOVERY) as 
one of the steps.
For tables in an iASP, the recovery library name will be*QRCY000xx*, 
where*xx*is the ASP number.

The temporary file for the reorganization will be*QDBRGxxxxx*.

So for a *SYSBAS situation, you should ensure you have enough DASD space 
in *SYSBAS for a duplicate copy of the table.
And in an iASP situation you need that amount of space in the iASP.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /


On 7/10/2019 1:51 PM, Howie, Bill wrote:
> Hello all,
>
> I'm working on doing a reorg of the files from our ERP package.  It's been a very long time since a reorg was done on these files.  What we've done is copy the data library in question over to our test system and we're going to do a test run there and see how long it takes.  One problem.....our test system has about half the storage that our production one does and copying this library over has put us at 97% of disk space usage on our test system.  Our ERP package does allow for us to reorg the files individually.  We hope to get about 90GB back on a system that has 660GB and is 97% full.  We have two schools of thought going on.  Our thought in-house is that we can individually reorg some of the smaller files, and that should buy us enough space to be able to reorg the bigger ones.  Our vendor that hosts our system for us is telling us to clear space ahead of time because of the amount of space that the reorg will add.
>
> Anyone have any experience with how much space a reorg will typically add?  I know that being at 97% is crazy.  I'm just trying to figure out if we have enough space to slowly but surely reduce it down by reorg-ing individual files or if we should really look at clearing other space first.  As always, all your suggestions are greatly appreciated!
>
> Bill
>
> Disclaimer
>
> The information contained in this communication from the sender is confidential. It is intended solely for use by the recipient and others authorized to receive it. If you are not the recipient, you are hereby notified that any disclosure, copying, distribution or taking action in relation of the contents of this information is strictly prohibited and may be unlawful.
>
> This email has been scanned for viruses and malware, and may have been automatically archived by Mimecast Ltd, an innovator in Software as a Service (SaaS) for business. Providing a safer and more useful place for your human generated data. Specializing in; Security, archiving and compliance. To find out more visit the Mimecast website.



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus