To tune a database is useful to create snapshots that capture information from different structures/components of the instance.

In this post we show how they can be used to perform an analysis of tuning.

First of all, the monitor switches must be on to collect data from the different structures.

The state monitors are available as follows:

Microsoft Azure offers a wide array of storage options for documents, objects, data and media. Companies working with big data need repositories that can hold large amounts of data in one place. Choosing the right storage for your data in Azure can be complicated. Read on to learn about Azure’s offerings for big data, and the appropriate use case for each service..

This article shows the query to obtain the history of DB2 versions and patching. That is, not only shows the current version, but since when is installed / updated.

select versionnumber, version_timestamp

from sysibm.sysversions

The result of the query shows the version history / patch installation:

A 2019 survey by Synopsys found that 96% out of 1100 scanned codebases included open-source components. These open-source components come with some unique issues that could be putting your system at risk. This is particularly true if you’re unaware of their presence.

In this article, you’ll learn some considerations for using open-source components. You’ll also learn how to secure your components and minimize your risks..

Digital information is arguably the most important asset for modern businesses, from financial data to customer demographics. The potential loss of customer or business data carries too heavy a risk to ignore, from regulatory fines to loss of brand trust and customers.

Despite the risks, businesses are using an increasing number of network-connected devices, many of which are not centrally managed or protected. Such devices grant attackers more potential routes into a system and create more points for businesses to protect..

The number and variety of threats to your business and personal data are always increasing. In 2019, attackers have become so sophisticated that it can be a struggle to stay ahead of them. As many as a third of organizations cannot protect their data from cybersecurity threats.
Read on to learn about some of the common data security threats, as well as a number of tools and practices that can help you protect your data in the event of a breach..

Image Source

Every year, digital environments accumulate more and more data. Big data systems take in these huge amounts of raw data, and then turn it into meaningful information. These systems can operate on-premises or in the cloud.

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 FIRST 10 ROWS ONLY"