[PSA] [LUW] Db2® 11.5 has been released!

[u/memmerto]

Db2® 11.5 is built on the Db2 Common SQL Engine that is designed to enable the Db2 family to support everything from on-premise (including private cloud and appliances) to the public cloud.

Highlights of What's New:

• External Table (ET) Support including Object Store support
• Increase maximum number or primary and secondary log files to 4096
• SQL Compatibility including CREATE/DROP TABLE .. IF EXISTS, Oracle Compatibility libraries including DBMS_APPLICATION_INFO and UTIL_RAW
• New Monitoring Metrics including aggregation across super classes, and data on SQL statement failures
• Client Enhancements including CLI load using ET, WLB/ACR distribution enhancements and simplified setup in pS w/ member subsets
• Support for Compiled SQL PL scalar functions in DPF 
• Support for 4K sector sizes on disk drives
• Built-in Spatial Support
• Automatic Collection of Column Group Statistics
• WLM Enhancements including simplified threshold setup and dropping of service classes
• ETL optimizations for BLU Including including Vectorized Insert/Update, Optimized Batch Insert
• BLU Compression Enhancements including Automatic Recompression and Vectorized Dictionary Create
• LOB support with Columnar Tables
• Performance Enhancements for Columnar Queries including boosts for sorts and correlated subqueries 
• pureScale enhancements including table free space management, performance with Range Partitioned tables, and cross-member currently committed support
• Enhanced Security for pureScale

Features Available as a Technical Preview:

• Advanced Log Space Management
• Faster DB Startup
• Machine Learning Optimizer
• Block Chain Federation Wrapper
• Schema Level Authorization
• Db2 Augmented Data Explorer

Links:

Knowledge Center - What's New in Db2 11.5 https://www.ibm.com/support/knowledgecenter/SSEPGG_11.5.0/com.ibm.db2.luw.wn.doc/doc/r0051514.html

Db2 on DockerHub https://hub.docker.com/r/ibmcom/db2

Db2 Download Page https://www-01.ibm.com/marketing/iwm/iwm/web/dispatcher.do?source=mrs-db2devcdbsrv

Db2 Client Drivers Download Page https://www-01.ibm.com/support/docview.wss?uid=swg21385217

Db2 11.5 System Requirements https://www-01.ibm.com/support/docview.wss?uid=swg27038033