CCM ETL tasks running too long to complete
Attempts to run the IBM Rational Change and Configuration Management (CCM) Data Collection Jobs results in the Work item ETL running for over seven hours with IBM Rational Team Concert (RTC).
Under the Reports > Data Collection Job Status page of the CCM web UI, the Workitem ETL task took 7 hours to complete during a week day, and 3 hours during the weekend.
The database was running an "ANALYZE_TABLE" job against the database on a daily basis, which is also run through the ETL jobs. This was identified in Defect PM59246.
RTC 3.x hosted with Oracle Database, but this issue can be seen with other database vendors as well
Resolving the problem
The ANALYZE_TABLE command is already run by the ETL jobs, so it is redundant to have it run twice. Identified in Defect 197238, and fixed in RTC 220.127.116.11, the ANALYZE_TABLE command can be disabled through a new parameter in the Data Warehouse connection page named: Automatically update the database statistics.
To resolve this issue, complete one of the two options below:
- Disable the ANALYZE_TABLE job from running automatically or,
- Upgrade to RTC 18.104.22.168
Jazz and Rational Team Concert have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.
More support for:
Rational Team Concert
Software version: 3.0, 3.0.1, 22.214.171.124, 126.96.36.199, 188.8.131.52
Operating system(s): AIX, IBM i, Linux
Reference #: 1590790
Modified date: 06 December 2014