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.
Joe Geller discusses some favorite tuning tips for Db2 in this video recorded at IDUG EMEA in Lisbon last month.
When it comes to tuning a query, program, or even an application that most developers are not sure where to begin or what may be causing response time issue(s). This article is here to help!