RE:JT400/JDBC performace issues

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

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