Favourite topics – Performance tuning, HADR, mountain climbing, skiing and pretty much anything with a high risk factor!
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 Damir has developed deep technical skills with database design and performance tuning.
As part of our DB2 Midrange team Damir works on both Consultancy projects and Remote DB2 support for a wide range of customers.
Published March 7th, 2017 - by Damir Wilder
In Part 1 I showed how to setup a simple TSA/HADR cluster, consisting of two servers, and what happens to an active client connection in case of a failover. You can read Part 1 here. In this part we will first reconfigure the TSA/HADR cluster to use ACR and then retry the failover and observe Continue Reading
Published February 17th, 2017 - by Damir Wilder
Introduction TSA/HADR is a combination of (IBM’s) technologies that facilitates high availability and disaster recovery in a world of DB2 (“High Availability and Disaster Recovery” – that is what HADR stands for). Tivoli System Automation (for Multiplatforms) is the long for TSA(MP). HADR on its own provides mainly Disaster Recovery, by maintaining more than one Continue Reading
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