This video is a presentation given at the IDUG DB2 North America Tech Conference in May 2015. It begins with Adrian Burke discussing the challenges associated with tuning dynamic SQL. Then Saghi Amirsoleymani comes in to discuss the features in the no-charge version of IBM Data Studio.
Sometimes we forget. It isn’t so much getting older (I hope) but more that we continue to get busier and busier. With the rush to pick up and handle the new tasks that are thrown our way we sometimes miss the basics. Application design that takes into account performance is one of those basics...
Most relational tuning experts agree that the majority of performance problems with applications that access DB2 are caused by poorly coded programs or improperly coded SQL. A great deal of time is spent on tuning your SQL but how much time are you spending tuning or conducting performance reviews o
Scenario – your query is performing poorly. You see DB2 picked an access path that is less than optimal. First you make sure there are appropriate indexes. You look to see if the statement is written in a way that enables DB2 to use those indexes. Then you check the Filter Factors of the predicates.
Tracing is one of the strongest, but least understood, mechanisms available to you with DB2. It gives you the ability to lift up the hood, helping you determine what is going wrong and why. So don’t be lost for answers when DB2 hangs or consumes to many resources, start tracing. This presentation wi