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.