Setting Up and Configuring Workload Management
Workload management rules that you define are applied to Published resources only.
Users with WLM permissions are allowed to:
• create, update, delete and view workload management rules.
• get effective rules of a user
• get effective rules of a user for a resource
• enable or disable workload management feature
• enable or disable workload management rules
About Global Rules
If a parent container, like SCHEMA, CATALOG or DATA_SOURCE, is chosen, all the children are included in rule.
For member assignments, if a group is chosen, all users in the group are included.
Global member rules are rules without any member assignments and are applied to all users in the system, except the default admin user, users in admin group, dre user and dre_manager. Global resource rules are rules without any resource assignments and are applied to all resources except system resources.
To avoid accidental creation of a global rule, some rules might be disabled when resource assignments or user/group assignments get deleted. For example, assuming a rule has only one user in its user assignments, when the user is deleted, TDV automatic impact analysis disables the rule. If you define a rule that depends on a specific resource and if that resource gets deleted, the rule is automatically disabled. This is to ensure that a rule does not become a global rule accidentally.
To set up and configure workload management
1. Open the TDV Web Manager.
2. From the CONFIGURATION menu, choose Workload Management.
3. Click Add Rule.
4. Type a name and any annotation text that you want to have for this rule.
5. Make sure Enable is selected.
6. Select a rule type:
Rule Type | Description |
Full Table Scan | Allows you to define a rule when a full table scan occurs. |
Memory Limit | Allows you to define a rule based on percentage of memory limit that has been reached. |
Product Join | Allows you to define a rule for a SQL cross join. |
Request Lifetime Limit | Allows you to define a rule based on how long a request has been running. |
Row Limit | Allows you to define a rule based on a maximum number of rows being reached. |
7. Select an action:
Action | Description |
Client Warning | Allows you to create a custom warning message that is sent to the client application. |
Email | Allows you to create an email notification as part of your workload management rule. Some of the rows are returned in the result set and email is sent to email addresses mentioned in the to definition. |
Exception | Allows you to create a custom exception message that will be sent to the client application. An exception message is sent to clients and no result sets are returned. |
Log Server Event | Allows you to create a custom message that will be sent to the TDV Server log files. Some of the rows are returned and messages are written to the cs_server_events.log. |
8. Optionally under Users/Groups, select Add.
Global member rules are rules without any member assignments and are applied to all users in the system, except the default admin user, dre user, dre_manager and users in admin group.
— Type or select the TDV Domain for which you are defining the rule.
— Select User or Group.
— Select the Name from the list of values.
9. Optionally under Resource, select Add.
— Use up arrow or double click the published resource to select one or more of the TDV published resources.
Global resource rules are rules without any resource assignments and are applied to all resources except system resources.
If a parent container, like SCHEMA, CATALOG or DATA_SOURCE, is chosen, all the children are included in rule.
10. Click OK.
11. Click Save.
When a rule mentions a specific resource that is present in the TDV Server, a WLM icon is shown against the published resources in Studio. Also, a tooltip is available for that resource indicating which rule is applied to the resource. For global rules, an icon is not shown.
For adding a New User and managing User Rights see the see the Group and User Rights Template under Understanding TDV User Templates and Rights