Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This section describes the different properties that you can use in the STR to configure EC/ECSAs.

...

For more information about how to use these properties to tune the performance of the Aggregation agent, see 9.2 3 Aggregation Agent in the Desktop User's Guide.

...

Database Properties

PropertyDescription
max.cached.prepared.statements

Default value: 15

If you have want to change the number of preparedStatements that are cached between connections, you can use this property to specify a different number than default.

Note
titleNote!

If you are using SAP HANA as a database type in a Database profile, used by Database agents, this value has to be set to 0.


connectionpool.strict.pool.size

Default value: false

If you enable this property, the database pool enables the Blocking Queue implementation where there is a strict restriction to the maximum number of connections.

Note
titleNote!
When the property is set to false, then the database connection pool will create additional temporary connections. When the pool is full, these connections are closed as soon as the workflow thread returns the connection to the pool.
 


connectionpool.wait.timeout.milliseconds

 


Note
titleNote!

This property can only be used if the connectionpool.strict.pool.size property is set to true.

Default value: 5000

This property is used to configure the amount of time a thread should remain in the  blocked queue until it tries for a new connection. If a connection is made available before this time, the thread's waiting time is interrupted.

...