IBM’s Data Studio holds a lot of features that are not commonly known by the DB2 audience. Many regard it as the replacement of the old Control Center. IBM Data Studio has got a lot of goodies not included in Control Center. In this article we will focus on the usage of physical data models.
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.