Triton Db2 Geek

Confessions of a DB2 geek

IBM Gold Consultant Program and IBM Premier business Partner

Category Archives: DB2 LUW

Time Travel Gotchas – Part 2

Published October 28th, 2013 - by

  See http://db2geek.triton.co.uk/time-travel-gotchas-part-1/ for Part 1 of this blog   Access paths   You will have noticed that my previous example also built the history table as a Multi-Dimensional Cluster (MDC). That doesn’t give any benefits in terms of space management but does address a problem with the access path. It’s not the only way; Continue Reading

When worlds collide – Running DB2 workloads in a Linux for System z Environment

Published September 23rd, 2013 - by

Many large system z environments have begun to look at the possibilities of running non-z/OS workloads on their System z environments in recent years. Smaller organisations  may not already posses a System z server, but are starting to consider IBM’s Enterprise Linux Server, a dedicated Linux server based on System z technology. I’ve just posted Continue Reading

Less Caffeine, More Compression

Published August 6th, 2013 - by

DB2 10.5 for Linux, Unix and Windows features exciting and ground breaking data management innovation for analytic processing. The addition of IBM’s BLU Acceleration technology makes it easier, cheaper and faster to analyse massive amounts of data.   The seven big ideas of DB2 with BLU Acceleration aim to provide extreme performance, lower operating costs Continue Reading

Time Travel Gotchas Part 1

Published July 29th, 2013 - by

Time Travel query offers a quick and intuitive way of querying your data for historical scenarios, as well as the traditional current picture. There are a number of good articles out there showing how to enable the feature and some suggestions on how to use it. But like nearly every option, it’s got pitfalls and Continue Reading

RCAC: Usage Considerations Part 3

Published June 3rd, 2013 - by

In the previous two blogs (http://www.triton.co.uk/confessions-of-a-db2-geek/article/65/DB2-10.1-RCAC:-Hints-&-Tips-Part-1  and http://www.triton.co.uk/confessions-of-a-db2-geek/article/66/RCAC:-Usage-Considerations-Part-2  ) we were discussing the Column Mask and Row Permissions as two separate entities, with potentially different impacts to your database. I’m now going to try and demonstrate some of the issues that can occur when you have the two features enabled on the same table. I’m Continue Reading

« Previous Page Next Page »