Db2 12 function level support

When you activate new Db2 12 function levels in a Db2 subsystem or data sharing group, enhancements might become available that impact Db2 Admin Tool.

The following function levels are tolerated or supported by Db2 Admin Tool and are provided with the corresponding PTF, if any.

Table 1. Db2 Admin Tool PTFs in support of Db2 12 function levels
Db2 12 function level	Toleration PTF	Support PTF
FL 510	UI75519 (APAR PH36485)	UI75519 (APAR PH36485)
FL 509	UI73968 (APAR PH34152)	UI75241 (APAR PH36481) UI75518 (APAR PH36482) UI75519 (APAR PH36485) Support for specifying a compression algorithm at the object level Support for high availability for accelerator-only tables Support for tamper-proof audit policies Video: Db2 Administration Tool: FL 509 support
FL 508	UI72139 (APAR PH30133)	UI73496 (APAR PH31554) UI76030 (APAR PH36790) Support for moving tables from multi-table table spaces to UTS Usability enhancements for function level 508 Video: Db2 Administration Tool: moving tables from multi-table table spaces into universal table spaces (FL508) (IBM community: Db2 Tools for z/OS)
FL 507	UI70406 (APAR PH25983)	UI71802 (APAR PH28647) UI72418 (APAR PH29663) Support for Db2 12 function level 507
FL 506	UI66622 (APAR PH18697)	UI70405 (APAR PH25686) UI72032 (APAR PH27088) Support for Db2 12 function level 506
FL 505	UI64651 (APAR PH02457)	UI69881 (APAR PH24230) Support for Db2 12 function level 505
FL 504	UI64042 (APAR PH12055)	UI69880 (APAR PH22951) UI70958 (APAR PH27083) UI72419 (APAR PH28566) Support for objects that you can no longer create in Db2 12 function level 504 Video: Db2 Administration Tool: FL 504 support
FL 503	UI64042 (APAR PH12055)	UI69677 (APAR PH22698) Support for IBM® Db2 AI for z/OS®
FL 502	UI64042 (APAR PH12055)	UI69677 (APAR PH22698) Support for key labels
FL 501	UI62635 (APAR PH06164)	UI69451(APAR PH24975)
FL 500	UI62635 (APAR PH06164)	UI69451(APAR PH24975)

The following function levels are tolerated or supported by Object Comparison Tool (an extension to Db2 Admin Tool) and are provided with the corresponding PTF, if any.

Table 2. Object Comparison Tool PTFs in support of Db2 12 function levels
Db2 12 function level	Toleration PTF ¹	Support PTF ¹
FL 510	No additional PTF required	No additional PTF required
FL 509	No additional PTF required	No additional PTF required
FL 508	No additional PTF required	No additional PTF required
FL 507	No additional PTF required	No additional PTF required
FL 506	No additional PTF required	No additional PTF required
FL 505	UI64652 (APAR PH14718)	No additional PTF required
FL 504	No additional PTF required	UI69879 (APAR PH25685)
FL 503	No additional PTF required	No additional PTF required
FL 502	No additional PTF required	No additional PTF required
FL 501	No additional PTF required	UI69452 (APAR PH24976)
FL 500	No additional PTF required	UI69452 (APAR PH24976)

Note:

Because Object Comparison Tool runs as an extension of Db2 Admin Tool, any PTF that is required by Db2 Admin Tool for a particular function level is also required by Object Comparison Tool.