Re: Reuse deleted records on ICF04PHY

As with Dave,  we as well run a 7/24.  And because of our system processes 
and tight shipping schedule we have a minimum daily down time of 8 
minutes.  This intern leaves very little time for doing daily or weekly 
reorgs, we just don't have the time.  Sad to say, but that is what holiday 
weekends are for.  Because of that I have changed every file that has 
major deleted records to reuse.  It just makes sense for us.

Steve



Steven Fuller
Manager of Information Systems
Pullman Industries, Inc.
820 Kirts Blvd.
Suite 400
Troy, MI  48084
(248) 273-5056




DBarry@xxxxxxxxxxxxx 
Sent by: system21-bounces@xxxxxxxxxxxx
11/10/2005 03:17 PM
Please respond to
System 21 Users <system21@xxxxxxxxxxxx>


To
System 21 Users <system21@xxxxxxxxxxxx>
cc

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.