×
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.
IMO, at least 2 things contribute to good ODBC performance:
1. Appropriate index support for the SQL statements generated. We have
products that address this issue specifically. Ops Nav also has some help
in this area, I believe.
2. Minimize the amount of data that crosses the network, and keep as much
processing on the 400 as possible - this is common to Crystal, as well,
which suggests transferring as much processing as possible to the server,
whatever the type.
In this light, try to control what the SQL looks like. I don't know Cognos,
I use Crystal, and you are able to write native SQL that will run on the
400, instead of summary processing that may run on the PC.
In addition, stored procedures can give much better performance, esp. since
they can limit the amount of data coming down to the PC.
You can find more info
<http://www-1.ibm.com/servers/eserver/iseries/perfmgmt/resource.htm> There
are various performance books there, including
<http://publib.boulder.ibm.com/iseries/v5r2/ic2924/books/as4ppcp8.pdf>,
which, in Chapter 10, has stuff on client/server and remote access. It's
fairly general, with some suggestions.
You can also find an ODBC guide on the iseries access site - one still in
use is old but good, ODBC User's Guide or some such - great stuff on
performance.
HTH
Vern
At 02:14 PM 8/26/2003 -0500, you wrote:
Thanks Gord, and to the others who responded. We connected using the Client
Access driver. What confused me is that they didn't just say "client access
driver". Also, we were referred to a web page that indicated "DB2/400 V4R5
via DB2 Connect 7.1" is also supported.
Management thinks there may be performance issues with ODBC and that one
method of connecting may be better than the other performance-wise. Do you
have any performance issues?
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.
midrange.com
