RE: Reuse deleted records on ICF04PHY

Dave,

There are some neat tools out there that will do your re-org on files for
you. One I know of will do a file in just a few seconds during a nightly
window you define, and only if it can get a file lock at the time. Maybe
this is something you want to get in to. 

Gary

-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of DBarry@xxxxxxxxxxxxx
Sent: Thursday, November 10, 2005 3:18 PM
To: System 21 Users
Subject: Re: [SYSTEM21] Reuse deleted records on ICF04PHY

Our Manufacturing and Distribution  warehouses operate 7/24.  We try to 
avoid locking users out of the system as much as possible.  The trade off 
being files with a lot of deleted records. We've change many of the 
application files to reuse deleted records without issue, but never 
changed any of the IPG libraries. 

Dave Barry
Programming Manager
Dawn Food Products, Inc.
(517) 780-4354




Rick Allen <rick.allen@xxxxxxxxxxx>
Sent by: system21-bounces+dbarry=dawnfoods.com@xxxxxxxxxxxx
11/10/2005 02:04 PM
Please respond to
System 21 Users <system21@xxxxxxxxxxxx>


To
System 21 Users <system21@xxxxxxxxxxxx>
cc

Subject
Re: [SYSTEM21]   Reuse deleted records on ICF04PHY










Dave,

I think you have answered you own question. Why do you only reorg once per
year?

We do all our PF libs, including the IPG**F4 libs, weekly via CLP in MM 
run
for Sunday night. Takes around 40 mins per week and cleans up, on average,
over 3 million deleted records per week. The bulk of these are from S21
work files, MRP and some largeish DRP runs as well as some bespoke addins
we utilise. I couldn't imagine maintaining these records for any longer
than a week.

BR



Rick Allen
Voest Alpine Mining & Tunnelling Pty Limited, IT
Office Phone: +61 (0)2 4985 2622


This e-mail is confidential and it is intended only for the addressees. 
Any
review, dissemination, distribution, or copying of this message by persons
or entities other than the intended recipient is prohibited. If you have
received this e-mail in error, kindly notify us immediately by telephone 
or
e-mail and delete the message from your system. The sender does not accept
liability for any errors or omissions in the contents of this message 
which
may arise as a result of the e-mail transmission.



  
  
  
                                                  To:    
             DBarry@xxxxxxxxxxxxx                        System 21 Users 
<system21@xxxxxxxxxxxx> 
                                                  cc:    
  
                                                  Subject:      
                                                         [SYSTEM21] Reuse 
deleted records on ICF04PHY 
             Sent by:   
             system21-bounces@xxxxxxxxxxxx   
             11/11/2005 02:56 AM   
           Please respond to System 21 Users    
  




Has any one changed the reuse deleted records attribute on ICF04PHY or any
other SM files?  Over time this file gets huge because the storage of the
deleted records is never released until you do a file reorg, which is
about once a year for us.

Dave Barry
Programming Manager
Dawn Food Products, Inc.
(517) 780-4354
_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.



_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.



_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.