× 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.



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 

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.