Re: JT400/JDBC performance issues

[Dieter.Bender@xxxxxxxxxxx (Dieter Bender)]

Hello,

2-3 seconds to oracle compared to 20 minutes: looks like a bug. 
starting point for me would be:
- use a special user profile for your connect
- WRKOBJLCK <connect user> *USRPRF will show you up the serverjob on the as400
- now you can have a look to the job, what it is doing
I'm not shure wether V4R4 has Group PTFs for the database, but I suppose so. 
There must be a DTAARA SF99xxx showing up the fix level of the database. 
Missing group PTF for the database might cause everyy bug I've ever seen.

Dieter

On Wednesday 19 February 2003 01:28, you wrote:
> 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
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: 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 http://archive.midrange.com/java400-l.

-- 
mfG

Dieter Bender


DV-Beratung Dieter Bender
Wetzlarerstr. 25
35435 Wettenberg
Tel. +49 641 9805855
Fax +49 641 9805856
www.bender-dv.de