4.0.6 upgrade question
Before you start the Quality Management application upgrade, run statistics to update the database tables. Otherwise, the migration might take several hours.
The following tables must contain up-to-date database statistics:
- REPOSITORY.ITEM_STATES
- REPOSITORY.ITEM_CURRENTS
- REPOSITORY.ITEM_TYPES
- LINKS.AUDITABLE_LINK
I chose derby as the database...does this apply?
3 answers
There is more information on this topic in "http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m6/topic/com.ibm.jazz.install.doc/topics/r_repotools_onlineMigrate.html".
This is part of the overall QM online migration topic "http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m6/topic/com.ibm.rational.test.qm.doc/topics/c_online_mig_rqm.html".
The means for updating table statistics would be familiar to a DBA. For instance, RUNSTATS on a DB2 database.
This really only applies for repositories with a large volume of manual tests. A non-production Derby DB would not really benefit from the updated stats since this is targeted at existing enterprise deployments of QM.
This is part of the overall QM online migration topic "http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m6/topic/com.ibm.rational.test.qm.doc/topics/c_online_mig_rqm.html".
The means for updating table statistics would be familiar to a DBA. For instance, RUNSTATS on a DB2 database.
This really only applies for repositories with a large volume of manual tests. A non-production Derby DB would not really benefit from the updated stats since this is targeted at existing enterprise deployments of QM.
