RE: File Reorg - Cons -- MIDRANGE-L

IMHO, unless you already have an operations automation package with this
kind of tool, it will often be cheaper to take the hit in down-time or buy
the extra disk space!
As I recall from my programming days, the IBM free-ware TAATOOL has a
utility in it that will reorg for you.

Kind regards,

Jeffrey E. Bull
OS400 Software Support Consultant

IBM Certified Systems Expert, iSeries Technical Solutions
IBM Certified Systems Specialist, AS/400 System Administration

*      +44 [0] 149 454 9533               swb.   +44 [0] 149 454 9400
mbl.     +44 [0] 786 750 4961               fax.    +44 [0] 149 454 9454
web.     http://www.itm-group.co.uk
 
ITM Group Ltd, Latimer Square, White Lion Road, Amersham, Buckinghamshire,
HP7 9JQ, United Kingdom


-----Original Message-----
From: fiona.fitzgerald@xxxxxxxxxxxxxxxxxx
[mailto:fiona.fitzgerald@xxxxxxxxxxxxxxxxxx]
Sent: 28 April 2004 11:10
To: Midrange Systems Technical Discussion
Subject: Re: File Reorg - Cons



OSD (OS Director) also handles this well.
It allows you to schedule the file reorgs after hours
- if a reorg would take too long, it doesn't run it.

Considerations;
Reorging a file doubles the size of the file while the process runs (a copy
is created in QTEMP).
Usually it's done when %age used disk space is already high.
It can take hours to complete, depending not only on the file size
but also on the amount of access paths.
And to interrupt a reorg can damage the object.

Or a cheap alternative would be to CPYF filename to copy COMPRESS(*YES)
Compress out deleted records.
CLRPFM the file, then CPYF copy to filename.

Fiona Fitzgerald



 

                      PaulMmn

                      <PaulMmn@xxxxxxxxxxx         To:
midrange-l@xxxxxxxxxxxx                      
                      om>                          cc:

                      Sent by:                     Subject: Re: File Reorg -
Cons                        
                      midrange-l-bounces@m

                      idrange.com

 

 

                      28/04/04 04:44

                      Please respond to

                      Midrange Systems

                      Technical Discussion

 

 





THIS MESSAGE ORIGINATED ON THE INTERNET - Please read the detailed
disclaimer below.
----------------------------------------------------------------------------
-------


Lakeview Technology (of Mimix fame) offers a product that allows you
to reorganize a file while things are live... all it takes is disk
space at least as big as the original file.  The file is reorganized,
along with its logical views.  At a Magic Moment when all activity
against the file has ended, the application swaps out the old file
with the deleted records, and swaps in the shiny new reorganized copy.

It works very well.

--Paul E Musselman




__________________________________

Notice of Confidentiality 

This transmission contains information that may be confidential and that may
also be privileged. Unless you are the intended recipient of the message (or
authorised to receive it for the intended recipient) you may not copy,
forward, or otherwise use it, or disclose it or its contents to anyone else.
If you have received this transmission in error please notify us immediately
and delete it from your system.

Email: internet.mail@xxxxxxxxxxxxxxxx

_______________________________________________
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 e-mail has been scanned for all viruses by ITM. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, 
email marketing@xxxxxxxxxxxxxxx
ITM - Managing Communication and Information through technology
Company registration number - 3783433
________________________________________________________________________


DISCLAIMER

Any opinions expressed in this email are those of the
individual and not necessarily the Company. This email
and any files transmitted with it, including replies and
forwarded copies (which may contain alterations) 
subsequently transmitted from the Company, are 
confidential and solely for the use of the intended recipient. If you are not 
the intended recipient or the 
person responsible for delivering to the intended recipient, 
be advised that you have received this email in error and
 that any use is strictly prohibited.

If you have received this email in error please notify the IT
manager by telephone on +44 (0)870 871 2233 or via 
email to Administrator@xxxxxxxxxxxxxxx, including a copy
of this message. Please then delete this email and 
destroy any copies of it.

________________________________________________________________________This 
e-mail has been scanned for all viruses by ITM. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, 
email marketing@xxxxxxxxxxxxxxx
ITM - Managing Communication and Information through technology
Company registration number - 
3783433________________________________________________________________________