how to release lock on a fastload connection?

Database

how to release lock on a fastload connection?

Hi all.
We had a session running with a fast load connection, it got terminated due to a database error.

Now we are not able to release the lock that the fastload connection aquired.

I tried using "Release lock databasename.tablename", but i got the following error:

"The user does not have dump or restore access to the table."

please help me on this issue.

thanks
goutam.
3 REPLIES
Enthusiast

Re: how to release lock on a fastload connection?

SInce this is a fastload job, the target table should have been empty before loading, so drop the target table and start all over again.

If the job halted due to some error correct the error and resubmit the job.Fastload would pickup from where it has stopped
Enthusiast

Re: how to release lock on a fastload connection?

You could also re-execute fastload with the same script. It should resume loading from the last checkpoint.

Re: how to release lock on a fastload connection?

We tried to rerun the session, but the session failed due to the following error:

"Writer initialization failed [Error opening session output file
FILE_NAME.out] [errno=6] [error=No such device or address]]. Writer terminating."

P.S: Initially the session failed due to a Broken Pipe error