Forums

Don't Forget About Histogram Statistics in Db2 for z/OS

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…

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:…

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?…

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. …