RQM/RTC best acces
Hello,
I have made a custom data stream process to load some data from RTC and RQM to my DW. The problem comes because too much time is spent to retrieve the records. This is my log file:
Data Manager v10.1.6235.143 -- (C) Copyright IBM Corp. 1999, 2011
databuild -- start run on RINSIGHTDES (08-Feb-2013 02:00:17)
Run context:
JobStream '4.-CALIDAD_PROCESOS'
JobStream 'CargarPAs'
Build 'EXE_RESULTS_PA'
[PROGRESS - 02:00:18] Fact Build 'EXE_RESULTS_PA'
[PROGRESS - 02:00:18] Validating Build Specification
[PROGRESS - 02:00:29] Checking Fact Data existence
[PROGRESS - 02:40:54] Processing Reference Data
[PROGRESS - 02:40:54] Processing Dimension Domains
[PROGRESS - 02:40:54] Processing Fact Data
[PROGRESS - 03:43:57] Delivery 'Fact1': 6045 insert(s), 0 update(s) to 'JAZZ.EXE_RESULT_PA'
[PROGRESS - 03:43:57] Acquisition: 6045 accepted, 0 rejected
[PROGRESS - 03:43:57] Delivery : 6045 direct, 0 summary/merge, 6045 total
[PROGRESS - 03:43:57] Done - 0 01:43:40 elapsed
databuild -- completed (08-Feb-2013 03:43:57)
The process spent nearly 2 hours to retrieve 6000 records from RQM. Is there any way to optimice this?
I access to RQM thought data service (xdc) using this URL: https://*******/jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources
Thanks
|
2 answers
Does this build be designed by customer or provided by IBM. If it's firstly situation, the less information couldn't help to do any improvement. The RQM REST API, XDC design, ETL design, DW design all could affect performance. If you need help, please provide information as more as possible.
|
|
Hi Wei, It´s a customer process. I make a full load and now it´s configured to make delta loads filtering by modified field. This make the ETL much more lighter and spend less time. Thanks. |
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.