OLTP and BI mixed workloads – a merry coexistence in DB2 10.5 “Cancun Release”
Published September 22nd, 2014 - by DB2 Geek
If you have been using DB2 10.5 with a mix of row and column based tables in the same database you may have experienced slowdown in some of your OLTP queries accessing your row based tables after implementing column based tables. We had this issue with one of our customers after implementing columnar tables. In Continue Reading
pureScale ‘lite’ – just ‘rite’ for many customers!
Published September 11th, 2014 - by Iqbal Goralwalla
I recently wrote about the new Shadow tables feature in the DB2 10.5 “Cancun Release” and how it is so relevant to customers I have been working with who need to report directly on their transactional DB2 systems (http://bit.ly/shadow_tables). Another feature in the DB2 10.5 “Cancun Release” that I am equally excited about is to Continue Reading
Shadow tables: A Cure for Reporting Headaches on Transaction Systems!
Published September 4th, 2014 - by Iqbal Goralwalla
I’m really excited about the DB2 10.5 “Cancun Release”, in particular with the Shadow tables feature. Based on my experiences with customers who have mixed workloads (transaction and analytic) on a transactional system, one of the big performance pain points is when the transaction tables are also used for business intelligence analytics. Reports run on Continue Reading
Less Caffeine, More Compression
Published August 6th, 2013 - by Iqbal Goralwalla
DB2 10.5 for Linux, Unix and Windows features exciting and ground breaking data management innovation for analytic processing. The addition of IBM’s BLU Acceleration technology makes it easier, cheaper and faster to analyse massive amounts of data. The seven big ideas of DB2 with BLU Acceleration aim to provide extreme performance, lower operating costs Continue Reading
DB2 10.5 addresses Big Data challenges with BLU Acceleration
Published April 22nd, 2013 - by Iqbal Goralwalla
The IBM BLU Acceleration technology, announced on April 3, 2013, features new innovations from the IBM Research and Development Labs that address the common Big Data issues of size, development time, and response times. This exciting, ground breaking data management innovation for analytic processing is due to be first available in the new DB2 10.5 Continue Reading