Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 16 Apr 2004 @ 15:55:51 GMT


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


Subj:   Re: Skewed ACCLOGTBL
 
From:   David Wellman

Hi,

You've hit the cause of this problem squarely on the head. This scenario often happens when your application runs through a middle-tier and it is that middle-tier that logs on to Teradata - often staying logged on for days at a time.

A few solutions come to mind (and may be you need to use a combination of the them)

1) tailor your Access Logging. rules so that you don't log so many sql requests. I accept this may not be feasible depending on your reasons for logging the requests for.

2) if you're on V2R5 then try using the Query log. Again this is dependeont on release of Teradata and your requirements.

3) What a number of sites have done is to create another "acclogtbl" table in a separate database and change the PI. On a regular basis copy the contents of dbc.acclogtbl to your own and then purge dbc.acclogtbl.


Cheers,

Dave

Ward Analytics Ltd: Information in motion ( www.ward-analytics.com )



     
  <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