OS X developers do not need to use a virtual machine any longer to be able to run DB2 in their favorite development environment. The latest version of DB2 9.5 available for download works on Snow Leopard (OS X 10.6).
Summary
The IBM documentation has good information on how to do the upgrade in general, and how to go through the preparation steps. Unfortunately the information about XML Extender is sparse, and all you get is
ADM4104E One or more databases are enabled for XML Extender. You must remove the XML Extender functionality from the [...]
IBM Systems Director is a very powerful management tool that comes free with PowerVM (that is: free to anyone that purchases a Power System). I have gathered here the different steps. Most of the information comes from the official documentation: Installing IBM Systems Director on the management server. In this guide I [...]
In case an application such as the IBM Systems Director needs the DB2 client to be installed, the process has a couple of pitfalls. Here are steps that make the installation very simple.
Download the DB2 client from IBM: http://www.ibm.com/software/data/db2/9/download.html
Create a directory and unpack the tarball in that directory, and install the client:
wget ‘https://www6.software.ibm.com/sdfdl/v2/regs2/smkane/dsclients/IBM_DATA_SERVER_CLIENT/Xa.2/Xb.YZomhqTjd0WgkJqNENbocjIpCoqHi4eEhNMEPXE/Xc.v9.5_aix64_client.tar.gz/Xd./Xf.LPr.D1vk/Xg.4962564/Xi.swg-idsc11/XY.regsrvs/XZ.JOzao7W3aaunX0L_IE0SvHPww1I/v9.5_aix64_client.tar.gz’
mkdir db2
cd [...]
I just came across the following two articles that have some good pointers for using the native XML capabilities of DB2:
Using DB2 XQuery to extract data mining results stored as PMML: this article is a great introduction to XQuery and Predictive Model Markup Language (PMML), a language to describe data mining models and to enable [...]