Archives of the TeradataForum

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

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

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>>