RE:JT400/JDBC performace issues

Pooling is provided by WebSphere but you have to configure it in WebSphere 
and code for it in your application.

How many JDBC statements are you executing?  A single SELECT or multiple? 
It seems like the latter since you have so many jobs being started on the 
server.








"Suresh kumar BV" <suresh@xxxxxxxxxxxxxxxxxx>
Sent by: java400-l-bounces@xxxxxxxxxxxx
02/19/2003 03:57 PM
Please respond to Java Programming on and around the iSeries / AS400 
 
        To:     <java400-l@xxxxxxxxxxxx>
        cc: 
        Subject:        RE:JT400/JDBC performace issues


Hi All,
  We have done certain progress on this problem. Let me summarize all
issues: 
  1. Neither Webserver PC nor AS400 is loaded. They both are <= 40%
utilization. As far as the users, this is pilot phase. So, there may be 
1-2
users max.
  2. The web server is remotely accessing AS400. What I mean is that they
are physically apart and hence the request comes thru internet from web
server to AS400.
  3. We have removed even XML DOM logic (even though I always believed 
that
that was not the problem). So, currently this servlet does a connection
string and queries a simple table containing 100 rows and processes the
result set to display a simple HTML screen.
  4. I did not find SF99xxxx DTAARA as suggested by Dieter. Is that a clue
that some PTFs missing?
  5. I personally think that views will run faster with tables especially
with bigger tables. However, this table is very small and hence a non
issue. Mark's other comment about connection pooling. I am under the
impression that this is done by Websphere. However, do I need to setup
anything on AS400 to support pooling?
  6. Dieter is right in the sense we will have to use JT400 toolbox for 
our
application. We can not use native JAR. However, we are using standard 
JDBC
statements as opposed to record level constucts because of standardization
needs and portablity requirements. Also IBM claims that their JT400 
drivers
are as fast as native drivers anyway.
  7. We are not using DATE data types in these tables. Only thing I can
think of is that these are all keyed physical files.
  8. We noticed one strange thing: when we run this task AS400 seems to
start tremendous # of jobs to provide this service. I have pasted the 
AS400
log here. I feel that this will definitely slow it down considerably. No
job log nothing else to go forward. What is the reason for this behaviour?


 Job 918258/QUSER/QZSOSIGN started on 02/15/03 at 18:07:43 in subsystem
QSYSW
*SIGNON server job 918258/QUSER/QZSOSIGN processing request for user 
ACSINC

Job 918258/QUSER/QZSOSIGN ended on 02/15/03 at 18:07:45; 1 seconds used;
end
Servicing job 918257/QUSER/QZDASOINIT for user ACSINC on 02/15/03 18:07:45
i
Job 918259/QUSER/QZSOSIGN started on 02/15/03 at 18:07:48 in subsystem
QSYSW
*SIGNON server job 918259/QUSER/QZSOSIGN processing request for user 
ACSINC

Job 918259/QUSER/QZSOSIGN ended on 02/15/03 at 18:07:48; 1 seconds used;
end
Servicing job 918255/QUSER/QZDASOINIT for user ACSINC on 02/15/03 18:07:49
i
Job 918260/QUSER/QZSOSIGN started on 02/15/03 at 18:07:52 in subsystem
QSYSW
*SIGNON server job 918260/QUSER/QZSOSIGN processing request for user 
ACSINC

Job 918260/QUSER/QZSOSIGN ended on 02/15/03 at 18:07:52; 1 seconds used;
end
Servicing job 918257/QUSER/QZDASOINIT for user ACSINC on 02/15/03 18:07:53
i
Job 918261/QUSER/QZSOSIGN started on 02/15/03 at 18:07:54 in subsystem
QSYSW
*SIGNON server job 918261/QUSER/QZSOSIGN processing request for user 
ACSINC

Job 918261/QUSER/QZSOSIGN ended on 02/15/03 at 18:07:55; 1 seconds used;
end
Servicing job 918255/QUSER/QZDASOINIT for user ACSINC on 02/15/03 18:07:55
i
Job 918262/QUSER/QZSOSIGN started on 02/15/03 at 18:07:56 in subsystem
QSYSW

Advance thanx for any constructive suggestions
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.