Re: [SYSTEM21] Re-Use deleted Records

[Greg Staton <statongreg@xxxxxxxxxxxxx>]

I recall an issue with PMP09 if your using three way match and leave open A/P 
sessions overnight.  Three way match uses Relative Record Numbers (RRN) from 
the PMPWC work file to access PMP09.  If PMP09 is reorganized and records exist 
in the PMPWC work file, the RRN's in PMP09 will change hence the RRN pointers 
in PMPWC will not longer be valid....That is the only issue I have encountered 
when reorganizing S21 files.

I hope this helps,
Greg   

-----Original Message-----
From: DAhKow@xxxxxxxxxxxxx
Sent: Dec 15, 2003 3:04 AM
To: System 21 Users <system21@xxxxxxxxxxxx>
Subject: [SYSTEM21]   Re-Use deleted Records

Hi everybody,

        as part of a regular routine, we do reorganise the physical files 
in our OSL libraries to purge deleted records, since some of these files 
have grown to quite large figures and for some of them, the number of 
deleted records is quite a high percentage of the total number of records. 
RGZPFM takes quite some time to complete, especially when there are many 
logicals that have to be re-indexed. We would like to know if would be 
safe to change the 'RE-USE DELETED RECORDS' attributes of such files to 
*YES. Anybody has done that already without any problem? 

Rgds


_______________________________________________
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.