Db2 for z/OS has proven successful for decades not because of any single feature, but because it consistently delivers on the things that matter most for mission-critical enterprise computing. The biggest reasons fall into a few clear and convincing categories.…
Continue
There are a lot of options and parameters to consider when putting together your RUNSTATS jobs to collect statistics on your Db2 data. For those who do not know, RUNSTATS is a Db2 for z/OS utility program that is used to collect information about characteristics of tables and indexes, and storing that data in the Db2 Catalog where it can be used by the Db2 Optimizer to formulate SQL access…
ContinueTRUNCATE is a simple, yet frequently forgotten way to remove data from your Db2 tables.
The TRUNCATE statement is simply a quick way to remove allof the data from a table. The table can be in any type of table space. And the table can be a declared global temporary table. If the tablecontains LOB or XML columns, the corresponding table spaces and indexes arealso truncated.
For clarification, consider the following example:…
Continue
World of Db2 exists to be the one-stop global community for Db2 professionals. Our mission is to connect users, experts, and innovators by delivering the latest Db2 news, sharing technical insights, and fostering collaboration across industries. We provide a central hub where members can learn, discuss, and grow — supporting everyone from students to seasoned DBAs as Db2 evolves in the era of AI, cloud, and digital transformation.
The post Inside EMMA: How a Mainframe Apprenticeship Scaled in Its First Year appeared first on…
ContinueThe post Mainframe Workforce Signals Are Shifting in 2026, Says Early Arcati Workforce Survey Data appeared first on…
ContinueThe post Why Ongoing Education Matters for the Mainframe Skills Gap appeared first on Planet…
ContinueThe post Mainframe Professional Skills Trivia appeared first on Planet Mainframe.
John Campbell - Db2 Legend is retiring on 5th August, here is an opportunity to say "goodbye" and wish him well on his next major mile stone. Learn More
