Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: DB2 LUW

pureScale ‘lite’ – just ‘rite’ for many customers!

Published September 11th, 2014 - by

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

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

Considerations to use DB2 HADR with TSM

Published May 19th, 2014 - by

  Starting with version 6.1 TSM now uses DB2 as its backend database engine. It is a normal DB2 instance, but very tightly controlled by IBM support. After installation one cannot change any parameter in the TSM DB2 instance without permission from IBM support.   As part of normal DB2 engine TSM can use the Continue Reading

INGEST Part 1 – Proof of Concept

Published March 18th, 2014 - by

Why Ingest? INGEST is a utility introduced in DB2 V10.1 to put data, sourced via a Pipe or Flat file, into a target table or set of tables. It’s sometimes referred to as “Continuous Data Ingest (CDI)” as one of its main advertised benefits is to be able to continuously pump data in DB2 tables. Continue Reading

« Previous Page Next Page »