(George Baklarz) Trying to demonstrate what a database does is rather boring. It stores data. It retrieves data. Sometimes it does it in clever ways, but at the end of the day it’s just manipulating data. Which is where DB2Demo comes in.

(Michael Sansoterra) Time and time again, applications need to know something about the environment they’re running on. For example, if an application uses dynamic SQL and it needs to know what features are available, then knowing what version of IBM i it is using can help it decide how to build a q

IBM, Oracle, and SAP offer analytics software designed to process big data repositories, and they also integrate their software in these systems. To derive business value from their big data volumes, enterprises are looking to capitalize on the opportunities to gain insight from the available inform

(Whei-Jen Chen) The IBM Informix Warehouse Accelerator is a breakthrough technology that changes how businesses can view and deploy analytics. Informix Warehouse Accelerator both delivers high performance for business queries and eliminates the need for query tuning, data management, and cube-buildi

(Adam Storm) Life as we know it is generally quite ordered. It’s common for drivers to take the same route to work every day, place their keys in the same spot when they arrive home, and then go to bed at the same time every night. These routines soon become habits, which free the mind to focus on

(Chris Eaton) In the database world it is common knowledge that if you have more data than can fit into memory that you have to try to make sure that the most useful data stays in memory.

(Carlo Randone and Marco Antonioni) Leveraging the capabilities of the Advanced Integration Services (AIS) in IBM Business Process Manager V8.0.1 Advanced, this series describes the implementation of a distributed WS-AT scenario involving two databases (Microsoft SQL Server and IBM DB2) installed on

(Lockwood Lyon) Distributed applications are just that: distributed across one or more hardware platforms across the enterprise. These environments are usually separate from that of the database server.

(Troy Coleman) Due to the CPU costs involved, DBAs are typically very selective when it comes to collecting column-level statistics. In fact, most DBAs gather only standard or default statistics using the RUNSTATS, TABLE(ALL), INDEX(ALL), KEYCARD parameters. This is unfortunate, because when column-

(Chuck Ballard, Ute Baumbach, Holly Hayes, Marcia Miskimen, Lakshmi Palaniappan, Marichu Scanlon and Yong Hua Zeng) This IBM Redbooks publication describes the architecture and components of IBM InfoSphere Optim Performance Manager Extended Edition. Intended for DBAs and those involved in systems pe