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..
By using the auxiliar table sysdummy1 you can query information about a server with DB2 installed.
Next query shows how to obtain the DB2 server name where the session is connected:
SELECT CURRENT SERVER FROM SYSIBM.SYSDUMMY1
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..
To give a specific format to the date obtained throught DB2 “current date”, you can use the following method.
Get date with European format..
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"
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.
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..
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:
SQL sentence to obtain the SQL TOP TEN with more executions of my BD2 database:
db2 "SELECT NUM_EXECUTIONS as EXECUTIONS,
AVERAGE_EXECUTION_TIME_S as TIME_SECONDS,
STMT_TEXT as TEXT
FROM SYSIBMADM.TOP_DYNAMIC_SQL
WHERE upper(STMT_TEXT) like 'SELECT%'
ORDER BY NUM_EXECUTIONS DESC
FETCH FIRST 10 ROWS ONLY"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.
This work is licensed under a Creative Commons Attribution-Share Alike 4.0 License.