Re: AFI - Archive Data

[Jeff_Klipa/Harvard@xxxxxxxxxxxxxx]

The file we're aware of that uses relative record numbers to process is
called PMPWC and it is a work file associated with 3-way matching...
The file should always be empty when not in use...  It stores RRNs of
transaction records in the PM module and sometimes it does not get cleared
for some reason...  We can only assume failed 3-way match sessions...  We
have a night job that reports any records found in the file and then clears
the work file...

If the work file never got cleared there is a slight possibility that if
for some reason you did reorg the transaction file and you attempted to
rematch the transactions you could get a false no-hit condition based on
the RRN of the record stored in the PMPWC work file...

That's the only place I'm aware of in JBA where the RRN is used in that
way...  There may be others...

Since we're clearing that file every night (when QINTER is ended) it is not
an issue for us any longer...

Do you have bogus records in your PMPWC file...???  Again there should only
be records in that file while users are running the 3-way match option...

PS - My Farenheight to Celcius conversion table tells me that you're
suffering in 72 degree (F) winter days...
You must have to really bundle up on those trips to the beach...   ;)
Have you ever seen/touched snow in person...!!!???





DAhKow@ibl.intnet.mu on 06/28/2001 08:05:13 AM

Please respond to JBAUSERS-L@midrange.com
                                                              
                                                              
                                                              
  To:          JBAUSERS-L@midrange.com                        
                                                              
  cc:          (bcc: Jeff Klipa/Harvard)                      
                                                              
                                                              
                                                              
  Subject      Re: AFI - Archive Data                         
  :                                                           
                                                              







Talking about space-saving in general, we have written a little routine
that re-orgs all files having deleted records in libraries OSLD1F3,
OSLGLF3, OSLPLF3, OSLSLF3. If anyone knows if this is not safe, can he/she
pls notify us? It seems to me having read somewhere that there are JBA
files that are linked by record number (?)
We have been running this routine weekly since 2 months and no problems
have been reported.
We also ran the standard JBA AFI purge utility on application OE 2 months
ago with more than 20,000,000 records in FIP45. Took some 3 hours to
complete. We first scheduled the purge in Machine Manager, but for a yet
unidentified reason, it didn't run, so we ran it manually. We will try
scheduling it again in the near future.

---------------------------------------------------------------------------
-------------
PS: It's VERY cold now in Mauritius as we are in winter (23-24 degrees
Celsius you know...) and the sandy beaches are still boringly white...
We had a 60% solar eclipse here but that was still very impressive.
---------------------------------------------------------------------------
-------------


+---
| This is the JBA Software Users Mailing List!
| To submit a new message send your mail to JBAUSERS-L@midrange.com.
| To subscribe to this list send email to JBAUSERS-L-SUB@midrange.com.
| To unsubscribe from this list send email to JBAUSERS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: doug333@aol.com.
+---