IBM Netezza introduced scheduler rules in 18.104.22.168.
These scheduler rules replace the gatekeeper settings from previous releases, and add more capabilities that can help administrators to limit or enforce resource allocation, priority, or plan estimates for scheduling policies to manage how queries obtain and share the system resources.
For example, you can use schedule rules to set the following kinds of workload controls:
- Limit the number of active plans based on the estimated costs for the plans
- Limit the number of active plans based on criteria such as user resource group, priority, user, database, table, client, or other user-defined tags
- Prevent common jobs such as loads or other operations from blocking queues
- Set cost estimates manually for specific queries.
- Prevent specific queries from being flagged as short queries, which can improve queue management
The Netezza admin database user and database users who have the Schedule Rule privilege can create and manage the scheduler rules using SQL commands.
For IBM Netezza systems that upgrade to release 22.214.171.124, the upgrade converts any existing gatekeeper settings in the /nz/data/config/system.cfg file to scheduler rules.
If your Netezza system used customized workload management settings, those settings are now enforced using scheduler rules, and you can display them using the SHOW SCHEDULER RULE SQL command.
Downgrading fromIBM Netezza release 126.96.36.199 or later to a release before 188.8.131.52 removes the defined scheduler rules and replaces them with gatekeeper settings defined in the /nz/data/config/system.cfg file.