IBM Db2 for Linux, UNIX, and Windows

Command Description db2cmd Open DB2 Command line Tool db2cc Open DB2 Control Centre db2start Start Database Normaly db2stop Stop Database Normaly db2stop force Stop Database forcely db2 force application all Close all applications... Read More »

The ABAP Core Data Services (ABAP CDS) framework has been available since NetWeaver 7.40 SP05 and offers highly attractive features & benefits, e.g.: Many new SQL features: SQL joins: INNER JOIN, LEFT OUTER JOIN, … SQL set operations:... 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 »

The FOR ALL ENTRIES clause is OPEN SQL statements is a frequently used feature in ABAP. OPEN SQL statements with FOR ALL ENTRIES clause represent one of the OPEN SQL statement types that contain both database tables and ABAP internal tables. To... 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 »

Hi All, Sharing frequent used DB2 commands DB2Commands: db2stop                       stops the DB2... 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 »

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 »

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 »

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 »