Thoughts and opinions from DB2 and technology blogs around the world featured by
    IDUG for our members.

    Chris Eaton - An Expert's Guide to DB2 Technology

    Chris is a DB2 for Linux, UNIX and Windows lifer having worked at IBM on DB2 since its inception. Follow along as Chris shares his experiences and provides tips and techniques for getting the most out of DB2 including how to exploit new features and releases as they come on-line.

    Note: The content of this blog is the opinion and thoughts of the blogger and does not necessarily represent the opinions of IDUG.


    How Data Skipping works in BLU Acceleration - Part 2In my first part on Data Skipping I gave you the reasons for, and a short example on the benefits of data skipping. In this blog posting I will describe how the synopsis table works and how it is used by DB2. Data skipping in BLU is made possible by storing "metadata" about the various values in a given columns so that at runtime we can skip over portions of the
    How Data Skipping works in BLU Acceleration - Part 1The good news is that you don't need to all happens automatically. So why bother writing about it? Well I know a lot of you out there (just like me) are curious and want to really understand how things work. And of course it's possible that things don't work the way you thought they would so you want to understand the underlying technology so that you can come to expect certain behaviours and understand why they are the way they are. I t
    Automatic Workload Management with BLU AccelerationThere are often competing goals in any system today. One such example is the desire to leverage resources available on a machine in order to complete a given complex query as fast as possible, alongside the desire to provide predictable response time by ensuring a given set of resources is not overwhelmed. Although modern operating systems are very good at doing many things simultaneously and at scheduling work in an efficient manner, it is possible with hundreds or tho
    BLU Customer ExperiencesI have written quite a few blog posts on capabilities in DB2 10.5 with BLU Acceleration and I will be writing more in the future to give you some details. In this post I'd like to share with you just a small sample of some of the comments from a few BLU customers and in future posts I will be sharing with you some deeper details on many of these comments. This will be leading up to a presentation I will be giving at the IDUG DB2 Technical Conference in North America in May 2
    SAP Supports BLU Acceleration for In-Memory Columnar Analytics on SAP BWAs of December 3, 2013 SAP supports DB2 BLU Acceleration for use with SAP BW and Near Line Storage! SAP has released a note (SAP Note 1825340 - DB6: Use of BLU Acceleration with BW) officially announcing support for use of DB2 BLU Acceleration with SAP BW. This is another great example of the excellent technology relationship that exists between SAP engineers and IBM engineering team to work together to bring value to our mutual client
    Vector Processing (SIMD) in DB2 10.5 with BLU AccelerationIn a previous blog posting I wrote about how we do compression and encoding in DB2 BLU Acceleration and in that video we spoke about how DB2 pre packs encoded data into register length "chunks" on the database pages. Why do this? The reason is that at runtime, when we want to run SIMD instructions on many pieces of data at the same time, it's more efficient
    DB2 10.5 with BLU Acceleration Optimized for Power SystemsI was asked the other day by a client if DB2 10.5 with BLU Acceleration was optimized for AIX or for Linux. My answer was YES! :-) Of course the code has optimizations built in for both Power/AIX and Intel/Linux platforms and the code knows which platform it is running on and how to exploit what that server has available to it. Having said that, I want to focus this blog posting on what is inside of DB2 1
    Extreme Performance with DB2 10.5 and BLU AccelerationIn my previous blogs on BLU Acceleration I've written a lot about the capabilities in 10.5 for extreme performance. In this blog I will talk specifically about the performance benefits customers are experiencing with BLU. First let me say that I have seen some comments from others saying that you need to buy new hardware to get better performance for in-memory analytic systems, but this is completely untrue. Some competitors are saying that it's not possible
    IBM DB2 10.5 with BLU Acceleration vs. Oracle 12c In-Memory OptionIn a previous blog we discussed the advantages of BLU Acceleration over Exadata. In this blog I'll compare and contrast BLU Acceleration with the information currently available on Oracle's announcement of their future 12c In-Memory Option. In September Oracle announced an "In-Memory Option" for the Oracle 12c database to be delivered some time in calendar year 2
    Scan-Friendly Caching in DB2 10.5 with BLU AccelerationIn the database world it is common knowledge that if you have more data than can fit into memory that you have to try to make sure that the most useful data stays in memory. Known as buffer pool hit ratios (i.e. the number of times that the data or index page you want is in memory divided by the number of times you request any page), it's one of the metrics most DBAs know about and for OLTP systems they try to keep them in the high 9

    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact