How to switch DB2 compatibility from v9 to v10 in XDB?

Problem:

As well as recompiling the source code, is anything else needed for the original v9 location?

Will this be converted automatically to v10 or should a new location be created before migrating the data from the v9 location?

Solution:

Follow the steps below to convert your XDB location from DB2 v9 to DB2 v10:

1. Change XDB Server configuration to v10 and restart XDB service for changes to take effect

2. Open SQL Wizard (I logged in using INSTALL) and run the ALTER command:

ALTER LOCATION <location name> TO VERSION V100