FastLoad lock Type

[saurabhkamath]

Does fastLoad apply Exclusive lock on target table ? If not what type of lock is applied ?

[dnoeth]

It's not an exclusive lock, but a special lock in the table header preventing any SQL access until it's release by an END LOADING.

[diptera]

Dieter,

Let's say my FASTLOAD failed for some error. In that case, if I need to release the lock, should I write a script with this table as a fastload but not keeping any insert statement and (most important) just keeping an end_loading?

[Raja_KT]

Hi Dipanjan,

I am not Dieter, but let me  give some directions:

In the fastload manual:

To restart the job if the Teradata FastLoad job was paused during the end loading phase

1 Use the same LOGON command described in the preceding procedure.

2 Submit BEGIN LOADING and END LOADING commands, as in the following example:

LOGON dbc/sjn,music ;

BEGIN LOADING Fast_Table

ERRORFILES Error_1, Error_2 ;

END LOADING ;

With  Note: If a Teradata FastLoad job script is used to assemble these commands, make sure to delete the CREATE TABLE and any DROP TABLE and DELETE statements before restarting

the job.

Cheers,

Raja

[diptera]

Thank you Raja..