Testing Workload Rules
This section includes several recommendations for how to test the WLM rules that you create. It is not an exhaustive set of tests. TIBCO recommends that you design your own tests in addition to the ideas presented here.
From Studio SQL Scratchpad, WLM rule violations can be observed.
Occasionally, you can execute a view and use Show Contents to view rule violation.However, using Show Contents to test is not as reliable as using SQL Scratchpad to test rules.
To test your WLM rules
1. From Studio SQL Scratchpad, run the queries that you expect will touch the resources for which you have WLM rules defined.
2. If rule violations occur, review the errors.
3. Determine which rules are causing the violations.
4. Determine if the best course of action is to modify the:
— WLM rules
— query that uses those resources
5. Re-test with SQL Scratchpad.
6. Repeat tests with SQL Scratchpad until your queries run without unwanted rule violations.
7. Design and run your own set of tests that use your client applications to access data through TDV.
8. Review TDV log files and the data that is returned to your client application.
For example, your client application queries data through TDV where several resources have WLM rules defined and returns the result set as a REST packet to your client application. If there are any violations to the WLM rules, they will be included in the REST packet. Depending on your client application, you might want those messages displayed or you might want them hidden.