Page 1 of 1
When does a job hang in RUN state
Posted: Tue Jul 10, 2007 9:11 am
by G SHIVARANJANI
Hi,
why a job do not come into finished state (in Datastage director log file )while loading the data into data base from a sequential file.
I mean why it still shows that it is in running state....for a long time...
it gets hanged in that state(running)
thanku
Posted: Tue Jul 10, 2007 10:15 am
by thumsup9
There could be several reasons why a job hangs. Do you have all your metadata defined correctly, have all the necessary insert/update permissions on the target table, Is your data violating any unique key constraints.
I would try to insert one record in the target table manually using SQL and see what error message it throws.
Posted: Tue Jul 10, 2007 10:32 am
by G SHIVARANJANI
yes will try with SQL query...
But i would like to let u know that the error shown in directory is
"main_program: ORCHESTRATE step execution terminating due to SIGINT"
When i tried to pause the job.
thanku.
Posted: Tue Jul 10, 2007 5:25 pm
by ArndW
G SHIVARANJANI wrote:...When i tried to pause the job...
DataStage has no facility for pausing jobs. I don't know what you did, but it caused the job to abort.
Posted: Tue Jul 10, 2007 8:18 pm
by JoshGeorge
SIGINT error appeared because you tried to interrupt a process. ie. you might have tried to stop the job (pause ?
)
G SHIVARANJANI wrote:
But i would like to let u know that the error shown in directory is
"main_program: ORCHESTRATE step execution terminating due to SIGINT"
When i tried to pause the job.