Workload Management - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
rfc1538171534881.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software

If it is desired to manage the Teradata Warehouse Miner database workload, the following points are worth noting. Teradata Warehouse Miner (and each of its derivative products) uses session pooling and therefore maintains more than one concurrent connection to the Teradata database through ODBC. Certain operations may require more than one connection, such as the creation of metadata, which may require 4 connections.

There are different options for limiting the number of concurrent queries:
  • If using the Teradata Workload Manager utility, set the value for User Throttle for Teradata Warehouse Miner to 4 to allow the creation of metadata.
  • If using a Workload Class object, the setting to limit concurrent queries can be as low as 1; it should be possible to create metadata successfully. In this case, however, the expert options tab for each Data Explorer, Matrix and Logistic Regression analysis should be used to limit threads or concurrent queries appropriately. The Decision Tree, however, may require more than one concurrent connection.