Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: Mark Gillis

Table Partitioning: The Good, the Bad and the Ugly

Published April 10th, 2019 - by

Table (or Range) Partitioning has been around since V9.7. It’s a canny option and a useful tool from both a performance and a data archiving point of view, but we do occasionally see it mis-managed and then it can be more of a nuisance than a benefit. Overview Partitioned tables are organized into multiple storage Continue Reading

Top 5 DB2 Support Nightmares 2018 No. 3

Published October 30th, 2018 - by

In part 3 of our new series of DB2 Support Nightmares we look at the risks of staying on out of support databases. Sign-up to receive DB2 Support Nightmare updates or download our previous series ‘Top 10 DB2 Support Nightmares and How to Avoid Them‘ here.

Top 5 DB2 Support Nightmares 2018 No. 2

Published September 12th, 2018 - by

In part 2 of our new series of DB2 Support Nightmares we look at the implications of a “Suck it and See” development approach. This could be strongly related to the Support Nightmare #1, but not necessarily always. Sign-up to receive DB2 Support Nightmare updates or download our previous series ‘Top 10 DB2 Support Nightmares and How Continue Reading

Finding the access path for Columnar queries #3

Published March 13th, 2018 - by

In the first blog in this series ( Finding the access path for Columnar queries ) I was griping about not being able to see any detail in the explain plans for what DB2 is doing when you see a table scan (TBSCAN) of a column-organized table. I mention that each columnar table will have Continue Reading