Pivoting and Unpivoting data with pureXML part 2
Published December 4th, 2015 - by Mark Gillis
The previous blog (http://db2geek.triton.co.uk/pivoting-unpivoting-data-purexml ) was looking at how to ‘unpivot’ data: take a string of values stored in a single VARCHAR column and present them as a set of single values. This one is examining the flip-side of the problem: where data that is really a single entity spans a number of rows and needs Continue Reading
RUNSTATS versus Actuals
Published June 10th, 2015 - by Mark Gillis
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
Pivoting and Unpivoting data with pureXML
Published May 15th, 2015 - by Mark Gillis
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
HADR and Shadow tables – a good match, but with some considerations!
Published March 23rd, 2015 - by DB2 Geek
When DB2 BLU columnar architecture was introduced in DB2 10.5 GA, it was not possible to create a columnar table in a database which is the primary database in an actively connected HADR pair. This prevented a true DR solution. However, from Fixpack 4 HADR now supports columnar tables. A column-organized table created in an Continue Reading
Long awaited gems in db2look!
Published February 4th, 2015 - by Iqbal Goralwalla
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