(Kevin Forsythe) Writing SQL statements that function correctly and deliver the desired results is only half the battle. We also need to manage the performance of those SQL statements. This might involve things such as how we write the statements, what indexes are in use, and what SQL engine is proc

A recording of the live DB2 chat with the lab webinar held in July. (video)

(Susan Visser) Data in Action, the second semi-annual virtual conference August 19 at 8:00 AM PDT / 11:00 AM EDT

(Mike Callaghan and David La Gamba) WebSphere Commerce v6.0 can capture business logic and objects performed at the command level operation via the business auditing framework. This function is useful and, in some cases, is required by business processes. The out-of-box auditing function provided by

(juicedb) I came across two interesting pieces today that I thought are worth sharing… the first is a video podcast –

(Joe Pluta) SQL is not a difficult syntax; it was designed to be relatively easy to use even for non-programmers, and it lives up to that goal. Selecting and sorting data is pretty straightforward: the WHERE clause and the ORDER BY do the heavy lifting. The harder part comes when the user wants to s

(Michael Sansoterra) I enjoyed your article on using .NET to access DB2 on the iSeries. I am trying to extend the functionality of our ERP software with VB.NET 2005/2008. The data is on the iSeries. I plan to use DB2 stored procedures for data retrieval. One of my main stumbling blocks is how to pas

(Kim May) I can finally announce it – it’s finalized – Chris Eaton will be here September 9th for the Baltimore/Washington DB2 Users Group meeting. For me, this is a big, big deal. The turnout for the June meeting was disappointing and the board agrees that the LUW and z/OS track folks really need

(Willie Favero) I learned a new acronym today, one that I think I will be using quite a bit in the months to come. It’s BAO or Business Analytics and Optimization . This is cool on a couple of levels. It’s a concept I’m working with right now and with the addition of BAO I’m only three letters away

(Troy Coleman) Have end users ever told you that response times are slow early in the day, but then return to normal later on? Or perhaps the problem recurs on Monday mornings in shops that bring DB2 down for maintenance each Sunday. After some research, you find that the first SQL statement is taki