Welcome to the Planet DB2 Blog
Sharing best practices and innovative approaches to the continually evolving world of IBM mainframe database and Db2 technology.
The DB2Night Show Z123: Latest news in Db2 Data Studio and DSM
Presented by: Patrick BossmanSTSM, IBM SVL
“The DB2Night Show #Z123: Latest news in Db2 Data Studio and DSM strategic replacement” Replays available in WMV and M4V formats!
100% of our studio audience learned something!Patrick gave a…
Db2 for z/OS: the REST Interface and IN-list Predicates
I’ve written several blog entries on the REST interface to Db2 for z/OS, including one posted early last year. How does it work? Pretty simple: you first code a SQL statement that you want to make REST-invokable; then, you create a REST service associa…
The DB2Night Show #241: The Db2 Access Plan Troubleshooting Handbook
Presented by: John Hornibrook STSM, IBM Toronto Lab
“The DB2Night Show #241: The Db2 Access Plan Troubleshooting Handbook” Replays available in WMV and M4V formats!
100% of our studio audience learned something!John presented how to…
Simplify and Speed Up Your Db2 for z/OS Data Copying and Movement
Register and attend a webinar on efficient Db2 data movement as presented by Craig S. Mullins on February 24, 2022 | 11:00 AM CSTJust about everybody is aware of the phenomenal data growth that organizations are experiencing these days. More data …
Db2 for z/OS Data Sharing: is your Lock Structure the Right Size?
Recently I’ve encountered some situations in which organizations running Db2 for z/OS in data sharing mode had lock structures that were not sized for maximum benefit. In this blog entry, my aim is to shed some light on lock structure sizing, and …
Happy Holidays 2021-2022
Just a quick blog post to wish everybody a very happy holiday season. Whether you celebrate Christmas, Hanukkah, Kwanza, or some other holiday season, all the best to you from me!And a very Happy New Year to one and all. The past couple of years …
DB2Night Show #Z122: Data Gate: Current & Consistent Db2 Data on any Cloud
Presented by Sowmya Kameswaran, Technical Lead, IBM SVL
“The DB2Night Show #Z122: Data Gate: Current & Consistent Db2 Data on any Cloud” Replays available in WMV and MP4 formats!
100% of our studio audience learned something!Somwya i…
Top 10 Steps to Building the Right Indexes
One of the constant struggles with Db2 development, and indeed developing for any relational DBMS, is designing and creating appropriate indexes. Perhaps the most important thing you can do to assure optimal application performance when accessing data …
The DB2Night Show #240: Techniques for Optimal DB Performance Part 1
Presented by Jim Bean, Performance & Forensics, Cigna
“The DB2Night Show #240: Techniques for Optimal DB Performance Part 1” Replays available in WMV and MP4 formats!
100% of our studio audience learned something!In Part 1, Jim prese…
A Systematic Approach to View Creation
Historically, one of the most fertile grounds for disagreement between database professionals was the appropriate usage of views. Some analysts promote the liberal creation and usage of views, whereas others preach a more conservative approach.When pro…
Featured Articles
Accelerating Your Db2 Database
by Larry Strickland
Db2 for z/OS: Why You Might See a Lot of Catalog Access for Package Authorization Checks
by Robert Barnes
Track IBM license usage with AWS License Manager
by Khurram Nizami