Starting in Version 9.7 Fix Pack
3 and later fix packs, DB2® supports
this keyword, which specifies whether dynamic statements that contain
literal values use the statement cache.
- db2cli.ini keyword syntax:
- StmtConcentrator = OFF | WITHLITERALS
- 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.
- Starting in V9.7 Fix Pack 3a, the StmtConcentrator keyword
is supported with DB2 for z/OS® V10.
When you use this attribute against DB2 for z/OS servers
older than Version 10, the request is ignored.