The maximum number of concurrent connections against the Data Warehouse can be set by the means of Job Prioritization per each Database Instance. The limit of allowed connections will be equal to the sum of connections with high, medium and low priority as shown on the figure below.
In this example the total amount of connections against Data Warehouse will not exceed a number of 6. As a consequence, to change the limit the Administrator of the system should adjust the values of connections per each priority.
NOTE:
In a clustered environment the limit is applied per node basis. This means that the total amount of allowed connections against given Data Warehouse for the whole cluster is equal to the sum of the limits on each node and cannot be shared across the cluster. Therefore, if there are 3 nodes in a cluster, each with a maximum of 10 connections against given Data Warehouse, the total amount of connections for the whole cluster against this Data Warehouse will be 30. However, if one of the nodes reaches its limit of connections, it cannot "borrow" a connection from other node.
