Archives of the TeradataForum

Message Posted: Wed, 29 Aug 2007 @ 18:00:22 GMT

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

The only way I know of finding these locks is to run checktable.

Ensure the output of the checktable is being captured to a file and then run the following command:

     check all tables at level pendingop skiplocks;

This will identify all tables that are either being fastloaded or multiloaded and have that are still in a loading state.

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