StatementConcentrator IBM data server driver configuration keyword
Specifies whether dynamic statements that contain literal values use the statement cache.
- Equivalent CLI keyword
- StmtConcentrator
- Equivalent IBM® data server provider for .NET connection string keyword
- StatementConcentrator
- IBM data server driver configuration file (db2dsdriver.cfg) syntax
<parameter name="StatementConcentrator" value="Off | Literals"/>- Default setting:
- The default behavior when this keyword is not set is defined by the server-side configuration.
- Equivalent statement attribute:
- N/A
- Usage notes:
- The StatementConcentrator keyword overrides the statement concentrator on the database server.
- Off - The statement concentrator is disabled.
- Literals - The statement concentrator is enabled for situations that are supported by the server. The statement concentrator is not enabled if the statement has parameter markers, named parameter markers, or a mix of literals, parameter markers, and named parameter markers.
When you set the StatementConcentrator keyword against Db2® for z/OS® servers older than Version 10, the request is ignored.