Page 1 of 1

How to restart failed Teardata Multiload job from Datastage?

Posted: Thu Jun 17, 2010 9:27 am
by RaviReena
I have a job which is loading data to 3 tables using Teradata mulitload stage and it is failed in Application phase.How to restart this job from Datastage?

Posted: Thu Jun 17, 2010 10:20 am
by anbu
What do you mean by application phase?

What is the write mode? Is it insert/update/delete?

Posted: Thu Jun 17, 2010 10:45 am
by RaviReena
It is inserting the data to the table.

Re: How to restart failed Teardata Multiload job from Datast

Posted: Thu Jun 17, 2010 11:47 am
by Ultramundane
RaviReena wrote:I have a job which is loading data to 3 tables using Teradata mulitload stage and it is failed in Application phase.How to restart this job from Datastage?
Contact your Teradata DBA and have them reset the load status of the tables and drop the error tables.

Then, open the director application and highlight the job in question.

Next, click the reset button looks like: <|<|

Then, click the run button: |>

Thanks.

Posted: Thu Jun 17, 2010 12:17 pm
by chulett
As to what the buttons look like, Rewind and Play respectively. :wink: