In a database system like DB2 there is also a built-in Workload Management. If you are using BLU Acceleration, it is activated by default and some rules have been defined, else it is switched off. Why turn it on and use it? Same reasons as in real life:
- A "fair" allocation of time and resources between different work items/applications is needed ("work / life balancing"?).
- Response time for critical tasks or some type of work is important and needs to be protected against less important tasks ("your mother-in-law visits, take care of her").
- Implementation of rules to control and regulate the system behavior ("kids in bed by 8pm means time for you to watch soccer").
- Deal with rogue queries that threaten regular operations ("kids bring over the entire neighborhood").
- The system (sometimes) is overloaded and you have to set priorities ("no party this weekend").
Does Workload Management help? Yes, it does. However, similar to family life it is possible that because of resource shortage not all planned tasks can be performed. Maybe time for an upgrade ("hire some help, do not get more kids... :)").
I plan to discuss DB2 WLM details in future articles, workload permitting...