Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: DB2 LUW

Considerations to use DB2 HADR with TSM

Published May 19th, 2014 - by

  Starting with version 6.1 TSM now uses DB2 as its backend database engine. It is a normal DB2 instance, but very tightly controlled by IBM support. After installation one cannot change any parameter in the TSM DB2 instance without permission from IBM support.   As part of normal DB2 engine TSM can use the Continue Reading

INGEST Part 1 – Proof of Concept

Published March 18th, 2014 - by

Why Ingest? INGEST is a utility introduced in DB2 V10.1 to put data, sourced via a Pipe or Flat file, into a target table or set of tables. It’s sometimes referred to as “Continuous Data Ingest (CDI)” as one of its main advertised benefits is to be able to continuously pump data in DB2 tables. Continue Reading

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

« Previous Page Next Page »