Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    12

    Smile Unanswered: Resouce limit facility

    Hi All,

    Is there a resource limit facility available in UDB DB2 for AIX operating system like the one that is in Mainframes? If not available for AIX, can anybody help me with stopping the queries automatically that exceed the processor limit other than the Query Patroller?

    Thanks
    Milee.

  2. #2
    Join Date
    Feb 2004
    Location
    Copenhagen
    Posts
    220

    Question Governor

    There is a very good resource allocation tool
    called db2 Governor - which is a API that
    creates a surveillance demon in AIX, based
    on a user defined parameter file - look into it !

    PS it is invoked with the db2gov command

    S.Y.
    Kristian K. Hansen
    Project Supervisor
    National Board of Health

  3. #3
    Join Date
    Jun 2004
    Posts
    12
    Thanks

Posting Permissions

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