Set Concurrency Limits | Teradata Connector | QueryGrid - Tuning Query Concurrency on Teradata Vantage - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem
  1. From the Workload Designer view, select "" to create a new ruleset.
  2. Enter the name of the ruleset and optionally a description for the ruleset.
  3. Select Save.
  4. Select Throttles.
  5. Next to System Throttles, select the "".
  6. From the General tab, enter a name and optionally a description for the throttle.
  7. Select Save.
  8. Select the Classification tab.
  9. Select Target from the list and select Add.
  10. Select Function from the Target Type list and select TD_SYSFNLIB from the database list.
  11. Enter the name of the function and select Include.
    The name can be exact or you can use an asterisk (*) as a wildcard to indicate any number of characters. For example, you can use QGInitiator* to create a single throttle that matches both QGInitiatorImport and QGInitiatorExport.
  12. Select OK.
  13. Select Save.
  14. Select the State Specific Settings tab.
  15. Under Default Settings, select the box and enter the number of queries to permit simultaneously.
  16. Do one of the following:
    • Select Delay to place queries exceeding the limit in a delay queue.
    • Select Reject.
  17. Select Save.
  18. Do the following to activate the ruleset:
    1. From the Workload Designer view, select "" next to the ruleset that you want and select Make Active.