Many companies are planning a migration to DB2 11 for z/OS because of the support for expanding the RBA and LRSN. Planning for the expansion is a post-migration task that will require some thought. Let’s take a look at the process.
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
In this session from the IDUG 2014 Technical Conference in North America, Randy Ebersole highlights some of the new features of DB2 11. He introduces some of the new functionality to get you thinking about moving to DB2 11!
We hope that you’ve enjoyed this month’s articles on DB2 performance on z/OS.
We talked about the new performance possibilities in DB2 11, about performance hints and tips for framework development, about explaining tuning to C-level and about efficient ways of replication.