|
Dave,I've just barely scratched surface with Websphere, but these Redbooks may provide help.
http://www.redbooks.ibm.com/abstracts/sg246256.html?Open http://www.redbooks.ibm.com/abstracts/sg246417.html?Open http://www.redbooks.ibm.com/abstracts/tips0244.html?OpenYou mentioned Websphere was installed "by the book" - which may be a basic install with no attempt to tune either the iSeries or Websphere. There are no options in the install of the base product as to environment tuning for the installers to do (that i know of). Also, your comparison of the Windows to i5 performance - if the windows environment is doing little else except this, and your i5 is doing other processing, then you must tune your i5 for this workload - and that is more of an i5 work management problem, not a websphere setup problem. It is hard for anyone to offer specific tips without knowing the specific setup. Is this (websphere) Express, or App Server, or Network Deployment, or ND plus Extended Deploy? 6.0 or 6.1 ? with latest correct group ptf applied? plus additional step using update installer?
Latest group ptf for java, hipers, db2 installed? what cume level? How many app servers are configured & running? Which plug-ins? Memory & pool allocations for the QWAS?? subsystem? i5 model? # processors? cpw? cache? And what else is running on this i5? hth jim franz----- Original Message ----- From: "Dave Odom" <Dave.Odom@xxxxxxxxxxxx>
To: <midrange-l@xxxxxxxxxxxx> Sent: Wednesday, November 15, 2006 1:07 PM Subject: RE: Need better WebSphere Application Server Performance for
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 --This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing listTo post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
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.