Archives of the TeradataForum

Message Posted: Fri, 09 Jul 2004 @ 14:42:13 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- 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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>