Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: DB2 LUW

If it ain’t broke, don’t fix it

Published January 31st, 2017 - by

Ever heard this expression? One of my least favourites. Flip it over and express it the other way around: Wait until it breaks and then try and fix it I don’t think that is something you seriously want to consider in a Production environment and yet it is something we come across as database support Continue Reading

SQL Query Tuning Exercise

Published November 16th, 2016 - by

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

Meet the Geek – Damir Wilder joins our busy RemoteDBA team

Published October 19th, 2016 - by

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 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

« Previous Page Next Page »