Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: Uncategorized

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

RUNSTATS versus Actuals

Published June 10th, 2015 - by

Now and again we get a slightly panicky call from one of our clients as they attempt to execute some part of their application and it takes far longer to run than it should, or than it did the last time it was executed. Our first question is usually “have you run REORGs and RUNSTATS Continue Reading

Long awaited gems in db2look!

Published February 4th, 2015 - by

db2look is a great utility which is commonly used by DB2 DBAs to extracts the DDL statements from a source database that can then be used recreate the database objects in a target database. Now, I have always wished for two features in db2look that would make it a “complete” utility. The ability to generate: Continue Reading

DB2 Geek Highlights of 2014

Published December 24th, 2014 - by

Well, it’s been another busy year for the DB2 Geeks. We take a look at some of our favourite DB2 experiences and blogs over the past 12 months. Merry Christmas and a Happy New Year from us all!   January – March A Sysprog’s Perspective – DB2 11 – In this podcast series we looked Continue Reading

INGEST Part 2 – Marriage with Temporal Data

Published May 28th, 2014 - by

Part 1 was a basic illustration of how INGEST can be used to provide a high-availability data replication mechanism without employing expensive and complicated ETL. In Part 2, I’m going to try and explore a few more complicated options: enriching or extending the data as it is ingested.   One ‘nice-to-have’ that INGEST can deliver Continue Reading

« Previous Page Next Page »