Introduction This article is one in a series that focuses on improving performance in Db2 Warehouse. The first part provides some background information and lays out the first and most important aspect of query optimization, namely, cardinality estimation or estimating the number of rows that...
The IBM DB2 Analytics Accelerator (IDAA) has proven to be a big success in enabling analytics on DB2 z/OS data. Roberta Barnabè gave a well-received presentation at IDUG EMEA 2015 in Dublin on how her company implemented IDAA. This presentation is full of practical advice and can help any shop...
The Logical Data Warehouse and IBM Fluid Query Mike McCarthy, IBM There is much written about the concept of Data Lake these days, often comparing and contrasting it with the traditional concept of Data Warehouse. Viewing a data lake as a replacement for a data warehouse, or as an...
The video below is a presentation recorded at the IDUG DB2 North America Tech Conference in May 2015. Netezza is a Data Warehouse Appliance that can provide very high performance on large volumes of structured data. Abhik Roy presents the Netezza architecture from a DBA perspective by...
DB2 z/OS as a Modern Enterprise Data Warehouse The sturgeon may be a prehistoric animal, but there can be great caviar inside by Ludovic Janssens, Infocura Introduction: what makes an EDW future proof? The subtitle of this article refers to Alan Reddings blog [1] who calls the...
When the term high availability is brought up, most of the DBAs that I know reflexively think of technical solutions that we have implemented to help keep a system or database available for users – things like pureScale (“data sharing” for you mainframe DBAs), HADR and cluster managers like...