Recent Articles
Posted By: Daniel Luksetich
Tue Jul 24th, 2018
I spend every day of my life since 1990 as a Db2 DBA both on Db2 for z/OS and Db2 for LUW. During that time, I’ve collected a lot of knowledge that makes my job easier and gets easier and gets the answers to the developer’s questions in a timely fashion.
Posted By: Linda Claussen
Fri Jul 6th, 2018
You can create profiles to selectively control groups of distributed (DBAT) threads and connections, set thresholds for query acceleration (not covered in this article) or provide override properties to model your test subsystem to reflect the computing power of your production environment.
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.
