Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Monthly archives for April, 2017

MVM Eases DB2 for z/OS Upgrade Anxiety

Published April 19th, 2017 - by

On 14th February 2017, IBM quietly announced a new software charging mechanism that could have some very positive implications for most System z sites – including DB2 for z/OS customers. MVM (Multi-Version Measurement) replaces the old Single Version Charging (SVC) arrangement, and promises to do away with many of the restrictions that IBM previously imposed 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

In-Line Optimization with V11.1

Published April 7th, 2017 - by

Sometimes you might find that the Optimizer has chosen an access path with which you don’t concur. It’s not that likely, as the DB2 Optimizer is one of the most sophisticated of its ilk, but it’s possible that you may know something that the optimizer doesn’t: if, for instance, a table has just had some Continue Reading