How to create a Workload Management rule that applies to all users (except admin users and the dre/dre_manager user) and to all resources other than system resources?

How to create a Workload Management rule that applies to all users (except admin users and the dre/dre_manager user) and to all resources other than system resources?

book

Article ID: KB0072020

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 8.0.x and higher.

Description

How to create a Workload Management rule that applies to all users (except admin users and the dre/dre_manager user) and to all resources other than system resources?

Resolution

If  users/groups and  resources are not assigned to a Workload Management rule, it is called a Global rule. The rule will be applied to:
  • All users except for the following:
                   (a)        The default admin user
                   (b)        Users in an  admin group  
                   (c)        The dre user
                   (d)        The dre_manager user.
  • All resources except system resources.
Below is an example of creating a Global rule that restricts the number of rows returned to 7.

Example

(1)   Create a rule to limit the number of rows returned to 7. Do not add any users or groups to the User/Groups/Claims panel, and do not add any resources to the Resources panel.

User-added image

(2)    Connect to TDV using a client application e.g. DBVisualizer. Ensure that the user who is connecting does not belong to an admin group.

User-added image

(3)    Run a query on a table containing more than 7 rows. TDV will return only 7 rows instead of returning all the rows.

User-added image

As the rule's Action is Log Server Event, cs_server_events.log will contain an entry of the type below:

======
2022-08-10 18:38:53.041 -0700    INFO    WorkloadRuleViolation     Workload rule violated : Workload rule 'Rule_for_row_limit'.   Request exceeded 7 row(s).  MyRule: row limit is 7.    22    ann_smith    composite    22101    6640727732165    6640727732165    Workload rule 'Rule_for_row_limit'.  Request exceeded 7 row(s).  MyRule: row limit is 7.
======


 

Issue/Introduction

How to create a Workload Management rule that applies to all users (except admin users and the dre/dre_manager user) and to all resources other than system resources?