Welcome to the Planet DB2 Blog
Sharing best practices and innovative approaches to the continually evolving world of IBM mainframe database and Db2 technology.
Db2Night Show #Z119: Secure by design
Presented by: Dave Beulke, IBM Gold Consultant and Lifetime IBM Champion
“The Db2Night Show Z119: Secure by design” Replays available in WMV and MP4 formats!
100% of our studio audience learned something!Dave provided design tips for…
To restore or to delete: Working with IBM Cloud resource reclamation
Resource managementOver the past weeks, I provisioned many resources in my IBM Cloud account. Typical to cloud computing, I also deleted and re-provisioned service instances. As part of that work, I dealt with resource reclamation and sometimes restore…
The DB2Night Show #237: Db2 REST — From Movie Recommendation to… Shazam!?
Presented by IBM: Tanmay Bakshi, Advisory Software Engineer
“The DB2Night Show #237: Db2 REST — From Movie Recommendation to… Shazam!?” Replays available in WMV and M4V formats!
91% of our studio audience learned something!Tanmay dis…
Serverless Twitter Bot using IBM Cloud
A Twitterbot at workSome months ago, I discussed cron-like scheduling on IBM Cloud. One of my personal use cases is to send out tweets. In this post, I am going to look into details, into how I implemented a Twitter bot, deployed it to IBM Cloud Code E…
Three Powerful Must Have IBM i 5250 Modernization Solutions
IBM i continues to be a powerful and reliable operating environment. Its rock-solid architecture, 99.9% uptime, transaction speed, and database (DB2) capabilities make it an excellent option for today’s businesses. However, IBM i users still run many of its...
Db2 for z/OS: Package-Related Things of Which You Should be Aware
Db2 for z/OS packages have been around for a long time – since, I believe, V2R3, back in the early 1990s. Even so, I’ve found myself talking more about packages to people lately than I have in quite some years. These discussions – conducted in meetings…
What Type of Changes Cause Db2 Packages to Get Invalidated?
Db2 DBAs are constantly working with database objects such as Databases, Tablespaces, Tables, and Indexes. And many requirements cause DBAs to have to modify these objects. Some modifications may be simple, such as just issuing an ALTER statement. Othe…
SQL to Return the nth Maximum Value
Sometimes what seems like a simple request might take a little bit of thinking to devise and implement a solution. Recently, I was asked how to write SQL that returns the nth maximum value from a column. If you think about it, it isn’t too difficult.As…
CREATE OR REPLACE: Agile Deployment of Db2 for z/OS Stored Procedures
A relatively recent Db2 for z/OS enhancement that might have escaped your notice may well merit your consideration. Here’s what I’m talking about: Db2 12 function level 507 (available since June of 2020, related to APAR PH24371) introduced CREATE …
New IBM Storage Systems Boost Ability to Gain Value from Your Mainframe Data
Gain more value from your mainframe data with IBM StorageEvery year the amount of data that is created continues to expand. Analysts at IDC estimate that data will grow at a compound annual growth rate of 23 percent through the year 2025. Furtherm…
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