Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: Database Availability

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

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

We’re Risk Averse

Published March 3rd, 2017 - by

I’m in danger of sounding like an episode of Grumpy Old Men, but this is another of those expressions that grates a bit for a database support consultant. In my previous blog (If it ain’t broke, don’t fix it) I mentioned one expression that stores up problems in the long run. This often strikes me Continue Reading

Next Page »