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

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

Time Travel Gotchas – Part 3

Published December 10th, 2013 - by

Views One of the features that I really like about Time Travel Query is an issue that’s related to the access path discussion from Time Travel Gotchas – Part 2 (see http://db2geek.triton.co.uk/time-travel-gotchas-part-2/). The optimizer, being the canny chunk of software that it is, will take your simple SYSTEM_TIME query and convert it into the necessary Continue Reading

Time Travel Gotchas – Part 2

Published October 28th, 2013 - by

  See http://db2geek.triton.co.uk/time-travel-gotchas-part-1/ 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

IDUG EMEA So Far…

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

« Previous Page Next Page »

Tag Archives