Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Mark Gillis

Follow on Twitter LinkedIn

Principal Consultant

Favourite topics – Performance Tuning, BLU acceleration, Flying, Martial Arts & Cooking
Mark, our kilt-wearing, karate-kicking DB2 expert has been in IT for 30+years (started very young!) and using DB2 for 20+. He has worked on multi-terabyte international data warehouses and single-user application databases, and most enterprise solutions in between. During his career Mark has adopted roles outside of the conventional DBA spectrum; such as designing reporting suites for Public Sector users using ETL and BI tools to integrate DB2 and other RDMS data. He has worked extensively in the UK, but also in Europe and Australia, in diverse industry sectors such as Banking, Retail, Insurance, Petro-Chemicals, Public Sector and Airlines.

Mark's Articles

Time Travel Gotchas – Part 2

Published October 28th, 2013 - by

  See for Part 1 of this blog   Access paths   You will have noticed that my previous example also built the history table as a Multi-Dimensional Cluster (MDC). That doesn’t give any benefits in terms of space management but does address a problem with the access path. It’s not the only way; Continue Reading

Last Day At IDUG

Published October 18th, 2013 - by

Final day of IDUG EMEA 2013 and I was largely preoccupied with my own presentation. As it was my first time up at the front, rather than sitting and watching a presentation, I was concerned with not making a mess of it. I tried to keep it lively; it’s very hard to concentrate on a Continue Reading


Published October 17th, 2013 - by

Day 1 The conference opened with motivational speaker Pete Cohen challenging the delegates to adopt a different mind-set. This included a lively session where he invited the audience to voice their stereotypes of various different nationalities. As this is an International conference this got off to a nervous start, but soon warmed up, with ribald Continue Reading

Time Travel Gotchas Part 1

Published July 29th, 2013 - by

Time Travel query offers a quick and intuitive way of querying your data for historical scenarios, as well as the traditional current picture. There are a number of good articles out there showing how to enable the feature and some suggestions on how to use it. But like nearly every option, it’s got pitfalls and Continue Reading

RCAC: Usage Considerations Part 3

Published June 3rd, 2013 - by

In the previous two blogs (  and  ) we were discussing the Column Mask and Row Permissions as two separate entities, with potentially different impacts to your database. I’m now going to try and demonstrate some of the issues that can occur when you have the two features enabled on the same table. I’m Continue Reading

« Previous Page Next Page »

Tag Archives