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.
Whether you’re considering a bit of spring cleaning on your existing indexes or suiting up for hunting season, the evolutionary improvements in DB2 10.1 and 10.5 provide DBAs with a game-changing set of index management options.
Today volunteer Eddy Coppens of SuadaSoft, talks about his experience of migrating DB2 for LUW, while at the same time changing the collating sequence, resulting in a complex migration project.