Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: DB2 LUW

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

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 on LUW – A Highly Available Database

Published January 20th, 2015 - by

How much does your business suffer if you cannot get to your data within a certain time? Loss of data access can significantly impact your business resulting in losses in revenue, customer confidence, market share, and more. Database High Availability is about making sure the database system remains operational during both during planned and unplanned outages, 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

« Previous Page Next Page »