
...BLU and talk about when BLU is beneficial and when it may be detrimental and why. BLU Workloads If you’re considering BLU consider first that it is not for all...

...jumping on the bandwagon? What is DB2 BLU BLU leverages the DB2 engine but is a significantly different animal in many ways from DB2 without BLU. BLU combines a number...
...announcements on Monday was about DashDB which is an offering on BlueMix and maybe Softlayer that delivers BLU as a service. It might be interesting to play with, and from...
Performance tuning of BLU databases is an evolving topic at this time. For BLU databases, sort memory cannot be tuned by STMM, and so must be manually tuned. BLU also...

Working with BLU has been a glorious learning experience for me. I say that both truly with excitement and with frustration. Whenever I have a DBA-character building experience, I’m bound...

Purpose These statements calculates the buffer pool hit ratio for both BLU and non-BLU activity. This post includes three SQLs – for calculating at the database, bufferpool, and tablespace level....

Purpose This statement calculates the compression ratio for BLU tables. The compression ration can be used to help identify tables where compression is not optimal and you may need to...
...got some interesting details about BLU and some interesting clues on what is coming down the road. My notes include: BLU is a DMS tablespace type Compression in 10.1 gains...

...entertain and walk us through BLU inserts, updates, and deletes in E16 – BLU Insert, Update, and Delete – An Insider’s Perspective. He manages to be both entertaining and incredibly...

...only work in DB2 10.5. BLU performs best when not all columns are referenced by queries. Source While I’ve modified this statement, it started with statements from these two sources,...
...on the coordinator node. I’ve recently migrated it to BLU – 10.5 on Linux. The users are just starting to make heavier use of the environment, though I largely built...

...– Going BLU: How to Convert Existing Databases & Tables to BLU Acceleration – Matthias Nicola and Naresh Chainani C02 – DB2 DPF: What a single partitioned DBA needs to...