DB2 Workload Manager for Linux, UNIX, and Windows

Readers' comments

Readers' comments (2) 

lockedThis discussion is now locked


Posted by Michael Tiefenbacher on 28 May 2008 at 3:00

Hi

there is someting strange in the description of Thresholds. The book states that the threshold domain includes Work Actions. (page 16)
But on page 17 the domain is referenced as Work Action Set.
In the CREATE WORKLOAD command there is NO way to specify either a work action nor a work action set.

Can someone (of the authors) clarify that?

Thanks in advance
Michael

Posted by Bill Comeau on 29 May 2008 at 12:06

Hi Michael ...

Because work actions (sets) can be applied at different levels the thresholds are actually incorporated into the CREATE WORK ACTION SET command. Here is an example:

CREATE WORK ACTION SET myactions FOR DATABASE
USING WORK CLASS SET myclasses
(WORK ACTION stop_large_read_wa ON WORK CLASS read_wc WHEN ESTIMATEDSQLCOST > 1000000 STOP EXECUTION)

Page 18 talks more about this and there are more examples later in the book.


Profile

Publish Date
19 May 2008


Rating:
(based on 1 review)


Author(s)

ISBN-10
0738485381

IBM Form Number
SG24-7524-00