Queries are getting queued when multiple user trying to access Database(Same table) db2 warehouse on cloud

60 Views Asked by At

Queries are getting queued when multiple user trying to access Database(Same table) db2 warehouse on cloud. We are using DB2 Warehouse on cloud and our Analytical report tool is Dundas and Cognos. When multiple user using same Dashboard/report that time all the sqls getting queued and user are not getting response. User does not have option customized backed sqls which generate by report tool. Is there any way we tune the parameter so that we can avoid sqls are geeting queued?

0

There are 0 best solutions below