RE: Reuse deleted records on ICF04PHY

Out where?


-----Original Message-----
From: system21-bounces@xxxxxxxxxxxx [mailto:system21-bounces@xxxxxxxxxxxx]
On Behalf Of forums@xxxxxxxxxxxxxx
Sent: Thursday, November 10, 2005 3:46 PM
To: 'System 21 Users'
Subject: RE: [SYSTEM21] 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.


_______________________________________________
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 electronic mail transmission contains confidential information intended
only for the person(s) and/or organization named. Any use, distribution,
copying or disclosure by or to any other person outside your organization is
strictly prohibited. If you received this transmission in error, please send
an electronic mail message to postmaster@xxxxxxxxxx so we may instruct you
regarding its disposition.