(Shalom Momi Sabag) Recently someone approached me and asked for help with a DB2 query that he had, and that query had some real nasty case statements in it, so it got me curious about case statement optimization.

(Nigel T. Crowther, Kallol Ghosh and Jonathon Carr) This two-part articles series introduces the Generic Ruleset Signature pattern. This pattern can be applied to business rules in IBM WebSphere Operational Decision Management V7.5 to improve productivity and maintainability of rules projects using

(Troy Coleman) DB2 10 brings many resource improvements in the area of CPU reduction and virtual storage relief. For instance, Jeff Berger discusses capacity improvements in his article, “DB2 10 Conversion Mode.”

(Craig S. Mullins) When you need to retrieve multiple rows, consider deploying a multi-row fetch to transfer more than one row using a single FETCH statement. This capability was added as of DB2 Version 8.

(Srinivasan R. Mottupalli) In this article, learn to configure the IBM data replication product called IBM InfoSphere Change Data Capture with the extract, transform, and load (ETL) tool InfoSphere DataStage, a component of IBM InfoSphere Information Server.

(Conor O’Mahony) This blog posts refers to the definition of Big Data commonly in use today. I do not include mainframe-based solutions, which some people might argue tackle Big Data challenges.

(Willie Favero) I missed a couple of weeks of posting APARs I think are on interest, those APARs many of you should be tracking in case they affect you. Because it has been a few weeks, today’s post will be slightly longer than usual. I just have lots to tell you about today.

(Marion Behnen and Kavya Rao) IBM DB2 Text Search enables users to create full-text search applications in a DB2 for Linux, UNIX, and Windows database. Full-text search is fully integrated into database query processing, but text-search indices are file system-based, and backup requires synchronizat

(Thuan Bui) See how the database administrator (DBA) at a fictional company uses IBM Query Monitor and Optim Query Workload Tuner to improve customer satisfaction and reduce costs by quickly identifying and tuning SQL performance problems.

(Craig S. Mullins) When DBAs are involved in designing databases that need to support Internet-enabled applications it seems that common sense and data management knowledge frequently fly out the window. Why is this? In today’s post we will investigate the impact of e-business on the design process