Archives of the TeradataForum
Message Posted: Fri, 09 Jul 2004 @ 14:42:13 GMT
| Subj: || || Re: How to release locks from a table. |
| From: || || Anomy Anom |
<-- Anonymously Posted: Friday, July 09, 2004 10:23 -->
It does sound like a table level lock. If you lock the table for access before you run your sql does it then return? [locking table
dbname.tablename for access select x from dbname.tablename]
Could be a lock held by the backup utility. If it is a HUT lock you can find it from the supervisor window with the showlocks utility.
cnsterm 6 > start showlocks cnsterm <window>. You can start the lock display utility the same way with start lokdisp from cnsterm 6. If
it is a lock from the backup you can release it with release lock. It could also be an mload lock. If it is an mload lock you can only safely
release it if mload was in the acquisition phase. release mload dbname.tablename is the command.