I faced one issue in the Cogons Data Manager. When I am trying to make any duplicate copy of any build in the data manager and then modify the copy of the build the original build is also got modified which should not I guess.

I guess you duplicate build in ETL job directly. In ETL job, the build is only link not itself, so duplicate and original ones are both associated same build, you could check it in the build node properties. So if you want duplicate and make modification, please duplicate build itself, not the one in job.

Then if you only want to extract data from different servers with same logic, duplicaion is not best solution. RRDI/Insight provide XDC file and loop solution for your reference, please refer ALM job in Jobs->CQJobs and related documentation.

Thanks zhang for the response. I have just duplicated the build directly not made any duplicate in the ETL job.

Yes, you understand the requirement correctly. I have to extract data from different servers with the same logic. If there is anything for this as you suggested the XDC file and loop solution that will be great.

Let me tell you I am having custom ETL's to fetch the data from RTC  instances. I have XDC's but I am not sure I understand how to do looping by changing the XDC source. If you could provide me the link for the documentation that would be great help.

Thanks.

Duplicate build issue got resolved by just reinstalling the reporting development tools. Thanks to all of who pay attention to my question.

Now I am looking for the best solution to fetch the data from N number of RTC instances. How we are doing now is we just made a duplicate set of XDC file and then made a set of duplicate builds for the other instance. As we have more then 25 instances I found duplication is a bit lengthy.

Any would be appreciated.

Thanks,
Asim
+91 9999 744 786

For you case, you only need add resource groups into XDC for RTC instances, and no modification for DM ETL.
Not only workitem, but also jts, scm and buils if you needed. Then all is ok. Please refer following screen picture.

Thanks Zhang. This is exactly same I was looking for.I did it in the same way as below.

 

But I noticed a change in the data manager see screen shot below

 

I have to modify the query for that database object where I have added multiple resources. I modified the query as above but it didn,t work. I doubt that UNION ALL is not working.

If you use XDC and related DM package from CALM server, not designed by yourself, you could see following loop. In this loop, DM will traverse all resource group definion in your XDC. So you don't need to 
"UNION ALL" resource group by your self. Of course, not only worktime, but also jts, scm and build.

Then, we design SQL query just like following. We parameterize resource group definiton by {$RESOURCEGROUP}, not provide its exactly name. So I suggest that you should refer standard design firstly.

No I am not using CALM server. Actually we have one application AAO which consist of RTC custom plugins and services. I have custom services which provides data from RTC instance to RI data warehouse.

Sorry, I am not sure what I need to do in DM for my XDC file, which have 3 Resource Groups (Primitives_BAO_STAGG_ratsuitein40,rimitives_ORACLE_STAGG_ratsuitein41 and Primitives_TEST_STAGG_ratsuitein114).

May be I am asking a very basic question.. I am newbie for Data Manager.

Thanks,

This feature could not summary in simple words, if you have insight, please refer the job for ClearQuest, ClearCase or other point products. They all have same mechanism with what I said, or refer Insight Infor center to find detail steps. Sorry I have no time to descirbe it one step by one. In other words, you also could call IBM level 2 support.

Hi Zhang,

I have implemented the feature and it is working fine on my machine running on Windows XP. Thanks for your support I am able to get 13 RTC instances data with out making any change in my Builds and Jobs. Fine approach.

But now the issue is when I restored this catalog to the Linux (RedHat) environment it is giving some error while executing builds with multiple resources.

[db2inst1@INMBZ1110 bin]$ ./databuild -P DB2 "DSN=RICTG;UID=db2inst1;PWD=db2inst1" "TeamAreaRest:PRODUCTION"
Data Manager v10.1.6235.143 -- (C) Copyright IBM Corp. 1999, 2011
databuild -- start run on INMBZ1110.(none) (12-Mar-2013 13:33:51)
[PROGRESS   - 13:33:51] Accessing catalog
[PROGRESS   - 13:33:54] Exporting required components

DM-PRS-1001 Error parsing build specification, failed to replace special items; variable 'RESOURCEGROUP' could not be found

DM-BLD-0003 Incorrect specification for build 'TeamAreaRest:PRODUCTION'.

databuild -- failed (12-Mar-2013 13:33:54)

Press Enter to continue

Thanks in advance!
Asim