[EMAIL PROTECTED] wrote:
hello,
I'm having a performance issue with a Windows CLI/ODBC application
that connects to a DB2 rel 7.1 on a mainframe of a bank.
I have to say I'm pretty new with this kind of environment. And I
don't know the details of the HW of the host. I just know it's an host
of a bank (and I expect it is expensive).
The application is working, but it is much slower than when I run
against a DB2 7.1 on a poor Linux machine(using the same amount of
data in the tables used by the application).
I made some trace and I found the most noticeable difference is in the
time of the SQLExecute. Against the Linux is not relevant (the same
millisecond), against the mainframe it tooks an average of 2 cent of
sec.
Do you mean 2 percent of a second, or 0.02 seconds?
This mainframe also has a long time in execution of SQLTables and
SQLColumns (almost 15 sec both), so that I've already fixed my
application to check for table existency and for information on the
columns, using a dummy select and SQLDescribeCol.
I'm now in dubt if:
-I have to reengineer the logic of the application or
-the fact it run faster on a poor Linux machine meas that there are
some problems with something outside of my app
thanks in advance to anyone who can answer
LD
What is the connection between your Windows box and the z/OS box?
When running against Linux, what is the network connection?
How much data is returned?
What has the z/OS DB2 system programmer said?
There are a lot of other factors that would need to be looked at. A
"poor" linux box running nothing but DB2 could out perform a z/OS box
that is running 5, 10, 20, 100 other applications that are doing 100,
1,000, or 10,000 of transactions a second.
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO
Search the archives at http://bama.ua.edu/archives/ibm-main.html
