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

Dependent Tables in DB2

Published March 26th, 2019 - by

Have you ever had a need to quickly find out if a DB2 table has any dependencies, i.e. foreign key relationships to it and from it? The following SQL query will show all parent tables (tables that the table references with its foreign keys) as well as all child tables (tables that reference the table Continue Reading

Client Experiences: How DB2 Migration Affects Decimal Type Conversion

Published February 12th, 2019 - by

Recently, I assisted a client migrating their DB2 databases from v9.7 to v11.1. I intentionally say “migrating” and not “upgrading”, even though three major releases were jumped, because the existing databases were located on Z-Linux servers (big endian) and the target databases were to be placed on POWER Linux servers (little endian), so it was Continue Reading

Recovering from corrupt DB2 Storage Group Control Files

Published August 17th, 2018 - by

Recently, we received a distress call from a client who was unable to access their production database and the data within. Client’s main aim was to recover the data from the database by any possible means. The (short) description of the situation was: -there are two DB2 instances on the server, one TEST and one Continue Reading

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

Next Page »

Tag Archives