I recently worked with an insurance company on an interesting issue involving dates. They had a series of records that all had a start date but no end (or cancel) date. The end date of a record was implicitly recognized as the start date of the next highest record. This article will show you how.
As many other I got challenged to set up a database architecture. Not only database objects related, describing the different environments was also asked and there was an urgent need for a decent security setup to support rollouts in general.
In Part 1, I talked about some of the first steps that a developer should go through when it comes to tuning queries. In this article, I will go through the initial steps in evaluating a SQL query using the Db2 explain output.
Performance problems can be tough to solve, especially if you've not had to deal with them much before. In this session from IDUG NA 2016, Steve Rees goes through a step-by-step, decision tree-based approach for tackling performance problems.
The concepts in this article were incorporated into the DB2 Native SQL stored procedures from my own experience in using the log4net utility with several C# applications. My logging examples consist of 3 basic components, and an example on how to add the logging to a DB2 Native SP.