IBM hat am 23. Oktober 2019 den neuen Function Level 506 für DB2 12 for z/OS freigegeben.

Und was steckt drin:

• Alternative function names support:
  To improve compatibility across the Db2 product family, the new alternative spellings shown in the following table are now supported as syntax alternatives for existing built-in functions that are already supported in Db2 for z/OS.
• Support for implicitly dropping explicitly created table spaces:
  • If you drop a base table that resides in an explicitly created universal table space, Db2 implicitly drops the table space along with the table instead of returning an error.
  • If you drop a system-period temporal table or an archive-enabled table, Db2 also drops the associated history table or archive table. If the history table or archive table resides in an explicitly created universal table space, Db2 implicitly drops the table space along with the table instead of returning an error.
  • If you drop an auxiliary table that resides in an explicitly created LOB table space, Db2 implicitly drops the table space along with the table. Previously, the LOB table space remained as an empty table space.
• Activation details for function level 506:
  To learn how to make new capabilities available for use in your Db2 environment, see Adopting new capabilities in Db2 12 continuous delivery.
• Function level 506 incompatible changes:
  When the application compatibility level is set to V12R1M506 or higher, the following changes become effective:
  • Dropping a table that resides in an explicitly created universal table space no longer returns an error. Instead, the table space is implicitly dropped.
  • Dropping an auxiliary table that resides in an explicitly created LOB table space no longer leaves the LOB table space in the database. Instead, the table space is implicitly dropped.

Mehr Infos direkt bei IBM unter DB2 12 for z/OS new function level 506.