Topic
  • 1 reply
  • Latest Post - ‏2012-08-28T14:25:16Z by Arvind_Gupta
KarthikeyanBaskaran
KarthikeyanBaskaran
6 Posts

Pinned topic .Net - DB2 Connectivity

‏2012-08-24T10:09:21Z |
Hi all,

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:
DATABASE=db_name;SERVER=server_name:port_no;UID={UID};PWD={PWD};

Could you please help me on the above question?

Your help is greatly appreciated!

Thanks,
Karthikeyan.
Updated on 2012-08-28T14:25:16Z at 2012-08-28T14:25:16Z by Arvind_Gupta
  • Arvind_Gupta
    Arvind_Gupta
    58 Posts

    Re: .Net - DB2 Connectivity

    ‏2012-08-28T14:25:16Z  
    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.

    Thanks,
    Arvind