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.
Discovered in my dusty email archives, information for an undocumented feature from 2009 to provide a server-side mechanism to manipulate the default isolation level for connections issuing dynamic SQL...
I have a question about the total_extended_latch_wait_time monitor element. We recently saw high values of total_extended_latch_wait_time and we'd like to understand how to interpret this.
Question: I have defined some external stored procedures using Microfocus Cobol in my database and every time I make a change to them, I have to shut down DB2 to get the new version picked up. Is there any better way to do this?
This is true for all external routines that use external,
In Part 1, I talked about some of the first steps that a developer should go through when it comes to tuning queries. In this article, I will go through the initial steps in evaluating a SQL query using the Db2 explain output.