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

Is there any risk on running the Full Data Collection Job in RRDI?

 We are having an issue with some lost data (never retrieved) in the DWH and the solution in the Sandbox was re running the full ETL. Problem is I've been told that in an older version of RTC you lost some calculated data when you do that.

Question is, is there any risk on running the Full Data Collection Job? Is there any consideration to be taken into account?

0 votes


Accepted answer

Permanent link
Hello Jorge,

the order on which the jobs are executed by the scheduled data collection is the following:
  • Jazz Team Server/Common and Repository
  • Rational® Team Concert/Common and Repository
  • Rational Quality Manager/Common and Repository
  • Rational Team Concert/APT and SCM
  • Rational Team Concert/Work Items and Build
  • Rational Quality Manager/Work Items
  • Rational Quality Manager/Quality Management
  • Jazz Team Server/Requirements
  • Jazz Team Server/Star
See: Running the data collection jobs

The full data collection jobs can only be started manually.

The effect on reports showing historical trends that are calculated during the ETL run will be that, if for example the full ETL will take 1 week to complete, you will only have 1 data point in the report instead of the expected 7.

Best Regards,
Francesco
Jorge Valdeiglesias selected this answer as the correct answer

2 votes


2 other answers

Permanent link
Hello Jorge,
Running full DWH job may take even couple of days, depending on how old your repository is. During that time there are running many SQL queries on RTC database. This might impact your server performance,

Best regards,
Krzysztof Kazmierczyk

0 votes


Permanent link
 Yes, I imagine it will take a while, but beside that, is there any other consideration? For example, how would you run the jobs? One by one? Or is there an specific order to run them, o maybe a command. And most important, how will this affect the calculated data (for example, now the burndown charts use the time the ETL was run to draw a point in the chart)?

0 votes

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.

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
× 12,019
× 82

Question asked: Aug 01 '13, 10:16 a.m.

Question was seen: 5,958 times

Last updated: Sep 17 '13, 6:26 a.m.

Confirmation Cancel Confirm