Archives of the TeradataForum

Message Posted: Wed, 02 Jan 2008 @ 14:08:33 GMT

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

<-- Anonymously Posted: Wed, 2 Jan 2008 08:00 -->

You can use CHECK TABLE command under the Database Console option of TD Mgr.

The syntax is: CHECK MY_DATABASE AT LEVEL PENDINGOP SKIPLOCKS; (you can check the whole database or just one table if you want) This is the highest level check that CHECK TABLE can run, so it runs fairly quickly.

     check My_DATABASE.Table1 at level pendingop skiplocks;

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