DB2 12 introduces several features useful for the database administrators. This chapter describes the following functions:
9.1 Dynamic plan stability
Dynamic SQL statements allow applications to build SQL statements dynamically at run time. Unlike static SQL statements, the full text of the dynamic SQL statement is not known at the application’s bind time. In an ad hoc query environment, performance ...