Job status "running" without record output
Posted: Wed Jul 11, 2001 6:38 am
Hi,
There is a DataStage job that extract records from a view table in
Oracle database and perform data transformation before it loads to
Unidata table. The job uses the Oracle client connection to the
database server and it is using the OCI8 stage to connect to the Oracle
view table. This job is scheduled to run every 15 minutes throughout
the day from 8 am to 8 pm.
However, at certain runs during the day, the job status is
showing running, but we could see only zero records read in from the
source table via the DataStage monitor screen. This running status
will run forever if we did not stop the job manually and re-run the job
from the DataStage director. It seems the job just hangs without any
activity.
What is the exact cause to this problem? The job did not show any
abort status in the job log. This problem did not have an error message
in the job log which makes our debugging task difficult.
For your information, we are using DataStage version 3.6 and is
running on a HP-UX 11.00 machine.
Our customer is demanding for an explanation. Could this be due to
time-out operation when DataStage trying to get connection to the
Oracle database? Or could this be due to running out of resource on the
DataStage machine?
Would appreciate your advice. Thank you.
Regards,
Melvin
There is a DataStage job that extract records from a view table in
Oracle database and perform data transformation before it loads to
Unidata table. The job uses the Oracle client connection to the
database server and it is using the OCI8 stage to connect to the Oracle
view table. This job is scheduled to run every 15 minutes throughout
the day from 8 am to 8 pm.
However, at certain runs during the day, the job status is
showing running, but we could see only zero records read in from the
source table via the DataStage monitor screen. This running status
will run forever if we did not stop the job manually and re-run the job
from the DataStage director. It seems the job just hangs without any
activity.
What is the exact cause to this problem? The job did not show any
abort status in the job log. This problem did not have an error message
in the job log which makes our debugging task difficult.
For your information, we are using DataStage version 3.6 and is
running on a HP-UX 11.00 machine.
Our customer is demanding for an explanation. Could this be due to
time-out operation when DataStage trying to get connection to the
Oracle database? Or could this be due to running out of resource on the
DataStage machine?
Would appreciate your advice. Thank you.
Regards,
Melvin