Showing posts with label RUNSTATS. Show all posts
Showing posts with label RUNSTATS. Show all posts
Wednesday, March 25, 2026

The Silent Performance Killers in Db2 for z/OS: What You’re Probably Not Monitoring

›
 If you’ve been working with Db2 for z/OS long enough, you’ve likely experienced this scenario. Everything looks fine. CPU is within expect...
Friday, February 13, 2026

Db2 Performance Myths That Refuse to Die

›
After decades of working with IBM Db2 for z/OS , I’m continually surprised that some performance myths simply refuse to go away. Despite new...
2 comments:
Tuesday, November 11, 2025

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 t...
Monday, April 29, 2024

Intelligent Automation of Db2 Administration and Management

›
It is vitally important to ensure that your Db2 databases and systems are running effectively and efficiently. And this requires the diligen...
1 comment:
Thursday, November 09, 2023

Top Ten Db2 Performance Tips – No. 9 Regular Maintenance and Housekeeping

›
When thinking about the performance characteristics of your Db2 databases and applications keep in mind the routine maintenance that can hel...
Thursday, December 17, 2020

Db2 Utilities and Modern Data Management

›
Db2 utilities are the unappreciated, and often over-looked, workhorses of your mainframe Db2 environment. They perform the dirty work that...
Thursday, June 25, 2020

Db2 12 for z/OS Function Level 507

›
This month, June 2020, IBM introduced a new function level, FL507 , for Db2 12 for z/OS. This is the first new function level this year, and...
1 comment:
Wednesday, July 10, 2019

There’s a New Db2 12 for z/OS Function Level (505)

›
In late June 2019, IBM delivered more great new capabilities with the latest new function level for Db2 12 for z/OS, Function Level 505 (...
1 comment:
Wednesday, June 20, 2018

Fast and Effective Db2 for z/OS Test Data Management with BCV5

›
Perhaps the most significant requirement for coding successful Db2 application programs is having a reasonable set of test data to use dur...