Come take a look at the next generation tooling platform that IBM® rolled out in March 2015 to help optimize database performance, detect and solve performance problems, easily administer instances, database objects, and manage data server configurations.
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.
When the DB2 HADR feature is enabled, the primary database's transaction logs are replicated to one or more standby databases in real time. The replication provides HA and DR protection, at a cost. The replication adds overhead to the primary's log writing.
Like many “traditional” DB2 users, CLPPlus has been on my list of things I have to learn for quite some time. Recently I've started to use it, but not for the reasons you might expect. In this article I'm going to describe why I started using CLPPlus and go through the basics of using the tool.
What are some of the things you need to learn, and what things do you need to do to learn them? What follows is my list of the tools, techniques and process of building your DB2 expertise.