Activating Db2 13 function level 500 or higher
When you migrate a Db2 environment to Db2 13, it starts at function level 100. However, many new capabilities in Db2 13 remain unavailable until you activate function level 500 or higher. Also, all new capabilities that depend on Db2 catalog changes in Db2 13 remain unavailable until you activate function level 501 or higher.
Before you begin
Before you activate function level 500 or higher, complete the following prerequisite tasks:
- In Db2 12, identify and resolve incompatible changes and activate function level 510 (V12R1M510). You can run the pre-migration job DSNTIJPE in Db2 12 to identify the incompatible changes. For more information, see Verify Db2 13 premigration activities and activate function level 510 in Db2 12.
- Verify that every member was restarted with the fallback SPE applied in Db2 12. Important: Inactive members that never started in Db2 12 with the fallback SPE (APAR PH37108) applied cannot start after the first data sharing member is migrated to Db2 13 at function level 100.
- Migrate the Db2 subsystem or data sharing group to Db2 13, as described in Migrating your Db2 subsystem to Db2 13 or Migrating an existing data sharing group to Db2 13 .
- Verify that you no longer need to fall back to Db2 12. Important: After function level 500 is activated in Db2 13, coexistence and fallback to Db2 12 are no longer possible. You can activate function level 100* to disable new capabilities in Db2 13, but function level 100* does not support coexistence or fallback .
- In data sharing, ensure that the group has no active Db2 12 members. See Migrating subsequent members of a group to Db2 13.
About this task
The availability of new function in Db2 13 depends on the type of enhancement, the activated function level, and the application compatibility levels of the applications. For a list of all available function levels in Db2 13, see Db2 13 function levels.
- Function level 100
- Db2 starts at function level 100 (V13R1M100) during migration to Db2 13, and fallback and coexistence with Db2 12 in data sharing remain possible. Many new capabilities in Db2 13 remain unavailable. For more information, see Function level 100 (for migrating to Db2 13 - May 2022).
- Function level 500
- Activating function level 500 (V13R1M500) prevents coexistence with and fallback to Db2 12. Function level 500 is also the first opportunity for applications to use many of the new capabilities in Db2 13. However, new capabilities that depend on Db2 13 catalog changes remain unavailable. For more information, see Function level 500 (for migrating to Db2 13 - May 2022).
- Function level 501
- Function level 501 (V13R1M501) is the first opportunity after migration to Db2 13 for applications to use new features and capabilities that depend on catalog changes in Db2 13. For more information, see Function level 501 (Db2 13 installation or migration - May 2022).
Some virtual storage and optimization enhancements take effect in function level 100. Optimization enhancements become available after full prepare of the SQL statements, depending 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.
Tip: After you activate
function level 500, you can activate any higher function level that is available. For a list of
available function levels, see Db2 13 function levels.
Procedure
To activate the initial new function in Db2 13, use one of the following approaches:
What to do next
Complete any of the following actions:
- If the new function level includes optimization enhancements, Db2 must process a full prepare before any SQL statements can benefit. Whether 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.
- If you did not run the jobs to update the APPLCOMPAT and SQLLEVEL subsystem parameters, resolve any application incompatibilities and increase the application compatibility level of your applications after you are satisfied that Db2 is stable at the target function level, as described in Controlling the Db2 application compatibility level.
- If you encounter regressions or other problems when you activate a Db2 13 function level, minimize the impact to your applications while you resolve the problems by following the general approaches described in Responding to problems after function level activation.
- You might need to update COPY, RECOVER, and REBUILD INDEX utility jobs to add new or remove obsolete Db2 catalog objects. When a utility encounters the following situations for Db2 catalog objects, it issues message DSNU1530I:
- The object is no longer used or no longer exists.
- The object is created in a higher catalog level or function level.
For best results, make these updates the utility jobs after you activate the function level that the changes support. For more information about the catalog changes in Db2 13, see Catalog changes in Db2 13.