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 instance and databases before upgrading. Please refer to the DB2 Information Center for details on the steps to upgrade XML Extender including how to disable XML Extender in databases.
This is misleading at best, since chances are that the XML extender was installed with the default DB2 install and never used, which was the case for the first upgrade I had to do. You get this error message regardless of having any column, table, database, or instance using the XML Extender. However, to find out how to get rid of the XML Extender is quite a challenge.
Follow the instructions here until step 6: Upgrading a DB2 server with XML Extender to DB2 Version 9.7
Once you’re at step 6, here are the details, assuming you have installed DB 9.5 to the default path.
- First, check that XML Extender is installed:
db2ls -a -q -b /opt/ibm/db2/V9.5
- Then proceed to uninstall XML extender:
./db2_deinstall -F XML_EXTENDER -b /opt/ibm/db2/V9.5
This completes step 6 and you can proceed with the following step – step 7 – in the documentation. Make sure you use the correct
Even after fixing everything the upgrade tool complains about, you may still get odd error messages, that claim that you have not corrected the problems. That is some odd behavior of the error message reporting in DB2. For example, the front end was still complaining about VIEWs even though there weren’t any, and the back-end was still complaining about XML Extender even after it was uninstalled. Thus, if you are sure that all the issues are in fact fixed, you can go ahead and force the upgrade with the “-F” option.