Basic Concepts

DB2 with BLU Acceleration for SAP

Every time it’s more common SAP environments running with DB2. Attached a video regarding the capabilities of DB2 with BLU Acceleration applied to SAP and all SAP notes to consider. Surprising comparative with SAP HANA, and as with less complexity and investment, you get more performance.

Code example DB2 trigger

Here is an example of syntax of a trigger in DB2. Although the documentation is more than clear, always good to have a concrete example and typical use.

Operations with dates in DB2

The following article shows simple examples of how to operate with dates in DB2 queries.

DUAL Table DB2: sysibm.sysdummy1

Coming from the Oracle world, you know that there is a table “dummy” call DUAL auxiliary operations used to, but in some cases very important. In DB2 this table is called sysibm.sysdummy1.