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.

David

The matter of index maintenance is a real one. It does take longer to update when you add another index to a PF. So it is a classic tradeoff. And if possible, they are sharing indexes to the nines. That minimizes the access path update issue.

Centerfield Technology, where Elvis B. works and I used to work, has tools & services to help analyze this index usage.

Vern

At 01:43 AM 3/13/2008, you wrote:

I love hearing about the world outside our company, as I have only ever worked here as a developer.
When you say, " Now we just specify the key needed for the application", you mean the key on the LF?

Would this kind of system be possible for us? We have a lot of users with a lot of interactive applications using the same big PFs. Wouldn't that cost a lot in ressources? I mean, each application would be continually updating all the LF dependant on the physical file?

Thanks a lot for this great practical example, even if it's not a solution for us. I hope other members on the list will follow.

This mailing list archive is Copyright 1997-2024 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.