Re: AW: Very Slow Run Time on AS/400 for Java Program -- JAVA400-L

I have done exactly the same thing: written a java program that reads a
DB2/400 table and writes to a SQL Server 2000 table, using the same
Microsoft JDBC driver as you.  On my 500 MHz PC it processes about 1000
records per recond. I haven't tried running the program on the AS/400 but
will give it a try. I have run other java programs on the AS/400 and never
experienced slow performance (I'm on V5R1) except once: On V4R3 using Joe
Pluta freeware PDF utility - I haven't tried that on V5R1.) BTW I have
never used the CRTJVAPGM command!

Regards, Leif



                    Mihael Knezevic
                    <m.knezevic@porta.        To:     "'java400-l@midrange.com'"
                    de>                       <java400-l@midrange.com>
                    Sent by:                  cc:
                    java400-l-admin@mi        Subject:     AW: Very Slow Run 
Time on AS/400 for
                    drange.com                Java Program


                    05/23/02 08:57 AM
                    Please respond to
                    java400-l






hi,

i'm just a rookie with java on the as400 and written some simple programm.
i also experienced the same thing. the programm runs really slow on the
as400, not about 10 times, but also really slow. it would be nice if some
could help us out.

thanx.

-----Ursprungliche Nachricht-----
Von: Joyce Louie [SMTP:JLouie@Haemonetics.com]
Gesendet am:   Mittwoch, 22. Mai 2002 19:37
An:  'java400-l@midrange.com'
Betreff:  Very Slow Run Time on AS/400 for Java Program

Hi,

I put my question out on JGuru but got no replies so hopefully you can help
me out here.  I wrote a Java program to Select records (by certain fields)
from an AS/400 file, Delete from an Sql Server table, and then Insert the
selected records to this Sql Server table.
My environment is:  OS/400 V4R5, JDK 1.3, Native JDBC driver (from AS/400
Developer Kit for Java).  I am using the latest versions of the db2_classes
(AS/400), and msbase, msutil and mssqlserver (MS Sql Server) jar files in
my
classpath.  I used QSH javac to create the class for my Java program.  I
then did a CRTJVAPGM at optimization=40 for this class, as well as the 3 MS
Sql Server jar files (I got "unable to create" error when I tried the
CRTJVAPGM on the AS/400 jar file).  I am using blocked fetch (set the block
size to 570, which is a multiple of the total length of my fields), and
batch update (using addBatch and executeBatch instead of executeUpdate in
my
results loop) - both of these coding logic were ones that I found in a JDBC
performance tips document.
The problem is that  the Java program runs VERY slowly on the AS/400
(either
from QSH with java, or with RUNJVA) and uses up alot of CPU resources.  It
runs well over 10 times longer than if I ran it from the PC DOC
environment.
Any suggestions on what could be causing such poor performance when running
the Java program on the AS/400?  I have scanned many Java/400 forums and
websites but am just about out of ideas on what to try next.  My Java
program is virtually useless the way it runs now on the AS/400.  Please
help!
Thanks alot!



_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.

_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
To post a message email: JAVA400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
or email: JAVA400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.