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 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 (http://www.triton.co.uk/confessions-of-a-db2-geek/article/65/DB2-10.1-RCAC:-Hints-&-Tips-Part-1  and http://www.triton.co.uk/confessions-of-a-db2-geek/article/66/RCAC:-Usage-Considerations-Part-2  ) 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

RCAC: Usage Considerations Part 2

Published April 3rd, 2013 - by

In the previous blog (http://www.triton.co.uk/confessions-of-a-db2-geek/article/65/DB2-10.1-RCAC:-Hints-&-Tips-Part-1 ) we were discussing the Column Mask part of the RCAC feature. To recap, there are 2 parts to RCAC • Column masks : which over-write or obscure returned values with specified alternatives • Row permissions : which only return the rows of data that you are permitted to see Continue Reading

DB2 10.1 RCAC: Hints & Tips Part 1

Published February 28th, 2013 - by

  Row and Column Access Control (RCAC) in DB2 10.1 for LUW is a neat and simple means of shielding your data from users who don’t need to see it. It’s really two things melded together:   • Row permissions : which only return the rows of data that you are permitted to see • Continue Reading

Netezza: your plug-in Data Warehouse solution

Published July 19th, 2012 - by

Picture this situation: your business has spent a considerable amount of time and effort building a Data Warehouse, designing the ETL package and constructing a rich layer of Business Intelligence queries to access the data, but now the volume of data is growing enormously. To compound the performance problems this is causing, the user community Continue Reading

« Previous Page

Tag Archives