Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Tag Archives: DB2 LUW

Restore Transport option – mix and match your schemas (Part 1)

Published January 22nd, 2016 - by

I recently had a request from a client to help them build a database with a set of objects from two physical databases and provide a third ‘merged’ database. They’d already established that using 2 successive RESTORE commands with the TABLESPACE option was going to fail (SQL2560N : The target database is not identical to the Continue Reading

Pivoting and Unpivoting data with pureXML part 2

Published December 4th, 2015 - by

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

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

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

Next Page »