Available function levels in Db2 13 z/OS - FL 100 to FL 507 - ruban.de's Db2 Website

Welcome to ruban.de's Db2 Website! Today is: Mai 14, 2025

Available function levels in Db2 13 z/OS – FL 100 to FL 507

Published On: 27. April 2025Last Updated: 27. April 2025Categories: Db2 z/OSTags: Db2 13 z/OS, function levels2,2 min readViews: 77

Function level	New-function capabilities	Details
FL 507	Online conversion of table partitioning from PBR to PBG (PH64949, PH64950) Enhanced application concurrency for system temporal tables (PH65039) LASTUSED column support in SYSIBM.SYSPLAN (PH64762) Referencing temporal and archive-enabled tables in SELECT (PH65133) Specify >64 GB primary/secondary space allocation (PH64760)	Release Date: 2025-04 Catalog Level: V13R1M507 Enabling APAR: PH64907
FL 506	Non-disruptive clearing of data partitions with LOAD (PH62543) Improved performance for IN-list predicates (PH58750) Db2 trace capacity: More concurrently active traces (PH59020) INSERT with multi-row VALUES clause (PH62561) Add implicitly hidden ROWID columns (PH61629) Lift certain restrictions for column masks (PH62393, PH62690)	Release Date: 2024-10 Catalog Level: V13R1M505 Enabling APAR: PH62635
FL 505	New token-based authentication capability (PH55599) Temporal support for security-related catalog tables (PH59531) New trace destination for Db2ZAI (PH56369) INTERPRET scalar function (PH59595)	Release Date: 2024-04 Catalog Level: V13R1M505 Enabling APAR: PH59534
FL 504	Minimized impact of invalidated packages with statement-level invalidation (PH55497) Db2 trace capacity: More OP buffers (PH55622) Utility object-level history (PH55476, PH55914, PH55915, PH55916) Enhancements for SQL Data Insights (PH55212) ORDER BY support for a fullselect that invokes LISTAGG (PH55596)	Release Date: 2023-10 Catalog Level: V13R1M504 Enabling APAR: PH54919
FL 503	New default values in existing rows for added ROW CHANGE TIMESTAMP columns (PH51185) Accelerator-only support for more than 32K elements in an IN list (PH50756) SELECT INTO statement support for OPTIMIZE FOR n ROWS (PH50010)	Release Date: 2023-02 Catalog Level: V13R1M501 Enabling APAR: PH51469
FL 502	Db2 controlled sysplex workload balancing (PH48253) Record dependencies and validity at the statement level for packages (PH47560)	Release Date: 2022-10 Catalog Level: V13R1M501 Enabling APAR: PH47891
FL 501	Allow applications to specify a deadlock resolution priority DEADLOCK_RESOLUTION_PRIORITY global variable Real-time statistics scalability Collection of real-time and historical information about utility execution Real-time statistics support for index splits	Release Date: 2022-05 Catalog Level: V13R1M501 Enabling APAR: None
FL 500	Increased flexibility for package ownership Page sampling for inline statistics SQL Data Insights	Release Date: 2022-05 Catalog Level: V13R1M100 Enabling APAR: None
FL 100	Index look-aside optimization Sort optimization Expanded SORTL usage with learning from execution (IBM z15) Improved locking for INSERT to partition-by-growth (PBG) table spaces Reduced agent local below-the-bar (BTB) storage Reduced ECSA storage use for distributed data facility (DDF) processing Improved storage monitoring and contraction Dynamic management of CF lock storage by IRLM Partition range support in IFCID 306 for users of replication applications Relative page numbering for new PBR table spaces Column names longer than 30 bytes Db2 support for z/OS continuous compliance Subsystem parameter simplification Various new-function APARs	Release Date: 2022-05 Catalog Level: V13R1M100 Enabling APAR: None

editor's pick

you might also like

Don’t miss archive of previous Db2 website
Categories: Db2 LUW, Db2 z/OS, Dev+Ops, general
BMC Mainview for DB2 – List of Views (PDF)
Categories: Db2 z/OS
IBM DB2 for z/OS RSS feed
Categories: Db2 z/OS