Set Concurrency Limits | Teradata Connector | Teradata Fabric - Tuning Query Concurrency on Teradata - Teradata Fabric

Teradata® Fabric - Installation and User Guide - 3.11

Product
Teradata Fabric
Release Number
3.11
Published
August 2026
ft:locale
en-US
ft:lastEdition
2026-08-15
dita:mapPath
svw1780362788070.ditamap
dita:ditavalPath
ezw1784752870623.ditaval
dita:id
lxg1591800469257
  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.