MySQL is open-source RDBMS and is gaining popularity in the recent years.. I am starting a comparison series from this week.. This series will help MySQL DBAs to catchup Db2 quickly and vice versa.

(Chris Eaton) In my first part on Data Skipping I gave you the reasons for, and a short example on the benefits of data skipping. In this blog posting I will describe how the synopsis table works and how it is used by DB2.

(Yunming Wang) Informix 64-bit ODBC driver binaries have been available for many years, but the true 64-bit Informix ODBC driver was not introduced until Informix Client SDK v4.10 in early 2013. This article discusses the differences between the Informix 64-bit binaries of the Informix ODBC driver a

(Kim May) The IDAA class feedback was terrific as the attendees had the opportunity to expand their understanding of the potential use cases and opportunities to use the IDAA to: 1) speed analytic queries, 2) archive rarely used data, and retrieve it quickly, and 3) reconsolidate workloads on Syste

(Willie Favero) They would seem like a simple concept; a getpage and an I/O. However, it would surprise you how many times the two terms get confused and misused. Now I’m not saying that folk don’t know the difference. I think in most cases they do. They still on occasion manage to mess the terms up

(Sharad Chandra and Gaurav Rohila) Using simplified examples, this article shows how you can use IBM InfoSphere Optim to control data growth and, at the same time, maintain data privacy with IBM BPM.

(Chris Eaton) In my first posting on Data Skipping I set the stage on the reasons why you would want to use data skipping (especially in systems that have way more data than can cost effectively fit completely in memory). In my second posting I wrote about how it works in BLU Acceleration and how th

(Dave Beulke) The persistent struggle to improve application and database performance involves constantly analyzing different aspects of your environment, workload, and configuration.

(Marco Deluca, Esther Yu and Craig Malton) This tutorial describes how to install and configure IBM HTTP Server to work with the WebSphere Commerce development environment (Version 7.0.0.8 with Feature Pack 7 installed), which is helpful for search engine optimization schemes, web performance tuning

(Willie Favero) They would seem like a simple concept; a getpage and an I/O. However, it would surprise you how many times the two terms get confused and misused. Now I’m not saying that folk don’t know the difference. I think in most cases they do. They still on occasion manage to mess the terms up