All Forums Tools
JerryLusa 23 posts Joined 08/13
12 Jun 2014
Will TPT INSERTER operator lock the target table if an INSERT step fails?

We sometimes see the LOAD operator leave a table in a locked state if the TPT job fails at certain places in the script.  The only solution that works for us is to drop and recreate the table.  But will the INSERTER operator ever leave a table locked?
 
Jerry

Jerry L.
JerryLusa 23 posts Joined 08/13
16 Jun 2014

From extensive tests we have not seen the INSERTER operator leave a table locked.  So far, so good.

Jerry L.

feinholz 1234 posts Joined 05/08
16 Jun 2014

No, the INSERTER operator will not leave the table in a locked state.
That is because it uses plain SQL sessions to load the table.
The LOAD operator uses the FastLoad protocol and that protocol requires the table to be locked for the duration of the job.

--SteveF

You must sign in to leave a comment.