× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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 

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.