(Rajesh Sambandhan and Simon Harris) IBM recently announced Data Studio pureQuery Runtime for z/OS, which enables organizations to take advantage of pureQuery technology natively on their z/OS systems. Previously, pureQuery could access DB2 for z/OS data only from a non-z/OS system, such as Windows

(Willie Favero) Absolutely. However, don’t get to overly concerned right now. If it should happen to you, and we are about to discuss if you are a possible candidate, DB2 Level 2 support knows what to do to help you out of that situation.

(Craig Mullins) Recently I was reading through some posts in a database-related newsgroup or mailing list (actually, right now I can’t remember which one it was). The conversation I was reading was in response to a question like “Does the number of columns or size of the row matter in terms of perfo

(Michael Rajkowski and Nik Kesic) Good data governance practices and regulatory compliance requires securing data while in motion to prevent eavesdroppers from viewing sensitive information. IBM UniData and UniVerse (U2) provide the tools that conform to open encryption and SSL standards that enable

DB2 Row Compression (also known as Deep Compression) is a hot topic of discussion in db2 circles since the release of v9.

(Tyler Even) If you’ve used the DB2 Web Query for IBM i development tools, you may have noticed the ability to create two types of virtual fields: defined fields and computed fields. Often, when building a report, you need to create a field that is not in the original database but is instead a calcu

(Samir Kapoor and Vincent Corvinelli) With multi-column statistics in IBM DB2 for Linux, UNIX, and Windows (DB2), the optimizer can determine a better query access plan and improve query performance when there is correlation between multiple predicates. In this article, learn how to use multi-column

(Craig Mullins) Answering a question I got via e-mail on indexing…

(Ronald C. Leung) This tutorial is a companion to the IBM Mashup Center Applications Use Cases Defects Tracking and Management Mashup article. Take this tutorial to learn step-by-step how to construct the defect management mashup application. (R)

(Ron Flannery) I’ve been on a mission for the last three years to show small, midsize, and large businesses how data warehousing and business intelligence (BI) can drive bottom-line profits and make them more competitive and that they can afford it.