Fast Export Restart Log

Tools
Enthusiast

Fast Export Restart Log

Hi,

What information is stored in the Fast Export restart log table ? and how do we set checkpoint in fast export scripts

Thanks

R.Rajeev

3 REPLIES
Enthusiast

Re: Fast Export Restart Log

Hi Can any one help me out with the above question ?

Thanks in advance

Teradata Employee

Re: Fast Export Restart Log

Why do you want to know what information is being stored in the FastExport restart log table?

That information is only important to FastExport.

As for setting checkpoints, one cannot normally checkpoint in FastExport.

If the DBS restarts in the middle of a SELECT request processing, the SELECT has to be re-issued from the beginning.

-- SteveF
Teradata Employee

Re: Fast Export Restart Log

Hello All,

I am aware that FastExport sets checkpoints @ SELECT level, not at row level. Meaning, if a Export Script have 2 SELECT clause and the 2nd SELECT fails @ 30th row out of 60 rows, then the FastExport job will resume from the beginning of the 2nd SELECT statement, rather than from the 30th row.

It mean that whenever FastExport fails or aborts, the SELECT output of the running SQL (Here, the 2nd SELECT) is removed from the output file, before beginning the 2nd SELECT statement again. Else, it will inserts DUPLICATE values in the output file. This does seem slightly expensive step for an aborted SELECT statement which was almost completed.

I believe that I have put the restart fundamental correctly in the above post. However, any correction or addition will be appreciated.

Thanks,

Smarak