RE: Reuse deleted records on ICF04PHY

Re organize of files is vital. JBA leaves a number of work files with
deleted records. We examine all PF files for more than 1,000 deleted records
and reorganize weekly. There is a JBA utility (RGZDTALIB I think) that does
it but I think it reorganizes based on a % of deleted records which may not
be desirable.

Jim
 

-----Original Message-----
From: system21-bounces+jkerr=gleasoncorporation.com@xxxxxxxxxxxx
[mailto:system21-bounces+jkerr=gleasoncorporation.com@xxxxxxxxxxxx] On
Behalf Of Rick Allen
Sent: Thursday, November 10, 2005 11:05 AM
To: System 21 Users
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.