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.


Read more »

Tags: , , ,

SQL1046N – The authorization ID is not valid

This error is very common in DB2 though it is not an error usually finds by the database administrators during their tasks, but by applications or technicians during the configuration phase of a new environment. In this article we will see some of the common causes of this error.

Read more »

Tags: ,

DB2 Top 10 SQL by Execution Time

How to obtain the db2 top 10 SQL sorted by Execution time on your database?

Read more »

Tags: ,

DB2 Top 10 SQL by Number of Executions

How to obtain the top 10 SQL sorted by number of executions on your database?

Read more »

Tags: ,

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

Read more »

Tags:

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.

Read more »

Tags: , , ,

DB2 Dates format by region

To give a specific format to the date obtained throught DB2 “current date”, you can use the following method.

Read more »

Tags: ,

Resource Limits between DB2 Express-C versus Oracle XE and SQL Server Express

The free version of DB2 (DB2 Express-C) has much less limitations than those existing in Oracle and SQL Server, Oracle Express Edition 10g/11g and SQL Server 2005/2008 Express.

This article shows this advantage you get with DB2 Express-C compared to Oracle/Microsoft SQL Server.

Read more »

Tags: , , ,

Tuning DB2: Snapshots

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


Read more »

Tags: ,

Rename database DB2

Is common practice to require a replica of a database on another different environment, and also require that the new database has a new name. For example, to update a pre-production database, backing up SAP homogeneous or simply to change the name of the database for any need.


Read more »

Tags: , , ,