Teradata ARC places HUT locks on tables and databases to prevent modifications to the tables and databases before the job is restarted. Consequently, when a Teradata ARC operation does not finish, HUT locks might remain on tables and databases.
Occasionally, you might decide that you cannot restart a job for some reason. In this case, specifically remove HUT locks to allow the database or table to be accessed again.
To remove HUT locks:
- Run a utility statement that specifies the RELEASE LOCK statement for the currently locked database.
- Specify a new restart log. The restart log used when the failure occurred indicates that a restart is necessary, which prevents the removal of Teradata ARC HUT locks.
Example
The following example shows the statements needed to release the locks on a database named Database_Name.
LOGON TDPI/DBC,DBC; RELEASE LOCK ( Database_Name ), OVERRIDE; LOGOFF;
For additional information on the RELEASE LOCK statement and the options available on this statement, refer to RELEASE LOCK.