Recent Articles
Posted By: Howard Goldberg
Mon May 7th, 2018
Una de las tareas de administración más comunes dentro de una base de datos de Db2 LUW es la ejecución de Runstats en tablas e índices. Este artículo discutirá algunas de las mejores prácticas relacionadas con la utilería Runstats y algunas técnicas para mejorar el desempeño de esta utilería.
Posted By: Anthony Ciabattoni
Sat Jan 27th, 2018
Whenever a performance problem arises, the database takes the blame, but is that really true? This article will provide a hand's on, step by step approach to determine where the problem is. "Guilty Until Proven Innocent"
Posted By: Eddy Coppens
Mon Jan 15th, 2018
As a DBA you are rather frequently asked whether the database is the same structure-wise all over the different environments. Whenever a decent release management is in place you can be very relaxed answer that this is the fact.
This article will explain how to compare based on SQL.
Posted By: Kurt Struyf
Sun Jan 7th, 2018
In the early days of DB2 for z/OS, pretty much every change to a table would result in an unload-drop-recreate-load of the table. This article will talk about how the ALTER table in DB2 12 for z/OS has evolved from DB2 11 for z/OS and what you need to know from a practical point of view.
In DB2 11
Posted By: Zoltan Toth
Tue Oct 31st, 2017
A database lock is a mechanism utilized by Db2 to govern the access to a database object amongst different transactions. This article describes the locking mechanism for Db2 (for LUW).
