Edit
Attach
P
rintable
r5 - 2013-05-11 - 17:12:27 - Main.sbeard
You are here:
TWiki
>
Deployment Web
>
DeploymentTroubleshooting
>
PerformanceTroubleshooting
>
WhyDoMyETLsTakeSoLongToRun
>
InvestigatingDataManagerForETLs
<sticky><div id="container" > <div id="header-title" style="padding: 10px 15px; border-width:1px; border-style:solid; border-color:#FFD28C; background-image: url(<nop>https://jazz.net/wiki/pub/Deployment/WebPreferences/TLASE.jpg); background-size: cover; font-size:120%"> ---+!! <img src="https://jazz.net/wiki/pub/Deployment/WebPreferences/new.png" alt="new.png" width="50" height="50" align="right"/> Investigating data manager for ETLs %DKGRAY% Authors: Main.GeraldMitchell <br> Build basis: CLM %ENDCOLOR%</div></sticky> <!-- Page contents top of page on right hand side in box --> <sticky><div style="float:right; border-width:1px; border-style:solid; border-color:#DFDFDF; background-color:#F6F6F6; margin:0 0 15px 15px; padding: 0 15px 0 15px;"> %TOC{title="Page contents"}% </div></sticky> <sticky><div style="margin:15px;"></sticky> This situation is to help discover the possibilities in correcting ETLs (Extract-Transform-Load) in the situation where the ETLs seem to be taking what is considered a longer time than expected to run and the process is controlled by the Data Manager in Insight. ---++ Recommended analysis steps ---++++Reporting tool specific logs * Data Manager logs in the reporting tool * The default location of the Data Manager logs are at __/cognos/datamanager/log__ * Check the log named Build_job_type.log, to see whether there are failure or how many records have been delivered. * Data log load: __/cognos/datamanager/data__ * Review the XML Data Configuration (.xdc). Make sure that the correct/current version catalog is used. * The mustgather information for Rational Insight is available from [[http://www-01.ibm.com/support/docview.wss?uid=swg21409882][Technote 1409882]]. This information may also be valuable if you are trying to analyze the ETLs and are using Insight. * Rational Insight ETL logs for mustgather: * The default location of the Rational Insight JDBC logs and Rational Insight Data Manager logs are at <verbatim>C:/Documents and Settings/<user>/logs</verbatim> * You can change the default location by modifying the register of the jdbclogpath parameter in the <verbatim>HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/IBM Rational insight XML ODBC Driver </verbatim> registry. * Rational Insight Data Manager logs are located at <verbatim><rational_insight_installation_directory>/cognos/datamanager/log </verbatim> * Rational Insight Data Manager logs for rejected data are located in <verbatim><rational_insight_installation_directory>/cognos/datamanager/data </verbatim> ---++ Possible Causes and Solutions After reviewing the above information on assessment and analysis, you may or maynot have found an error which correlates to the long running ETL. If so, navigate to the following pages: *[[https://jazz.net/wiki/bin/view/Deployment/LongRunningETLError][Yes, I found an error which could be causing the Long Running ETL]]* OR *[[https://jazz.net/wiki/bin/view/Deployment/LongRunningETLNoError][No, I have not found any error causing the Long Running ETL]]* ---++ Keywords to aid searching performance diagnosis delay wait ETL extract transform load data collection job star common RTC RQM Insight JTS time delay report long length slow freeze frozen response XDC error exception disable variable STAR datamanager custom ---+++++!! Related topics: None ---+++++!! External links: * [[http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m1/topic/com.ibm.rational.reporting.admin.doc/topics/t_running_the_data_collection_jobs.html]] * [[http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m1/topic/com.ibm.rational.reporting.admin.doc/topics/c_data_collection.html]] * [[http://en.wikipedia.org/wiki/Extract,_transform,_load]] ---+++++!! Additional contributors: None <sticky></div></div></sticky>
Edit
|
Attach
|
P
rintable
|
V
iew topic
|
Backlinks:
We
b
,
A
l
l Webs
|
H
istory
:
r6
<
r5
<
r4
<
r3
<
r2
|
More topic actions...
Deployment
Deployment web
Planning and design
Installing and upgrading
Migrating and evolving
Integrating
Administering
Monitoring
Troubleshooting
Community information and contribution guidelines
Create new topic
Topic list
Search
Advanced search
Notify
RSS
Atom
Changes
Statistics
Web preferences
NOTE: Please use the Sandbox web for testing
Status icon key:
To do
Under construction
New
Updated
Constant change
None - stable page
Smaller versions of status icons for inline text:
Copyright © by IBM and non-IBM contributing authors. All material on this collaboration platform is the property of the contributing authors.
Contributions are governed by our
Terms of Use.
Please read the following
disclaimer
.
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
.