StmtConcentrator CLI/ODBC and IBM data server driver configuration keyword
Db2® supports this keyword, which specifies whether dynamic statements that contain literal values use the statement cache.
- db2cli.ini keyword syntax:
- StmtConcentrator = OFF | WITHLITERALS
- IBM data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="StmtConcentrator" value="OFF | WITHLITERALS"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- The default behavior specified for statement concentration on the server.
- Equivalent environment or connection attribute:
- SQL_ATTR_STMT_CONCENTRATOR
- Usage notes:
- This option specifies whether dynamic statements that contain literal values use the statement cache.
- OFF - The statement concentrator is disabled.
- WITHLITERALS - The statement concentrator with literal behavior is enabled for situations that are supported by the server. For example, 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.