Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Monthly archives for October, 2017

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