How to restart failed Teardata Multiload job from Datastage?

RaviReena · Post by **RaviReena** » Thu Jun 17, 2010 9:27 am

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?

anbu · Post by **anbu** » Thu Jun 17, 2010 10:20 am

What do you mean by application phase?

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

RaviReena · Post by **RaviReena** » Thu Jun 17, 2010 10:45 am

It is inserting the data to the table.

Ultramundane · Post by **Ultramundane** » Thu Jun 17, 2010 11:47 am

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.

chulett · Post by **chulett** » Thu Jun 17, 2010 12:17 pm

As to what the buttons look like, Rewind and Play respectively.

DSXchange

How to restart failed Teardata Multiload job from Datastage?

How to restart failed Teardata Multiload job from Datastage?

Re: How to restart failed Teardata Multiload job from Datast