RE: Are we insane? Unique use of native DB2 -- MIDRANGE-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de Alan Campin
Envoyé : jeudi 13 mars 2008 18:29
À : midrange-l@xxxxxxxxxxxx
Objet : RE: Are we insane? Unique use of native DB2

Alan Campin :
<snip>
OS/400 will share all the access paths, even on a partial key.
</snip>

Not sure if I fully understand that. If I have :
LF1 KFLD1, KFLD2
LF2 KFLD2, KFLD3
LF3 KFLD1

I would imagine you mean that LF3 shares with LF1 but LF2 would not share. Is that right?

<snip>
I did some consulting at a company two years ago. Saved some 150gb of storage by just recreating indexes and sharing the indexes.
</snip>
In the above example, if I were able to replace LF2 so that it had the same key as LF1, do I reduce the amount of storage needed?

<snip>
This is really an exercise any shop should do. Check to see if you have indexes that could be recreated and would then share an existing access path.
</snip>

How would you start such a check? Go through all the applications to see if a common access path could be created?

Thanks to all for a really interesting discussion.

This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.