IBM Db2 for Linux, UNIX, and Windows

Advanced Log Space Management (ALSM) can help avoid transaction log full situations where applications rarely commit and hold the oldest log file for a very long time. However, ALSM does not guarantee that transaction log full situations never... Read More »

In this blog post, I’m going to explain the Insert Time Clustering (ITC) table type in Db2 for Linux, UNIX, and Windows (Db2 LUW) and show its major benefit: easy space reclamation. I’ll also show you how you can convert regular tables to ITC... Read More »

As databases grow in size, it’s important to periodically reorganize and reduce the tablespaces to maintain performance and optimize storage. As an SAP BASIS consultant, Housekeeping/Cleanup is the essential part of his role which help SAP system... Read More »

During the last weeks of the year, I usually go through my tools to do some cleanup work and compile an annual review. When I did so, I remembered a security vulnerability that kept the whole IT world busy in December 2021 and early 2022. Now that... Read More »

You are new to Db2 administration? Or maybe you are already familiar with successfully running Db2, but want to refresh your knowledge or learn about new features and functions? You prefer watching crisp video clips instead of reading through tons... Read More »

I have good news for Db2 LUW database administrators: We have optimized the local client copy by using the SAPTOOLS.BULK_INSERT procedure. Background A local client copy in an ABAP system loops over all client-dependent tables and copies all rows of... Read More »

SAP systems on an IBM Db2 for LUW database use a connect user and its password in the operating system to connect to the database of the application server ABAP. Most SAP executables use the DBSL to open such connections (for example. disp+work,... Read More »

With this blog post, I’d like to introduce you to the new SAP pre-migration check tool SMIGR_CHECK_DB6. It’s very helpful in the following cases: You want to perform an SAP system copy using the R3load method, for example, to the cloud and keep... Read More »

Introduction Advanced Log Space Management (ALSM) can help avoid transaction log full situations where applications rarely commit and hold the oldest log file for a very long time. Now, you might want to monitor ALSM from time to time. For this... Read More »

Are you using range partitioning for tables in your SAP system running on a Db2 for LUW database? Do you have customized LOB inline settings for special columns on binary column types and want to migrate to the cloud? Then this blogpost’s for you.... Read More »