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:

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.

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.

 

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..

10 Tips for a Successful Cloud Migration

"Paradisiac cloud migration"

Migrating applications, data, and other workloads to the cloud is now commonplace among businesses of all sizes. A 2018 report on cloud computing trends revealed that 92 percent of companies now use public cloud services.
However, cloud migration remains a complex undertaking with several challenges, and getting it right is important. Read on to find out the challenges of cloud migration and ten tips for building a smart cloud migration plan..