Mark Gillis
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
Published July 29th, 2013 - by Mark Gillis
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
Published June 3rd, 2013 - by Mark Gillis
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
Published April 3rd, 2013 - by Mark Gillis
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
Published February 28th, 2013 - by Mark Gillis
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
Published July 19th, 2012 - by Mark Gillis
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