1.) Are you using the native driver or the toolkit? There are marked
performance differences between the two when the database is remote.
2.) I would expect a decent impact when you are connecting to a remote
database vs. a local database. Not knowing what your comparison
differences are it's hard to tell if it is in that 'acceptable' range.
When connecting remotely how are you connecting.
3.) I'm drawing a fuzzy right now on the exact details but I would also
check on your prestart jobs (numbers, run criteria for those jobs, etc.)
4.) When you indicated that you have optimized the queries did this
include running the database monitor on the System i and looking at it's
results?
Michael Crump
Manager, Computing Services
Saint-Gobain Containers, Inc.
1509 S. Macedonia Ave.
Muncie, IN 47302
765.741.7696
765.741.7012 f
"A slipping gear could let your M203 grenade launcher fire when you
least expect it. That would make you quite unpopular in what's left of
your unit."
In the August 1993 issue, page 9, of PS magazine, the Army's magazine of
preventive maintenance.
This email and its attachments may be confidential and are intended
solely for the use of the individual to whom it is addressed. Any views
or opinions expressed are solely those of the author and do not
necessarily represent those of Saint-Gobain. If it did, it would be
folded, mutilated, watered down, politically corrected, and would show
up a week later if at all. If you are not the intended recipient of
this email and its attachments, you must take no action based upon them,
nor must you copy or show them to anyone.
Please contact the sender if you believe you have received this email in
error.
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[
mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Muhammad Owais
Sent: Wednesday, April 04, 2007 4:34 AM
To: java400-l@xxxxxxxxxxxx
Cc: java400-l-bounces@xxxxxxxxxxxx
Subject: Performance Issue
Hello;
I have migtated my EJB1.1 application from WebSphere 3.5 to WebSphere
5.1. When I deployed the application on a PC based server that uses
database from AS400, it is very slow. Additionally before migration we
have optimized the queries. Moreover we have upgraded the RAM from 1GB
to 4GB, expecting the performance improvement. Queries execute fine on
Windows based DB2 with 2GB of RAM but on AS400 machine the same queries
completes in a longer time. Furthermore we have also altered the
Machine, Base, Spool and Interactive memory.
Please guide me in optimizing the queries on AS400 DB.
Thanking you in anticipation.
With regards
Allah Hafiz
Muhammad Owais Bilal Awan,
+923002171163
midrange.com
