Re: Performance issue

Tim Rowe, timmr@xxxxxxxxxx
Business Architect Application Development & Systems Management for IBM i
IBM i Development Lab, Rochester, MN
(507) 253-6191 (Tie) 553-6191

http://www-03.ibm.com/systems/power/software/i/are/index.html


Here is a tool we ship with the OS, part of the ARE product.

From your 5250

Enter QSH

Then - /QIBM/ProdData/OS/OSGi/templates/bin/areVerify.sh -network

***Review the report that is generated. If you have DNS issues it will
tell you.

Tim

Tim Rowe, timmr@xxxxxxxxxx
Business Architect Application Development & Systems Management for IBM i
IBM i Development Lab, Rochester, MN
(507) 253-6191 (Tie) 553-6191

[1]http://www-03.ibm.com/systems/power/software/i/are/index.html



----- Original message -----
From: "James H. H. Lampert" <jamesl@xxxxxxxxxxxxxxxxx>
Sent by: "JAVA400-L" <java400-l-bounces@xxxxxxxxxxxx>
To: Java 400 List <java400-l@xxxxxxxxxxxx>
Cc:
Subject: Performance issue
Date: Thu, Jan 12, 2017 2:06 PM

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

--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [2]http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at [3]http://archive.midrange.com/java400-l.




References

Visible links
1. http://www-03.ibm.com/systems/power/software/i/are/index.html
2. http://lists.midrange.com/mailman/listinfo/java400-l
3. http://archive.midrange.com/java400-l