Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Best Practice

Published May 12th, 2017 - by

OK, I bent the truth slightly. Lied, if you like. Mis-spoke if you’re a politician. I was going to go for a positive spin this time, but I’ve got one more grumpy negative subject to get off my chest first. And this one is going to be harder to justify. If it ain’t broke, don’t Continue Reading

DB2 Native REST API – Security

Published May 2nd, 2017 - by

Introduction In the previous blogs on the DB2 Native REST API, we’ve talked about installation of the feature, how to create and drop services, and how to drive them. In this one, we’re going to have a look at how security works with REST – both in general HTTP/HTTPS terms, and from the point of Continue Reading

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

Next Page »

Tag Archives