Ladies and Gentlemen:

We seem to have a strange performance issue with a (seemingly) simple BIRT report (3 tables, no charts), running within a Tomcat webapp context, under the /QOpenSys/QIBM/ProdData/JavaVM/jdk60/32bit JVM.

The SQL queries feeding the report all execute in a fraction of a second, and yet it's taking over 12 seconds to turn the result sets into a web page.

We're running in a subsystem with a 4G private pool, on a box with a 977.1G system ASP. Increasing the heap size for the Tomcat server doesn't seem to have any effect, and neither does doubling the Max Active for the private pool. WRKSYSSTS shows:
-----DB----- ---Non-DB---
Fault Pages Fault Pages
.0 .0 9.1 34.9
for the private pool.

Any insights?

--
JHHL



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