DB2 with BLU Acceleration for SAP

August 28, 2014,   has blogged 7  posts

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.

DB2TOP replay

February 8, 2013,   has blogged 7  posts

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.

Rename database DB2

January 23, 2012,   has blogged 27  posts

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.

Detecting indexes not used DB2 9.7

January 22, 2012,   has blogged 27  posts

This article shows a method to view the indexes not used in our database since the last reboot. There are another methods to obtain the same information, like the use of the LASTCOLUMN included on 9.7 version. This article will let you know what indexes are not being used, with the waste of resources involved.

Version history DB2

January 21, 2012,   has blogged 27  posts

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.

DB2 top rows

November 16, 2011,   has blogged 7  posts

In this article we will see how to get the first N rows for a Query in DB2. You can do the same with Oracle ROWNUM function and in SQL Server with TOP too.