Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: DB2 LUW

Nanu, Nanu, DB2 calling you!

Published January 30th, 2014 - by

By Klaas Brant Do you remember the Mork and Mindy show? Mork made a connection with Orson using his famous sentence “Nanu, Nanu, come in Orson” in order to report what was going on. If this does not sound familiar it simply means you are not as old as I am! The reason I bring it up Continue Reading

Time Travel Gotchas – Part 3

Published December 10th, 2013 - by

Views One of the features that I really like about Time Travel Query is an issue that’s related to the access path discussion from Time Travel Gotchas – Part 2 (see http://db2geek.triton.co.uk/time-travel-gotchas-part-2/). The optimizer, being the canny chunk of software that it is, will take your simple SYSTEM_TIME query and convert it into the necessary Continue Reading

Guest Blog – IDUG Barcelona 2013 Experience

Published December 9th, 2013 - by

Guest Geek Blogger – Arvind Clement, DB2 DBA, Tyche Consulting Ltd   Initially I was a bit sceptical about going away for a week to attend IDUG EMEA.  As usual I was feeling protective about my database servers and how they would manage without me but somehow everything fell into place.  The mentor program added a Continue Reading

Time Travel Gotchas – Part 2

Published October 28th, 2013 - by

  See http://db2geek.triton.co.uk/time-travel-gotchas-part-1/ for Part 1 of this blog   Access paths   You will have noticed that my previous example also built the history table as a Multi-Dimensional Cluster (MDC). That doesn’t give any benefits in terms of space management but does address a problem with the access path. It’s not the only way; Continue Reading

When worlds collide – Running DB2 workloads in a Linux for System z Environment

Published September 23rd, 2013 - by

Many large system z environments have begun to look at the possibilities of running non-z/OS workloads on their System z environments in recent years. Smaller organisations  may not already posses a System z server, but are starting to consider IBM’s Enterprise Linux Server, a dedicated Linux server based on System z technology. I’ve just posted Continue Reading

« Previous Page Next Page »