Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 02 Oct 2001 @ 17:34:54 GMT

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

Subj:   Re: Problem with checktable
From:   Jorge LasHeras

The problem is checktable creates an invalid update that then prevents proper purging of before images of completed transactions in the Transient Journal. So this table keeps growing and eventually filling up dbc perm space. I think this happens only to V2R4 sites, and the fix is DR 57432, which I've been told will be generally available shortly.

Workarounds: NCR suggests to avoid using checktable until DR 57432 is installed. If you do need to run checktable, as you said: schedule a tpareset which effectively fixes the wrong data structure updated by the utility. You can also monitor the TJ in case you've run checktable. In every case check with your NCR support person.

Best regards,


  <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: 28 Jun 2020