Welcome to the Planet DB2 Blog
Sharing best practices and innovative approaches to the continually evolving world of IBM mainframe database and Db2 technology.
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…
Password expiration and vacation planning
Ready for vacation: PasswordsThe months of July and August are typical vacation times. Many people work with (at least mental) packing list to prepare for some time off. On my list are passwords. I can relax knowing that no password will expire when I …
How to connect from Python to Db2
One of the recurring questions I have seen is “how to connect from Python to Db2”. I have blogged about Python and Db2 a couple times before. Recently, the question has been popping up again more frequently. From my view, the increased security with ma…
Cloud Security: BYOK vs. KYOK explained
Keep and bring your own keyWhen talking about cloud security and key management systems (KMS) for data encryption, we often hear the terms BYOK and KYOK. But what do they mean and what is the difference? Let me try to explain in this quick write-up. BY…
Keeping Track of Data Movement in Db2 for z/OS
Creating and managing test data for Db2 application development and testing requirements can be a significant challenge. To enable not only the development of new programs, but to be able to maintain existing ones, organizations must ensure that there …
The Big Mistake IBM is Making with Db2 in Containers
Note: the statements in this entry are my opinions. I quote IBM once in this article, and that statement should be seen as the only pure fact here. I invite IBM and others to add their perspective in the comments below. I see IBM making a mistake with how they’re...
Cloud-based HSM with PKCS #11 for Db2 Native Encryption
Manage your encryption keysWhen using Db2 databases, there are a different ways to encrypt the stored data (data at rest). One of them is to use the built-in feature, Db2 native encryption. It supports three kinds of keystores, a local keystore file or…
Db2 for z/OS: Dealing With Application Compatibility Errors (-4743 SQL Error Code)
The notion of "application compatibility," in a Db2 for z/OS context, has been around for a while - it was introduced with Db2 11, which came out in 2013; still, in my experience it's been only recently that a number of Db2 for z/OS administrators have found...
How Many Temporal Tables Does Your Site Have?
Sometimes it can be difficult to remember where information is stored in the Db2 Catalog. Usually, with a little rumination and a little review of Appendix A of the IBM Db2 SQL Reference manual (SC27-8859), you can come up with a solution.For exam…
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