Long startup time
Posted: Mon Aug 29, 2016 9:37 am
Hi
Job is taking long startup time in PRODUCTION.
The job is running with 1 processing node.
Design:
The job has one oracle connector stage as source.
With 2 other connector stages as used for lookups with one target connector stage.
Also there are one sort stage and transformer stages has been used in the job.
Job Log:
As per the log, it is showing that the SOURCE connector stage has connected to given database and then its running with 1 processing node.
Next statement in the log is the source SQL statement.
Now the difference of time given between the first 2 statements and SQL statement is almost equal to the job startup time given at below log.
The given SOURCE sql is an user-defined sql with parameters and not a datastage generated one.
I wanted to understand will the Source sql statement generation time is included in Job startup time?
What are the other factors which could possibly impact the startup time?
Please help.
Job is taking long startup time in PRODUCTION.
The job is running with 1 processing node.
Design:
The job has one oracle connector stage as source.
With 2 other connector stages as used for lookups with one target connector stage.
Also there are one sort stage and transformer stages has been used in the job.
Job Log:
As per the log, it is showing that the SOURCE connector stage has connected to given database and then its running with 1 processing node.
Next statement in the log is the source SQL statement.
Now the difference of time given between the first 2 statements and SQL statement is almost equal to the job startup time given at below log.
The given SOURCE sql is an user-defined sql with parameters and not a datastage generated one.
I wanted to understand will the Source sql statement generation time is included in Job startup time?
What are the other factors which could possibly impact the startup time?
Please help.