Migration and continuous delivery in documentation

The Db2® 12 migration process affects how you will use this information.

Start of changeThe Db2 12 migration process and continuous delivery of new capabilities can affect how you use this information. Before you activate new function in Db2 12, you might need to continue to refer to the documentation for the previous release.End of change

Documentation updates for continuous delivery

Most documentation topics for Db2 12 for z/OS® assume that the highest available function level is activated and that your applications are running with the highest available application compatibility level, with the following exceptions:
The availability of new function depends on the type of enhancement, the activated function level, and the application compatibility levels of applications. In the initial Db2 12 release, most new capabilities are enabled only after the activation of function level 500 or higher.
Virtual storage enhancements
Virtual storage enhancements become available at the activation of the function level that introduces them or higher. Activation of function level 100 introduces all virtual storage enhancements in the initial Db2 12 release. That is, activation of function level 500 introduces no virtual storage enhancements.
Subsystem parameters
New subsystem parameter settings are in effect only when the function level that introduced them or a higher function level is activated. Many subsystem parameter changes in the initial Db2 12 release take effect in function level 500. For more information about subsystem parameter changes in Db2 12, see Subsystem parameter changes in Db2 12.
Optimization enhancements
Optimization enhancements become available after the activation of the function level that introduces them or higher, and full prepare of the SQL statements. When a full prepare occurs depends on the statement type:
  • For static SQL statements, after bind or rebind of the package
  • For non-stabilized dynamic SQL statements, immediately, unless the statement is in the dynamic statement cache
  • For stabilized dynamic SQL statements, after invalidation, free, or changed application compatibility level
Activation of function level 100 introduces all optimization enhancements in the initial Db2 12 release. That is, function level 500 introduces no optimization enhancements.
SQL capabilities
New SQL capabilities become available after the activation of the function level that introduces them or higher, for applications that run at the equivalent application compatibility level or higher. New SQL capabilities in the initial Db2 12 release become available in function level 500 for applications that run at the equivalent application compatibility level or higher. You can continue to run SQL statements compatibly with lower function levels, or previous Db2 releases, including Db2 11 and DB2® 10. For details, see Application compatibility levels in Db2 12

Revision marks for changed content

Start of changeTechnical revisions are marked like this paragraph to identify any of the following types of changes: End of change

  • Changes that are introduced at general availability (GA) in the Db2 12 release.
  • Changes that are introduced by maintenance after the GA of Db2 12.
  • Changes introduced in new Db2 12 function levels.
  • Clarifications in response to customer and internal feedback.

Editorial and organizational changes that do not affect the technical meaning of the content are generally not marked.