Archives of the TeradataForum
Message Posted: Wed, 02 Jan 2008 @ 14:08:33 GMT
| Subj: || || Re: Testing for mload on a Table |
| From: || || Anomy Anom |
<-- 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;