IBM Db2 for Linux, UNIX, and Windows

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 avoiding transaction log full situations where applications rarely commit and hold the oldest log file very long. Now, you might want to monitor ALSM from time to time. For this purpose,... 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 »

According to IBM Cost of a Data Breach Report 2021, which examines ways to mitigate risks: Data breach costs also rose from USD 3.86 million to USD 4.24 million, the highest average total cost in the 17-year history of this report. Among top... Read More »

You have an SAP system running on an unencrypted Db2 database and want to encrypt your existing database? To do so, you can create a backup image and restore it into an encrypted database. But what about potential downtimes that come with it? The... Read More »