× 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.



Walden, John, Shalom, et al,
 
Thanks to all for your assistance and keep the suggestions coming... 
To answer your questions:
 
Yes, all three "O" products are using the same i5 DB2 database and
table (singular at this point), a simple SELECT of all columns so
nothing remotely fancy.   
 
As to a missing index... first, how come the Windows version of the "O"
product screams and the WebSphere version/installations don't.   Second,
until and unless I can get the place to go for putting copies of all
tables frequently queried in an Operational Data Store or Data Mart or
Data Warehouse where they can be tuned with indexes that support common
queries,  I'm stuck with the table and index design of the vendor that
created the packaged applications used most by the business.  
 
I'll look again for any "O" vendor recommended setups for memory,
processor, memory pools, JVM settings, etc.  From what I know, the
systems programmers that installed WebSphere in all instances and the
"O" product installations went by the books of both products.  I'll
recheck.
 
Shalom... you asked "Do the was installations work with a server JDBC
resource?"   I don't understand your question.  What's a server JDBC
resource?   The WAS installs were done according to the documentation on
the WAS product as far as I know.   Now it may be that some pieces of
the WAS install can be segregated so they get better memory and
processor power and that may be easier for a WAS Windoz install but I'd
really like to improve the WAS i5 install because I'd like to stay off
Windoz as much as possible.
 
John Jones... Your recommendations were most detailed and oriented to
an i5.  Super!!  I'll investigate.  
 
Thanks again,
 
Dave Odom
Arizona
 
 
 
 
 

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.