Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Upgrade RQM - database statistics

Questions
Tags
Users
Badges
Georg Kellner
(840●4●81●109) edited
Jun 05 '14, 9:07 a.m.
Hi fellows,

the interactive upgrade guide says:

"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"

As it is not possible (in real life), to have the Oracle administrators at my side when I'm running a RQM update some questions:

Is it suitable to update those statistics some days before the update takes place?
When are those statistics updated in a common Oracle DB with a common RQM application?
Is there a more accurate description of what to do with the DBMS_STATS command? Just setting a link to a long long man page is inadequately I think.

greetings georg.

0 votes

1 answer
3,706 views
0 votes

Accepted answer

Permanent link
Stephanie Bagot
FORUM MODERATOR / JAZZ DEVELOPER (2.1k●1●5●13) Jun 06 '14, 10:42 a.m.
The statistics are only useful if they are up to date, meaning the most current. The statistics may already be run nightly by your DBA - this is something that they would set from the DB side. From the CLM side, we do a reindex which affects both DB and local indices. This can happen manually by running repotools, or automatically through background tasks (if you are interested in the default times, check your QM advanced properties).

But back to the main point - the up to date statistics are needed for an online migration.
Any reason why you decided to run an online migration vs. offline?

You can run the migration estimation command to see if an online or offline upgrade is recommended for your repository. We do list some testing matrix information on our wiki - https://jazz.net/wiki/bin/view/Deployment/RationalQualityManagerOnlineMigrationTestMatrix
Note that in the above cases we only recommend to use the online for the 350 GB DB.
Georg Kellner selected this answer as the correct answer

0 votes

Comments
Georg Kellner
Jun 16 '14, 5:21 a.m.

Well, if the up to date statistics are needed only for the online migration, why is this topic mentioned in the offline guide? ;-)

Eduardo Bello
Aug 25 '14, 3:43 p.m.

@g_kellner has a good point. The information about statistics is mentioned in offline guide. Is it really needed?


Also, is there any command line to update statistics of the tables mentioned above? 

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Jun 05 '14, 9:06 a.m.

Question was seen: 3,706 times

Last updated: Aug 25 '14, 3:43 p.m.

Confirmation Cancel Confirm