Slow performance with iSeries and ADO.NET

14 Dec 2006 4:13 PM

Prodevelop

Hi,

we have a .NET 2.0 app that uses DB2 in iSeries. There're some performance
issues with this, because the response average time is about 400ms returning
only few rows. Using stored procedures or calling RPG programs is even slower
(+1,5 sec.)

We've try the following providers:
- ODBC. Poor & slow.
- Datadirect. Best performance, about 10ms per query
- IBM provider for .NET 1.1, that doesn't handle database closes properly.
- Mono. Not signed & we don't know how to run it.
- IBM DB2 Native (throught DB2Connect). It's slow or we don't know how to
run ir properly.

So, the big question is, is there any way to connect .NET 2.0 apps with
iSeries without performance issues??? did anyone used other managed provider
with better performance??

Thanks in advance and sorry about my english

Luis Belloch
http://www.prodevelop.es

15 Dec 2006 8:06 AM

WenYuan Wang

Hi Luis,

According to your description, I understand that you want to know whether
there is another managed provider that can provide more performance for you
to connect DB2 database in .net 2.0 project.
If I misunderstood anything here, please don't hesitate to correct me.

In general, if you work with DB2 database, we would like to suggest you use
the provider from IBM.
But even now, the latest version of DB2 for .net is 1.1. There would be
some issues if you use it in .net framework 2.0.
As far as I know, there are such provider as "ODBC" "IBM provider for .NET
1.1" "Datadirect" that we can used to connect DB2 Database.
In order to get more performance, from the result you mentioned, we would
like to suggest you can use the provider "Datadirect" before the next
version of DB2 for .net (2.0) published by IBM.
(10ms Per Query does not seem very slow.)

If there is anything I can help with, please feel free to reply me. We will
follow up.
I'm glad to work with you.
Best regards,
WenYuan

18 Dec 2006 12:05 PM

luisbelloch

Yes, one of the question was about the fatest provider for DB2 & iSeries.

We have asked IBM about their provider, and we're waiting for an answer.

As a quick solution, we're moving part of the process to RPG, and return
partial results to work with, it seems to be much faster. The rest of the
process will run with .NET & Datadirect. IBM says that the .NET 2.0 Managed
Provider is included with DB2Connect, but we have to test it before decide
anything.

Anyways, thanks for the answer.

Luis Belloch
http://www.prodevelop.es

Show quote

"WenYuan Wang" wrote:

> Hi Luis,
>
> According to your description, I understand that you want to know whether
> there is another managed provider that can provide more performance for you
> to connect DB2 database in .net 2.0 project.
> If I misunderstood anything here, please don't hesitate to correct me.
>
> In general, if you work with DB2 database, we would like to suggest you use
> the provider from IBM.
> But even now, the latest version of DB2 for .net is 1.1. There would be
> some issues if you use it in .net framework 2.0.
> As far as I know, there are such provider as "ODBC" "IBM provider for .NET
> 1.1" "Datadirect" that we can used to connect DB2 Database.
> In order to get more performance, from the result you mentioned, we would
> like to suggest you can use the provider "Datadirect" before the next
> version of DB2 for .net (2.0) published by IBM.
> (10ms Per Query does not seem very slow.)
>
> If there is anything I can help with, please feel free to reply me. We will
> follow up.
> I'm glad to work with you.
> Best regards,
> WenYuan
>
>