As FastLoad is designed to work only on empty tables, it becomes necessary that the loading of the table finishes in one go. If the load script is errored out prematurely in phase 2, without encountering the END loading command, it leaves a lock on loading the table.
Fastload locks can't be released via the HUT utility, as there are no technical lock on the table.
To execute FastLoad, the following are some requirements:
- Log table: FastLoad puts its progress information in the fastlog table.
- EMPTY TABLE: FastLoad needs the table to be empty before inserting rows into that table.
- TWO ERROR TABLES: FastLoad requires two error tables to be created; you just need to name them, and no ddl is required. The first error table ...
