Archives of the TeradataForum

Message Posted: Thu, 20 Sep 2007 @ 15:16:12 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Jesus:

It sounds a bit like the delete with 30 day script was started, and then the script was changed to 60 days (inconsistant restart) in the middle somewhere after an abnormal termination. This will definitely not work. If this is the case, you should have finished the 30 day delete and then run the 60 day delete. Otherwise, Joe's suggestion of totally blowing away the log table, error tables and work table is the other option.

Restarting is often an option depending on the type of changes being made within your Mload script. However, please, please, please never ever consider it the first option. You can leave your data in an inconsistant state, especially when doing updates such as: SET column = column + :invalue

Just a thought and regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

	<Prev	Next>		<<First	<Prev	Next>	Last>>