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.
Once you have written a stored procedure or two you'll very soon want to debug it. There's nothing like stepping through the code line-by-line to try to find out what is going wrong. Thankfully IBM Data Studio provides a very good debugger for SQL stored procedures.
With each new release, DB2 is getting smarter and smarter. However, DB2 is not yet clairvoyant enough to understand the intentions of all queries and turn them into optimal forms. What’s the bottom line? Do you need to worry about how you code? The answer is yes, but not as much as in the past.