Re: DASD Recovery

[Chuck Lewis <CLEWIS@xxxxxxxxxx>]

For SURE !!!!!

That reminded me of a situation we ran across several years ago at a shop I was
at.
There was a LARGE physical that had something like 120+ logicals over it (I 
know;
don't EVEN ask - I had NOTHING to do with this <BG>). It was used in an EOM job
that ran for 4-5 hours. Removing the logicals FIRST cut the job to under 10
minutes !!!!

As for members, that is a good one too !

3rd party sales analysis we had would create a member for a user based on a
"view" they selected to inquire with. Theory was, I guess, that they would setup
their 3 or 4 favorites, as would all other users and everyone would have most of
these in common... In reality these files had THOUSANDS of members !!!

We came up with a program to "nuke" them every so often and let users recreate
them (they never really new since this was happening under the covers, plus
turnover was SO high...)

Chuck


Larry Bolhuis wrote:

> Chris,
>   Good Suggestion! (I shoulda remembered this one). Best part is that
> you don't kneed the source this way either!
>
>   THis is also a great tip if you are doing large data loads into a
> database.  Having the LF Members removed can save huge amounts of
> time.  Adding them later will build the Access Paths but that is
> faster than maintaining them on the fly.
>
>   - Larry
>
> Chris Bipes wrote:
> >
> > Just a note on deleting LFs, try removing the members instead of deleting
> > the objects.  The objects are small, the members hold the access paths.
> > When you need the LF again, ADDLFM.  No need to recompile.
> >
>
> --
> Larry Bolhuis         | What do you want to reload today?
> Arbor Solutions, Inc  |
> (616) 451-2500        | Two rules to success in life:
> lbolhui@ibm.net       | 1. Never tell people everything you know.
> +---
> | 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
> +---

+---
| 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
+---