We are having a .Net application which is accessing the DB2 and we have a separate web service built up for that purpose so that our architecture will be as like: End User -> Web Service -> DB2.
When we are trying to connect to DB2 thro' web service, sometimes connectivity seems to be very slow and consider a situation where we are supposed to fetch a huge amount of data from the dB, say for eg. 20000 rows, it is taking a very long time to get the result set.
Is there any way to check/improve this?
Presently we are using the below kind of Connection String to connect to dB:
Could you please help me on the above question?
Your help is greatly appreciated!
Pinned topic .Net - DB2 Connectivity
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-08-28T14:25:16Z at 2012-08-28T14:25:16Z by Arvind_Gupta
Arvind_Gupta 2700025SKH58 Posts
Re: .Net - DB2 Connectivity2012-08-28T14:25:16ZThis is the accepted answer. This is the accepted answer.Hi Karthikeyan,
Could you please provide below information.
1. DB2 database type, version, DB2.Net provider version, 64 bit/32 bit, operating system details.
2. How much time does it take,
a. When you run query without web services
b. When you run from db2command prompt.
3. How complex your query is? Is it possible for you to give an example.