Databases

DB2 Top 10 SQL for execution time

SQL Command to obtain the Top Ten of SELECT SQL sentences with more execution time in your DB2 database:

db2 "SELECT AVERAGE_EXECUTION_TIME_S as TIME_SECONDS, NUM_EXECUTIONS as

EXECUTIONS, STMT_TEXT as TEXT FROM SYSIBMADM.TOP_DYNAMIC_SQL WHERE

upper(STMT_TEXT) like 'SELECT%' ORDER BY AVERAGE_EXECUTION_TIME_S DESC FETCH

 

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.

 

Best Practices for Your Data Loss Prevention Policy

Data Loss Prevention (DLP) is the practice of implementing policies and tools for the purpose of protecting business information against data exfiltration, data breaches, and data corruption. A DLP policy defines the process, while a DLP solution implements some or all aspects of the policy..