Upgrading from RTC 2 to 3.0.1- Repotools fails on Creating Jazz tables

Hi Amin -

The upgrade from RTC2 to 3.0.1 includes separating out the Jazz Team Server as an application with its own database. You will need to create a new DB2 database for the 3.0.1 JTS. The RTC 2 DB2 database will be upgraded to the RTC 3.0.1 format via a reptools-jazz --addTables command. You may also want to create yet another DB2 database at this point for a data warehouse.

There are upgrade wrapper scripts that can help you through the series of repotools commands that are necessary to separate out the JTS information from RTC. The documentation is here:
Upgrading RTC2 using scripts
Let me know if you have more questions.

Also Amin -

Be sure to go back to a "pre-createTables" version of your RTC 2 database before starting this upgrade process as unfortunately, that command may have dropped some tables.

Again, let me know if you have questions - I did many upgrades as part of testing the 3.0.1 release.

Gail

 One other note of caution.  Make sure that you are using a supported version of DB2.  I do know of one other customer that had an issue with an older version of DB2 not supporting the new tablenames on an upgrade.  I Believe that it had something to do with the tablename being too long for the earlier version of DB2 to handle.