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 »