(Lockwood Lyon) Information technology must build, support, and tune databases that support business applications such as order entry, accounting, inventory or payroll. For these applications, typical database designs are derived from business rules and application requirements and are modified by e

(Dave Beulke) Doing performance consulting, database system and application tuning exposes me to many different database designs. There are many different aspects to properly analyze a database schema design.

(Sam Lennon) Did you know that the SQL CASE construct can be used in SQL SELECT and UPDATE statements and in WHERE, GROUP BY, and ORDER BY clauses? This tip explains SQL CASE through examples that you can run and experiment with. It also gives an overview of SQL CASE syntax, though it does not attem

(Susan Visser) Today was the second show of the finals for the DB2’s Got Talent 2012 Competition. I wasn’t able to participate, so IBM Champion, Cristian Molaro filled in for me. Like many of you, I’m listening to the replay a few days after the live show.

(Raj Rao) Although it is generally recommended that external application data not be accessed from a rule application deployed to a WebSphere rule execution component, there are certain situations that warrant it.

(Dave Beulke) This week I speak at the Kansas City DB2 Users Group about my 22 billion row data warehouse design and the Agile development teamwork. Without the teamwork the project would not have been successfully implemented in only six months.

(Kavya Rao) In order to leverage the latest capabilities in IBM DB2 for Linux, UNIX, and Windows for full text search, users of DB2 Net Search Extended should migrate to DB2 Text Search. This article explains how to migrate from Net Search Extender to DB2 Text Search indexes, and what to consider wh

(Ember Crooks) Deadlocking is an application problem. There are only a few things that DBAs can do to reduce deadlocking, and they all require buy-in from the application. Let me repeat that another way. Don’t set the parameters mentioned here without understanding the impact on your application.

(Robert Catterall) Sometimes an APAR (in IBM-ese, a description of a software functional enhancement or defect correction effected via application of a fix) is not what it — at first — seems.

(Marc Reed) This document discusses a number of issues that advanced report authors may encounter when they create reports that generate a stitch query (queries that include facts from multiple fact tables).