Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: CheckTable Utility -- alter default settings to ViewPoint screen
From:   Anomy Anom

<-- 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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023