Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Mark Gillis

Follow on Twitter LinkedIn

Senior Consultant

Favourite topics – Performance Tuning, RCAC, 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

We’re Risk Averse

Published March 3rd, 2017 - by

I’m in danger of sounding like an episode of Grumpy Old Men, but this is another of those expressions that grates a bit for a database support consultant. In my previous blog (If it ain’t broke, don’t fix it) I mentioned one expression that stores up problems in the long run. This often strikes me Continue Reading

If it ain’t broke, don’t fix it

Published January 31st, 2017 - by

Ever heard this expression? One of my least favourites. Flip it over and express it the other way around: Wait until it breaks and then try and fix it I don’t think that is something you seriously want to consider in a Production environment and yet it is something we come across as database support Continue Reading

Restore Transport option – mix and match your schemas (Part 1)

Published January 22nd, 2016 - by

I recently had a request from a client to help them build a database with a set of objects from two physical databases and provide a third ‘merged’ database. They’d already established that using 2 successive RESTORE commands with the TABLESPACE option was going to fail (SQL2560N : The target database is not identical to the Continue Reading

Pivoting and Unpivoting data with pureXML part 2

Published December 4th, 2015 - by

The previous blog (http://db2geek.triton.co.uk/pivoting-unpivoting-data-purexml ) was looking at how to ‘unpivot’ data: take a string of values stored in a single VARCHAR column and present them as a set of single values. This one is examining the flip-side of the problem: where data that is really a single entity spans a number of rows and needs Continue Reading

Next Page »

Tag Archives