Published November 16th, 2016 - by Damir Wilder
In this exercise we shall look at several different methods of tuning a poorly performing SQL query. The Problem The Original SQL Query The Original Access Path So, where is the problem? Looking at the Access Path chosen by the DB2 Optimizer, all looks well – all tables are either accessed via indexes, or not Continue Reading
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
Published March 2nd, 2016 - by Julian Stuhler
It’s easy to think of DB2 11 for z/OS as still being the new kid on the block, but it actually became Generally Available back in October 2013 – Miley Cyrus was getting plenty of airtime with Wrecking Ball and the movie Gravity was expertly inducing vertigo in audiences all around the world. New releases Continue Reading
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
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