Home > Administer Data Miner > Workflow Throughput > Change Number of Concurrent...
Building Mining Models can take considerable machine resources. To help address the level of resources consumed by these operations, The repository property MAX_NUM_THREADS
controls the number of concurrent Mining Model Builds allowed to take place.
The default value of MAX_NUM_THREADS
is 10. MAX_NUM_THREADS
can either be raised or lowered depending on the system capabilities available and the mining model resource demands.
The following example shows how to increase the number of model builds to 15.
Execute this script:
set echo on; -- value of MAX_NUM_THREADS before update select property_name, property_num_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES where property_name = 'MAX_NUM_THREADS'; -- update MAX_NUM_THREADS UPDATE ODMRSYS.ODMR$REPOSITORY_PROPERTIES SET property_num_value = 15 where property_name = 'MAX_NUM_THREADS'; -- commit change commit; -- value of MAX_NUM_THREADS after update select property_name, property_num_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES where property_name = 'MAX_NUM_THREADS';
The following log is produced when you run the script:
-- value of MAX_NUM_THREADS before update select property_name, property_num_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES where property_name = 'MAX_NUM_THREADS' PROPERTY_NAME PROPERTY_NUM_VALUE ------------------------------ ---------------------- MAX_NUM_THREADS 10 -- update MAX_NUM_THREADS UPDATE ODMRSYS.ODMR$REPOSITORY_PROPERTIES SET property_num_value = 15 where property_name = 'MAX_NUM_THREADS' 1 rows updated -- commit change commit commited -- value of MAX_NUM_THREADS after update select property_name, property_num_value from ODMRSYS.ODMR$REPOSITORY_PROPERTIES where property_name = 'MAX_NUM_THREADS' PROPERTY_NAME PROPERTY_NUM_VALUE ------------------------------ ---------------------- MAX_NUM_THREADS 15