Identify the table on which FastLoad is been ended pre-maturely and tables are in locked state. You need to have valid credentials for the Teradata Database.
Execute the dummy FastLoad script from the same user or the user which has write access to the lock table.
A user requires the following privileges/rights in order to execute the FastLoad:
- SELECT and INSERT (CREATE and DROP or DELETE) access to the target or loading table.
- CREATE and DROP TABLE on error tables.
- SELECT, INSERT, UPDATE, and DELETE are required privileges for the user PUBLIC on the restart log table (SYSADMIN.FASTLOG). There will be a row in the FASTLOG table for each FastLoad job that has not completed in the system.
