RE: JT400/JDBC performance issues

Hi Suresh,
We had similar problem with JDBC driver when AS/400 table had Date data type in 
a file. If you have any columns in a file that is defined as L (Date data) you 
must provide instructions for the JDBC driver how to convert them. If you fail 
to specify Date conversion instruction - JDBC driver will start to create a 
temporary copy of your file in a memory and perform some default conversion 
which takes forever. One of the ways to specify conversion instructions for 
JDBC connection is to use a URL with parms as:
jdbc:as400://<your as400 name>;date format=iso

regards,
Alex

-----Original Message-----
From: Suresh kumar BV [mailto:suresh@xxxxxxxxxxxxxxxxxx]
Sent: Tuesday, February 18, 2003 7:29 PM
To: java400-l@xxxxxxxxxxxx
Subject: JT400/JDBC performance issues


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