Shared accpths (Was: RGZPFM mistake on a giant file at mid-day).

["Henrik Krebs" <hkrebs@xxxxxxxxx>]

Nedenfor er resultatet af din e-mail formular.
Indsendt af hkrebs@hkrebs.dk

message: >5)    Does RGZPFM ensure that if a logical file can share the access 
path
>of another logical, that it does indeed share it?
>       Even if they were built in a different sequence years ago?

RSTOBJ will do:
Save PF (No accpth) and all LF's. Delete the files. Restore LF's in 
descending-number-of-key-fields order. The job log will show the accpth-sharing.

This procedure should work, and even be automate-able. It is probably too much 
work, but I'm not sure how much can be removed.

Note that sharing accpths might change the order of which you read the records. 
Example: PF has LF1 (Key FIELDA and FIELDB) and LF2 (Key FIELDA, FIELDB and 
FIELDC). PF has multible records with the same content in FIELDA, FIELDB and 
FIELDC. IBM says that the order records in LF1 (whithin one set of FIELDA and 
FIELDB) are read is 'unpredictably'. In practice - with no shared accpth's - 
they are read in arrival seq. But with accpth shared with LF2 the order is 
determined by the content of FIELDC.

Henrik
http://hkrebs.dk
realname: Henrik Krebs
email: hkrebs@hkrebs.dk


REMOTE_HOST: 134.146.0.33

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---