Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Question Unanswered: User Contingency in DB2 UDB 7.2?

    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!

  2. #2
    Join Date
    May 2003
    Check out the Chapter called "Using the Governor" in the Administration Guide: Performance.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts