Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Damir Wilder

Senior Consultant

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.

Damir's Articles

Client Connections in a TSA/HADR cluster- Part 4

Published June 6th, 2017 - by

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. In Part 2 and Part 3 we saw how ACR and VIP independently affect a client’s connection in case of a failover in the cluster. In Continue Reading

Client Connections in a TSA/HADR cluster – Part 3

Published April 18th, 2017 - by

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. In Part 2 we saw how a client with configured ACR automatically recovers its connection to the database in case of a failover in the cluster. Continue Reading

Client Connections in a TSA/HADR cluster – Part 2

Published March 7th, 2017 - by

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

Client Connections in a TSA/HADR cluster – Part 1

Published February 17th, 2017 - by

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

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

Next Page »

Tag Archives