Improvements for the dynamic statement cache

Db2 12 extends the scope of statement concentration with literals.

DB2 10 added an enhancement to dynamic statement caching that allowed a Db2 database manager to exclude the literal constants that are in dynamic SQL statements when it searched for a statement text match in the dynamic statement cache. This enhancement could be specified at the statement level, by including CONCENTRATE STATEMENTS WITH LITERALS in the ATTRIBUTES clause of the PREPARE SQL statement. For ODBC and JDBC applications, the statement could also be specified at the data source level through connection properties.

Db2 12 expands the scope of literal concentration enablement. You can specify statement concentration at the package level, through the CONCENTRATESTMT bind option, and at the routine or advanced trigger level, through the CONCENTRATE STATEMENTS WITH LITERALS option.