IBM Db2 for Linux, UNIX, and Windows

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 »

Sometimes you might want to test a slow-running query by executing it directly from the command line. And surprisingly, now that the query is executed directly on the database, it has a much better runtime. How can that be? Since this is a question... Read More »

Introduction When you run an SAP Business Warehouse system on IBM Db2 and IBM Db2 BLU Acceleration, it might happen that the column-organized tables in the SAP BW system get fragmented. With Db2 11.5.4, you get new tools for analyzing the level of... Read More »

Introduction With IBM Db2 11.5.6, the Db2 CLI client provides a new “query block prefetch” feature (not to be confused with the Db2 prefetching features on the database server side). In this blog I would like to explain how SAP ABAP stack... Read More »

Introduction This blog provides the guidance for setting up Highly Available (HA) SAP Netweaver 7.5 on IBM DB2 11.5 database in Windows environment. There are 2 ways to achieve HA setup of DB2 DB. Shared Disk based Setup (covered in this blog) HADR... Read More »

Do you know the DBA Cockpit? It’s SAP’s tool for monitoring SAP systems on IBM Db2 for Linux, UNIX, and Windows. It comes to you for free as part of every ABAP-based SAP system. If you already know it, read on, and you’ll learn more about some... Read More »

Simplification, automation and quick response to business needs is a requirement for most of our clients. Typically, customers run a number of SAP systems. Each system consists of one or more database instances (SAP HANA, IBM Db2, Oracle) and... Read More »

Digital Transformation and in particular Artificial Intelligence (AI) offer many opportunities to gain insights from your business data, grow your business or automate processes that were difficult to automate when using traditional methods. Many of... Read More »