By Jeren Mckey , Db2 for z/OS Development, and Guanjun Cai , Db2 for z/OS Content Design Db2 13 for z/OS (Db2) introduced the SQL Data Insights (SQL DI) feature at its GA. The feature infuses artificial intelligence (AI) into the Db2 engine and enables AI queries for...
Does your Db2 system hit its specified MAXDBAT limit regularly? If it does, you might need to evaluate whether your MAXDBAT and CONDBAT settings are configured to allow your Db2 subsystem to run with optimal performance. The MAXDBAT subsystem parameter controls the maximum number of database...
Db2 Administration Foundation for z/OS has been growing in popularity and adding new features requested by Data Studio and DSM Db2z clients. If you're a Db2z database administrator or a Db2 developer who uses with Data Studio or Data Server Manager (DSM), you'll want to learn more about the...
By Sueli Almeida, Dipti Gandhi and Haley Fung Introduction Many leading businesses that have begun their digital transformation journey rely on IBM Z and Db2 for z/OS to run their mission-critical applications and store one of their most valuable assets: their core business data. ...
By Akiko Hoshikawa and Paul McWilliams. The fast index traversal feature of Db2 12 (often called "FTB" for "fast traverse blocks") delivers valuable Db2 transaction performance improvements without the need for application changes. FTBs use a cache-friendly optimized in-memory structure...
In Db2 12, with the PTF for APAR PH19242 applied, you can now use the DSN1COMP stand-alone utility to estimate the space savings that you might realize by compressing your data in Db2 for z/OS table spaces with IBM z14 hardware-based Huffman compression . The capability to compress data...