Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: How to kill "queries from hell"?

    Hi,

    I have OLTP system (DB2 UDB v7.2 on Windows 2000) where 95% of SQL works fine, but 5% of SQL does't work fine and about 1% makes me hell. This 1% are analytical queries witch are CPU consuming and I/O consuming queries and last for ever. Is there any settings on DB2 to kill queries witch last for more than 10 secound. So my purpouse is to eliminate the "queries from hell".

    Thanks,
    Grofaty

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Yes, check out "Chapter 9. Using the governor", in the "Administration Guide: Performance."

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,

    Marcus_A, thank you. That is exactly what I need.

    Grofaty

    Originally posted by Marcus_A
    Yes, check out "Chapter 9. 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
  •