IBM DB2 12 for z/OS Technical Overview

Administrator function

DB2 12 introduces several features useful for the database administrators. This chapter describes the following functions:

•Dynamic plan stability

•Resource limit facility for static SQL

•Column level deferred alter (pending alter column)

•Insert partition

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 ...