Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: Uncategorized

Finding the access path for Columnar queries

Published October 18th, 2017 - by

Columnar Data : how it works We’re probably all fairly familiar now with BLU acceleration and the advantages of storing analytical data in a columnar format. If not, and by way of a recap; what we can now do is return much smaller results sets to our analytical queries, in a highly-compressed format, thereby reducing 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

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

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

Next Page »