Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

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

DB2 Geek’s Geocaching Clues

Published October 2nd, 2017 - by

Here are the DB2 Geek Geocaching competition clues! Good luck and see you all soon.  Clue #1: Count the number of flagpoles outside the Epic Sana hotel and multiply this by the maximum number of bytes in a DB2 schema Use the 4-digit number in the following map reference and go to this location: 38.723472,-9.nnnn Continue Reading

Do the Needful

Published July 19th, 2017 - by

So the last few blogs have been a bit negative and have been built around common expressions and assumptions that make my hackles rise (If it ain’t broke, don’t fix it, We’re Risk Averse and Best Practice). Now this is the blog with the positive spin, so it might seem strange that I’m hanging it 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

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

Next Page »

Tag Archives