IBM Db2 for Linux, UNIX, and Windows

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 »

The DBA Cockpit is a monitoring tool that is available as part of every SAP ABAP-based system. Part of this tool is an easy-to-use EXPLAIN function, which was recently enhanced with a few new features: Explain from section (also called explain from... Read More »

Background   This document in brief about and how to encrypt the SAP system database as part of the client Infosec policy.   Landscape   In order to demonstrate this configuration, the below landscape is required SAP Systems: ECC, SRM,... Read More »