KeepDynamic

KeepDynamic enables or disables optimization for prepared statements by tuning the KeepDynamic bind option (DB2 for z/OS and DB2 UDB for Linux, Windows and UNIX). With the KeepDynamic option enabled, prepared SQL statements are valid even after a commit. Enabling the KeepDynamic option can help improve performance since the SQL statements do not need to be prepared again.

The default value for the KeepDynamic setting is Yes.