Is there a way or a workaround to introduce user contingency in DB2 UDB EEE V.7.2?
We have a large number of users, some of them are SQL newbies which can execute any kind of SQL statements.
It happens often that a single SQL statement takes away all the computing resource (CPU, Memory) and clogs up a powerfull machine, so that none of other simultaneously runing statements can get enough resource to be finished.
My question: how can we find a way or exploit some other mechanisms in order to restrict the resource usage by a SQL statement/or a user, so that any statement, regardless small or big, gets a same resource contingency and those killer statements which demand huge resource have to wait or to be killed if their resource contingency is over.
Any help will be appriciated!