Migrating DB2 to DB2 10
Before you begin
About this task
- Availability of new function in DB2 10
- Generally, new SQL capabilities, including changes to existing functions, statements, and limits, become available only in new-function mode, unless explicitly stated otherwise. Exceptions to this general statement include optimization and virtual storage enhancements, which are also available in conversion mode unless stated otherwise. In DB2 Version 8 andDB2 9, most utility functions were available in conversion mode. However, for DB2 10, most utility functions become available in new-function mode.
If you need to revert from
enabling-new-function mode (from Version 8 or Version
9) or new-function mode,
you might also use conversion mode* (from Version 8 or Version
9)
or enabling-new-function mode* (from Version 8 or
Version 9).
