FastLoad lock Type

Database
Enthusiast

FastLoad lock Type

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

4 REPLIES
Junior Contributor

Re: FastLoad lock Type

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.

Enthusiast

Re: FastLoad lock Type

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?

Enthusiast

Re: FastLoad lock Type

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

Enthusiast

Re: FastLoad lock Type

Thank you Raja..