(Miso Cilimdzic and Sanjeeva Kumar Ogirala) The DB2 pureScale feature for Enterprise Server Edition builds on familiar and proven design features from the IBM DB2 for z/OS database software. This article describes different deployment methods of the DB2 pureScale feature on IBM Power Systems and how

(Robert Catterall) It’s been longer than I like since my last post — a reflection of a particularly busy schedule of late. Today I’d like to focus on catalog statistics as a means of improving query performance in a DB2 for z/OS environment.

(Kate Dawson) One of the most popular features of our Information on Demand Conference each year continues to be FREE Information Management Certification testing. And I can understand why – earning an industry-recognized IBM Information Management certification is a great way to validate your skill

(John Beaven, Barry N. Dow, Robert Maddison and Rebecca Schaller) This article describes how to deploy Master Data Management solutions developed in the InfoSphere Master Data Management Workbench. The approach provides a quick and easy method that enables successful deployments with a minimum of ef

We spend a lot of time building and maintaining indexes, so why not use them wisely? This paper discusses index design issues and query performance topics, including best use of index matching predicates and index screening. In short, it teaches you how to improve SQL performance to save resources,

(Lockwood Lyon) Function use is common in IBM DB2 SQL. However, use and misuse of functions can affect query access paths and performance. Here are a few tips to help you tune IBM DB2 queries and avoid using functions that consume precious CPU resources.

(Bill Griffith) Using the WebSphere Process Server Business Space, you can quickly create a web 2.0 user interface to a business process, and WebSphere Integration Developer tooling actually generates a user interface for you from the definition of your business process. However, you may need to enh

(Henrik Loeser) During the DB2 bootcamp I was teaching I was asked, why DB2 does not offer automatic compression. There are a lot of automatic and autonomous features inside DB2. Why could DB2 not automatically determine that compression makes sense and compress the data?

(Dave Beulke) The improvements in DB2 10 technology are definitely making building performance into business intelligence systems easier. The additional SQL data warehousing extensions such as Rank, Dense_Rank, and Materialized Query tables (MQTs) were great when they came out in DB2 8 and DB2 9. DB

(Albert Wang, Zheng Fei Guo, Jie Ma and Zheng Wei Wang) The ability to integrate with IBM Enterprise Content Management was introduced in IBM Lotus Quickr 8.5 for Domino. In this article we discuss how it works and how to configure and use related features. It’s assumed that you’re familiar with Lot