IBM TechXchange Community Together, we can connect via forums, blogs, files and face-to-face networking. Find your community
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...