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

ETL updates

I've installed the ifix 3 of RQM 2.0.1.
On available files there is also an ETL update.
I've followed the installation instructions and now I've 2 ETL tasks (RQMALL and RQM-Delta).
Must I run both the tasks?

Thanks in advance.
Bye.

0 votes



One answer

Permanent link
angelo_corna wrote:
I've installed the ifix 3 of RQM 2.0.1.
On available files there is also an ETL update.
I've followed the installation instructions and now I've 2 ETL tasks
(RQMALL and RQM-Delta).
Must I run both the tasks?

Thanks in advance.
Bye.


You would typically schedule the RQM-Delta to run every hour or so
depending on the frequency you want to see updates. If things are
removed the RQM-Delta does not pick this up so you need to run the
RQMALL occasionally say once a day or so. The RQM-Delta only pulls
changes from the last time it ran so it is pretty quick depending on the
number of updates on your server. The RQMALL does a full pull of data
so can take a long time depending on the size of your database and can
degrade the performance for users during that time. We typically run
the RQMALL daily at midnight when usage is low and RQM-Delta every hour
to get updates during the day. You can't go below about 30 minutes as
the Build-Star job takes about 20 minutes to run (at least for our
data). You don't want to pull faster than you can process or you will
have other problems.

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

Question asked: Sep 06 '10, 9:20 a.m.

Question was seen: 4,573 times

Last updated: Sep 06 '10, 9:20 a.m.

Confirmation Cancel Confirm