Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: DB2

Pivoting and Unpivoting data with pureXML

Published May 15th, 2015 - by

I am sometimes presented with data that, although stored in the relational database, still needs some ‘massaging’ to be meaningful. An issue that would fall into that category would be where a set of values has been stored in a string; in order for this to be usable I really need to “unpivot” it so Continue Reading

Enumerating DB2 Subsystems

Published November 27th, 2014 - by

Introduction Every site has this challenge and we all find different ways around the problem: How can I generate a list of DB2 subsystems defined to my current LPAR and whether they are active or not? It may be that you want to know exactly that but more commonly this is the sort of thing that Continue Reading

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

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

New Podcast! IBM DB2 Analytics Accelerator for z/OS

Published November 25th, 2013 - by

Join Julian Stuhler and Cristian Molaro in our latest DB2 Geek podcast where we take a look at the IBM DB2 Analytics Accelerator for z/OS.   “The IBM DB2 Analytics Accelerator for z/OS has the potential to be a revolution in terms of performance and cost savings” Cristian Molaro, Independent DB2 Consultant.     For Continue Reading

« Previous Page Next Page »