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:
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
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"
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.
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:
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.
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..
Cloud computing is the new normal. Every time you are using a service or an application through an internet connection, you are using the cloud. Since most companies nowadays have part or all their databases hosted on the cloud, you ask how is the best way to do it. Migrating your database to the cloud can help you manage your workload by making your data available and easily scalable. Read on to learn about database cloud migration and tips to do it right..
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 Unported License.