(Kristi Ramey, Mike Biere, Peter Richardson, Shawn Sullivan and Jeremy Weatherall) There is enormous pressure today for businesses across all industries to cut costs, enhance business performance, and deliver greater value with fewer resources. To take business analytics to the next level and drive

(Serge Rielau) Yesterday one of my coworkers from India asked for my help in migrating the following SQL statement from Sybase to DB2.

This document is intended to provide a troubleshooting methodology based on a public tool to diagnose compliance of third party software with IBM Cognos BI.

(Philip) Back in the day DB2 9.5, IBM introduced data compression. This was the time I was first starting with DB2 having moved job and from SQL server 2000/2005, and nearly straight away I was put on a project to migrate the old DB2 V8.1 Linux machine to V9.5 Unix architecture.

(Heath Kath) Is your query tool up to date and function-rich? Are you able to build queries that end users, managers, and departments can use? Can it collect data from or send data to other systems or platforms? Does it provide run-time prompting? Does it handle data-mapping errors, especially aroun

(Teri Wen) Part 4 of this multi-part series helps you configure WebSphere DataPower Appliances and enable OAuth 2.0 support using the resource owner password credential grant type. It covers both authorization server and resource server setups.

(Lockwood Lyon) A hot spot is a physical place in the database where a lot of data access is happening. The worst situation is when a lot of inserts, updates, deletes, and selects are happening to a set of rows in one location. A flood of inserted rows requires DB2 to find space to store the data, e

(Paul Pendle) This quantum change is already here in the form of solid-state drives (SSDs). A 200 GB SSD can provide about 25 IOPS/GB—100 times the IOPS density of a 600 GB spinning drive.

(Amitkumar Bamane) Learn how to identify and categorize the most common corruption issues while using IBM DB2. In this article, learn corrective and preventive techniques you can implement to combat corruption issues.

(Willie Favero) Do you REORG large object (LOB) table spaces? If you do, you may find this, and I’ll label this an “anomaly”, interesting.