(Corinne Baragoin, Alain Fournil, Andrea Hirata Miqui, George Latimer, Susan Schuster and Calisto Zuzarte) Data warehouses in the 1990s were for the privileged few business analysts. Business Intelligence is now being democratized by being shared with the rank and file employee demanding higher leve

(Susan L. Cline and Rajesh Kartha) The IBM Integration plug-in for Derby provides a seamless integration between Eclipse and Apache Derby. It enables the use of the Derby database JAR files as an installable component to Eclipse. Additionally the ij SQL scripting tool and the Apache Derby Network Se

(Noel Davis) Welcome to Security Alerts, an overview of recent Unix and open source security advisories. In this column, we look at problems in DB2, SHOUTcast, nasm, Vilistextum, libtiff, wxGTK2, phpGroupWare, Vim, namazu2, and htmlheadline.

(Roman B. Melnyk) The DB2 Universal Database data movement utilities — export, import, and load — support various levels of concurrency, which is primarily enforced through the placement of different types of locks on resources such as database tables or rows. This article describes the locking be

When using DB2 UDB with the Data Partitioning Feature on AIX, you need to create resource sets for the data partitions. This Technote provides the steps to configure AIX resource sets to enable processor affinity for DB2 partitions.

This is the second tutorial in a series of three covering the development of a mobile service technician sample application for DB2 Everyplace using Visual Studio .NET 2003 and the .NET framework. It introduces developers to the DB2 Everyplace mobile database API for .NET for implementing required d

(Ann Bednarz) Conventional wisdom dictates it’s not what you know, but who you know that matters. In the world of identity resolution software, that adage is particularly relevant.

Here are some tips for getting the maximum benefit out of MultiDimensional Clustering (MDC) tables. They can help provide improved performance and help maximize space utilization.

In BI or OLAP queries, you need to interactively explore the vast amounts of data in the modern data warehouse. To speed up the calculation, you can use statistical sampling to give results that are sufficiently accurate in a reasonable amount of time.

Locking isolation levels affect the behavior of SQL statements. This Technote discusses locking isolation levels in DB2 and XPS.