JT400/JDBC performance issues

["Suresh kumar BV" <suresh@xxxxxxxxxxxxxxxxxx>]

Hello,
  We are developing a Java servlet application with AS400 DB2/400 JDBC
connectivity. Here is the configuration we are using as a test:
Web server: This is high end (2GB RAM, 100GN HDD) PC with WIN2K server and
IBM Websphere server 4.01 version running. All images/HTML pages as well as
servets are deployed on this server. We have also deployed JT400 IBM tookit
onto this server for JDBC. Driver used for connection string is AS400JDBC
Driver (as recommended by IBM literature).

DB server: AS400 V4R4 with only 40-50% CPU utilization (means lot of HP
left in the machine).

To start with we have written simple home page servlet which accesses some
data from 3-4 AS400 tables (small tables containing 100 records) using SQL
and JDBC, manipulate the data and then show some intellegent home page
based on AS400 data. When we try to run this, it is extremeely slow. It
took about 20 minutes to get the page.

We simulated the same app with Oracle as backend DB and using Oracle JDBC
drivers. The response is within 2-3 seconds.

What could be the problems?? Do we need to implement some other LIC PGM on
AS400 to make this run faster?? Can we debug this to see where exactly it
is slowing down? Are there any joblogs in AS400 which will give clues as to
why it is slow? Any suggestions on this is most welcome,
Thanx
Suresh

Antares Systems Ltd.
# 24, Sudha Complex, 3rd Stage, 4th Block,
Basaveshwaranagar,
Bangalore - 560 079
Telefax : 91-80-3284311, 3284313