Meet the Geek – Damir Wilder joins our busy RemoteDBA team
Published October 19th, 2016 - by Damir Wilder
We have recently had a new team member join our busy Midrange and RemoteDBA support department. Damir is a multi-talented DB2 expert and has worked with DB2 for LUW since V5.0. With significant experience as a Database Administrator and Application Developer he has developed deep technical skills with database design and performance tuning. As part of Continue Reading
Restore Transport option – mix and match your schemas (Part 2)
Published February 8th, 2016 - by Mark Gillis
So, the last blog (Restore Transport Part 1) got as far as restoring one Schema from our LOGBOOK source database (DB1) into our TARGET database (DB3). We’ve fudged our way around the fact that RESTORE TRANSPORT cannot cope with range partitioned tables and now, we need to merge in the objects from the CONTRACT database Continue Reading
Restore Transport option – mix and match your schemas (Part 1)
Published January 22nd, 2016 - by Mark Gillis
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 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