Hi Duane
I don't have what you are looking for - but I do have some statements about what you wrote (nothing bad - don't worry - just something to make someone think - or for someone else to tell me that I am wrong)
The original intention of this program may have been to recreate the logicals in a better order
For example - if the first logical - logical1 - built over the physical created keys using field A and Field B
Then a subsequent logical -logical2 - was built over the same physical creating keys using field A, Field B AND field C
There would be 2 separate paths created
It would be MUCH more efficient to delete those logicals and re-create them in a different order
Logical 2 THEN logical 1, because logical 1 will use the paths already created with logical 2
At least that was how things were explained to me once
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Duane Scott
Sent: Friday, October 20, 2017 2:39 PM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Questionable practice in file handling in CL
I'm looking at a CL that:
1. deletes the 6 logicals on a single physical file
2. deletes the physical file
3. recreates the physical from the DDS
4. runs an RPG program that writes (20k to 30k) records to the physical
5. recreates the 6 logicals
The only explanation I can come up with is that it once was thought that the system would be faster if the logicals were built one at a time after the physical was built rather than during the running of the RPG program.
Does anybody have stats to back this up.
I think it's not needed and that a CLRPFM on the physical is all that would be necessary and allow each logical to remain during the run of the RPG build program.
Duane
CONFIDENTIALITY NOTICE: This electronic message transmission is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this transmission, but are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this e-mail in error, please contact NALC Health Benefit Plan at 703-729-4677 and delete and destroy the original message and all copies.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
http://amzn.to/2dEadiD
midrange.com
