When data is being loaded via FastLoad, a table lock is placed on the target table. This means that the table is unavailable for any other operations. A lock on a table is only released when FastLoad encounters the END LOADING command, which terminates phase 2, the so-called application phase. FastLoad may get terminated in phase 1 due to any of the following reasons:
- Load script results in failure (error code 8 or 12)
- Load script is aborted by admin or some other session
- FastLoad fails due to bad record or file
- Forgetting to add end loading statement in script
If so, it keeps a lock on the table, which needs to be released manually. In this recipe, we will see the steps to release FastLoad locks.
