(Frank Fillmore) I’ve been seeing a lot of an old friend lately: DB2 Connect. This is the software which enables Distributed Relational Database Architecture (DRDA) Application Requestor (AR) or “client” applications running on Linux, Unix, and Windows platforms to access DB2 ”host” databases on Sy

(Cynthia M. Saracco) The IBM DB2 9 release features significant new support for storing, managing, and querying XML data, which is called pureXML. In this article, learn how to query data stored in XML columns using SQL and SQL/XML. The next article in the series will illustrate how to query XML dat

(Keith McDonald) In the first post in this series, we saw gauges and aggregates of table space information across all the table spaces in your database. In today’s post, you will see how db2top presents individual table spaces and their attributes. You will see ways to gauge the efficiency of your c

(Craig S. Mullins) Among the many new enhancements that have found their way into DB2 9 for z/OS is the ability to gather histogram statistics with the IBM RUNSTATS utility.

(Latha Sivakumar) Part 1 of this series introduced you to the trade system scenario that is used throughout this series. In Part 2, you built and tested the trade system application. This article uses the project for the trade system scenario introduced in Part 2, which guides you through the proces

(Henrik Loeser) Yesterday, I wrote about how and why embedded textual XML documents can create trouble. Today, I will look at different ways I found (so far) on how to deal with those documents in DB2 pureXML.

In this 3-part videos, Jeff Sullivan gives an overview of what can cause performance issues in DB2 for LUW, how to find them, and why performance tuning is necessary.

(Keith McDonald) Databases are generally concerned with storing data on disk and retrieving it quickly, which makes monitoring the speed of your reads and writes essential. It is also important to know how fast your storage needs are growing, the makeup of your workload (writes versus reads), and wh

(Robert Catterall) In May of last year I posted a blog entry that included some information about the index compression capability introduced with DB2 9 for z/OS. It’s a good time, I think, to add to that information, and I’ll do that by way of this post.

(Brian Byrne and Jennifer Ramirez) In a large organization with complex analysis, modeling, and development initiatives spread across multiple projects, standardizing business semantics is key. Without a way to standardize the meanings and definitions of business concepts, each analysis, modeling, o