Data Conversion

Ever wanted to participate in an open source project but didn’t really know of one that was relevant to your area of expertise? Want to be a part of building a community based monitoring console for DB2? Now is your chance! Here is a portion of news item that is posted on the IDUG website The DB2 Monitoring Console - Open Source Project

In previous postings I mentioned that there were simplifications to the restore and rollforward commands (including the RECOVER command) that helped to make recovery simpler in DPF. Now in DB2 9.5, IBM has added simplification to the BACKUP process for DPF customers. Prior to DB2 9.5 there were three issues with DPF backups. The first is that you had to be on each database partition to do the

One of the biggest new features in DB2 9.5 (and one of my personal favorites) is the new threaded engine. In DB2 9.1 and all prior releases on AIX, HP-UX, Solaris and Linux, the DB2 engine was process based. That means that all functions run in operating system processes. For example each db2agent is an individual process; all page cleaners and prefetchers were operating system processes; the log writers,

I'm just back from IDUG in Athens where I attended many great sessions and found lots of new material for my blog. I have already written many blog postings on the new administrative views in DB2 9 (search my blog for SYSIBMADM). So let's start off with some new administrative views that I learned about from Jessica

In my last entry I posted about the new Automatic Compression capability in DB2 9.5. In this posting I wanted to talk about inline XML as well as compression for XML. In DB2 9.1 IBM delivered a revolutionary enhancement in relational database technology called pureXML. What is revolutionary

I have written a number of blog postings on Compression in DB2 9.1 (just search my blog by putting the word Compression in the search box on the top right corner of this page to find them). Now there are some nice new enhancements to compression in DB2 9.5. In DB2 9.1, in order to build a compression dictionary for a table (or a partition of a table) you had to either perform an offline reorg of

Time is running out for you to enter the DB2 9 Deep Compression Challenge for your chance to win a free registration to one of 2008 IDUG conferences. I have written a number of blog postings on the new compression capabilities in DB2 9 and now IDUG is having a bit of fun by posting the Deep Compression Challenge Sweepstakes. Anyone

Some of the new features in DB2 Viper 2 will probably never get much press attention or even be in a presentation at a conference because they are pretty small. But they can sure help make your life easier. This is one example of such a feature. DB2 has supported online backups for many years. To restore

I came across a great article on the web on Viper 2 features by Serge Rielau. I've mentioned Serge a few times on my blog and I'll reiterate that if you ever get a chance to see Serge present at IDUG, IOD or any other database conference I strongly urge you to attend his session. I always learn something new from Serge and his material has been the source for many of my blog postings specifically those

IBM's new POWER6 based servers have a new and unique hardware capability. They have added a Decimal Floating-Point Unit (DFU) which can perform numeric manipulation in hardware for decimal data. To exploit this new hardware advance DB2 Viper 2 has added a new data type that can take advantage of the hardware acceleration for decimal