|
| Name | SQLHELPER_CONNECTION_COUNT | |
|---|---|---|
| Category | Parameter | |
| Type | integer | |
| Access |
R/W(+): Dynamic Read / static and dynamic Write For online temporary change or permanent change, use the |
|
| Group(s) | Concurrency, Database | |
| Description |
This parameter gives the number of connections to open with the database. Its value must be correlated to the total number of threads running in each instance. If the number of connections to the database is too small compared to the total number of threads running in the instance, the threads are not able to render the service because they do not find any available connections to perform their database requests. We recommend that you set this parameter value to the total number of threads used by the instance. But if it is not possible (too many threads in comparison with the DB capabilities), we recommend to reduce the number of threads for the least used services. |
|
| System Instance(s) | rater, updater, guider, bulkLoader, taxer, dispatcher | |
| Default Value | ||
| rater | 20 |
|
| updater | 12 |
|
| guider | 8 |
|
| bulkLoader | 4 |
|
| taxer | 8 |
|
| dispatcher | 16 |
|
| Constraint(s) | ||
| rater |
The parameter must be greater or equal to
((ACTIVATION_THREAD_COUNT + 1) + (CLEANUP_THREAD_COUNT + 1) + MULTICAST_SERVER_THREAD_COUNT + STATEFUL_SERVICE_THREAD_COUNT + STATELESS_SERVICE_THREAD_COUNT + BATCH_SERVICE_THREAD_COUNT + CACHE_WARMUP_THREAD_COUNT)
The parameter must be greater or equal to 1 |
|
| updater |
The parameter must be greater or equal to
(MULTICAST_SERVER_THREAD_COUNT + HTTP_SERVER_THREAD_COUNT + PNR_BULK_THREAD_COUNT)
The parameter must be greater or equal to 1 |
|
| guider |
The parameter must be greater or equal to
(MULTICAST_SERVER_THREAD_COUNT + STATEFUL_SERVICE_THREAD_COUNT + CACHE_WARMUP_THREAD_COUNT)
The parameter must be greater or equal to 1 |
|
| bulkLoader |
The parameter must be greater or equal to
MULTICAST_SERVER_THREAD_COUNT
The parameter must be greater or equal to 1 |
|
| taxer |
The parameter must be greater or equal to
(MULTICAST_SERVER_THREAD_COUNT + STATEFUL_SERVICE_THREAD_COUNT)
The parameter must be greater or equal to 1 |
|
| dispatcher |
The parameter must be greater or equal to
(DISPATCHER_SERVER_THREAD_COUNT + HTTP_SERVER_THREAD_COUNT + MULTICAST_SERVER_THREAD_COUNT)
The parameter must be greater or equal to 1 |
|
Document Version: SP04 and later