Let me start by introducing myself. My name is Manas Dadarkar and I am the technical lead for Data Studio (the complimentary tooling for DB2 and IDS) and for High Performance Unload (HPU) for DB2 for Linux, UNIX, and Windows. I took on this role recently and am right in the middle of planning a lot of exciting things for Data Studio and HPU.
However, I will leave Data Studio for another day (blog posting), so today let’s talk about HPU, including the announcement today of the new release, 4.1.2, under the new name, Optim High Performance Unload for DB2 for Linux, UNIX and Windows.
For people not familiar with HPU, it's a product that offers high speed unload of DB2 data, thereby allowing DBAs to work with very large quantities of data easily and efficiently. In limited lab testing using a single large table, we have seen multiple magnitudes (6-10 times) performance improvement using HPU as compared to the DB2 EXPORT utility. The usual disclaimers apply: Your results will vary.
Since version 4.1, HPU has also supported automatic migrations. You can now migrate data directly from one database to another, including unloading, transferring, and loading of the data between the source database and target database without the need for intermediate storage. You can get more information about HPU here. It's also featured in our Day in the Life of a DBA video demo.
With Version 4.1.2, what's new is being able to unload or restore using incremental backup images. If you use incremental backups, it’s likely that those backups will provide you with a more current version of a dropped table. Check out the full announcement here.
For those of you who have moved to DB2 LUW 9.7 (or will be soon), you don’t need to wait for the 4.1.2 release, which is planned to be electronically available on November 20. We’ll shortly be releasing the support for 9.7, including the ability to work with DB2’s industry leading XML data support. I’ll post a short blog with the link once that is available and we’ll also put the word out on Twitter.
Also, if you are going to IOD2009, you can hear directly from a customer about HPU by attending session 1499 A day in the life of a DBA: How to keep your sanity.Manas Dadarkar