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.

Pay attention to the comparison with SAP HANA:

Attached also the IBM Redbook Architecting and Deploying DB2 with BLU Acceleration.

 

DB2TOP register and replay

Actually DB2TOP is a real-time tool, however many DBA’s don’t know that it can be run in REPLAY mode with captured session information. So, next time you have a big crisis with your database, you can capture all the data from db2top and do the analysis afterwards.

How to capture the data? Option -C to capture. Press N to create a file. The option “-m” to gather data during n minutes.

Options db2 command line – Disable autocommit

DB2 command line utility has different options. In this post we show how to disable the autocommit of DML statements that by default is active. In case you want to do some test, for example, simulating the use of locks could be helpful to disable this feature.

Options from DB2 command line can be obtained with the following sentences:

5 Things to Know About the PCI Software Security Framework in 2019

Everyone sells something online, nowadays. Through social media networks, people sell a digital image of themselves to the world. While this image doesn’t often directly translates into money, it can translate into career advancement—through LinkedIn—or brand awareness—through Facebook pages..

The Benefits of Software Composition Analysis

Software Composition Analysis

It was only a few years ago when IT departments were able to manually handle vulnerabilities. Today, disruptive technologies and dynamic approaches to development have changed the digital landscape. Security is no longer the sole responsibility of the IT department. The borders of the security perimeter have been blurred, obscuring the visibility of digital spaces..

Everything you need to know about Amazon EBS

If you’re looking for a user-friendly and cloud-based block storage system, Amazon EBS is the right solution for you. The system integrates with the entire AWS platform, and you’ll be able to use built-in Amazon security, backup and access control features. EBS provides you with four types of volumes for SSD-backed volumes and HDD-backed volumes..