Reoptimization for statements with replaced literal values
When literal values are replaced to concentrate dynamic SQL statements in the dynamic statement cache, Db2 uses the REOPT bind option to determine whether to use the literal values for access path selection.
When SQL statements are prepared and the CONCENTRATE STATEMENTS WITH LITERALS clause is specified, Db2 replaces literal values in the SQL statements with ampersand symbols (&). When this replacement occurs, Db2 uses the literal values in the statement for access path selection only when the REOPT(ONCE) or REOPT(AUTO) bind options are specified. When the default option REOPT(NONE) is specified, Db2 does not consider the literal values for access path selection.