Is there a good way to lower the priority of a query that is expected to run for several hours?
On Tuesday, July 24, 2018 at 11:38:38 AM UTC-7, Kdawg wrote:
Is there a good way to lower the priority of a query that is expected to run for several hours?
Db2 Workload Management (WLM) is the best solution for this, but there is a relatively steep learning curve to implement it (and of course you need to be using an edition of Db2 which includes this feature).
On Wednesday, July 25, 2018 at 2:24:11 PM UTC-4, Ian wrote:
On Tuesday, July 24, 2018 at 11:38:38 AM UTC-7, Kdawg wrote:
Is there a good way to lower the priority of a query that is expected
to run for several hours?
Db2 Workload Management (WLM) is the best solution for this, but there
is a relatively steep learning curve to implement it (and of course you
need to be using an edition of Db2 which includes this feature).
What are the other alternative "non-best" solutions? Assuming someone
does not have WLM.
Is there a good way to lower the priority of a query that is expected to
run for several hours?
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 285 |
Nodes: | 16 (2 / 14) |
Uptime: | 60:19:28 |
Calls: | 6,488 |
Calls today: | 1 |
Files: | 12,094 |
Messages: | 5,274,348 |