World of Db2

Db2 Portal Blogspot

A Few Details on the TRUNCATE Statement

TRUNCATE 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

The Many Types of Mainframe Pricing

Whenever somebody starts talking about software pricing on themainframe, or tuning to save on their monthly mainframe bill, I always wonderjust exactly "what" they are talking about. Are they aware of all their company’slicensing agreements and all the intricacies they contain?…

Continue

Some Under-the-Radar Db2 13 for z/OS Features to Consider

Db2 13 for z/OS has been available for some time now, and soon (December 2025) it will be the only version of Db2 supported by IBM. So, we all should be either using Db2 13 already, or well into the process of migrating to Db2 13.

With that in mind, here are a few a lesser-known but compelling new features in Db2 13 for z/OS. That is, these enhancements have not received as much attention as the more news-hogging AI and performance new features. …

Continue

Mainframe Relevance in an AI-First Era: How Db2 Fits

For decades, the IBM Z mainframe has been the backbone of mission-critical computing. Db2 for z/OS sits at the center of this story, reliably managing the world’s most sensitive and high-value data. Yet in today’s IT landscape, dominated by discussions of artificial intelligence (AI), machine learning, and data-driven transformation, the question inevitably arises: 

Where does Db2 fit in an AI-first…

Continue

PlanetDB2.com [Latest Blogs from the Biggest Names in DB2]

DBTA – Database Trends & Applications

COMMUNITY NEWS & UPDATES

Mission Statement – World of Db2

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.

Join World of Db2 What's App Community

Db2 Performance & Data Sharing Course

LEARN MORE

Upcoming Db2 Course

 

REGISTER NOW

Courses and Workshops

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

 

Db2 NIghtShow

8 Generative AI use cases for the mainframe

Learn More