Archives of the TeradataForum

Message Posted: Tue, 16 Apr 2013 @ 22:17:05 GMT

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

<-- Anonymously Posted: Tuesday, April 16, 2013 11:13 -->

Hi Bill,

Was there a lock table that CheckTable was waiting on? It could be that CheckTable halted logging because it was waiting on a locked table. Other possibilities: a killed job or a remote console issue.

Checktable normally would process all tables and print a summary report at the end. Currently, there is no option in CheckTable to change the output reporting's limit for level pendingop.

The 100x status message in level pendingop is hard coded. There is no user control.

Have you run other levels of CheckTable such as level one, level two against the same set of tables/databases?

CheckTable would display the status for every single table when the error only option is not used.

Will you see the same output limit problem here since the amount of output for level pendingop will be less than the other levels since it only reports the status once for every 100 tables?

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