Loading Data into DB2 BLU Tables

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 to share it with my readers.

The Scenario

A client has a small (1.7 TB) DPF data warehouse/ODS than I’m helping them move from 9.5 to 10.5 using BLU.… Read the rest

Continue reading »

The IBM Data Movement Tool

We DBAs are lazy in some ways. Our favorite way of moving large amounts of data is the backup utility. It’s so easy to move data, structure, objects, permissions, etc. But as quick, easy, and efficient as it is, it cannot handle some situations – like skip-level upgrades, data movement between different operating systems, and of course between different RDBMSes.… Read the rest

Continue reading »

DB2 Basics: What is BLU?

BLU has been all the hype for DB2 for the past year or more. What exactly is DB2 BLU? How does it work? What do you need to consider before 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.… Read the rest

Continue reading »