Archives of the TeradataForum

Message Posted: Fri, 24 Jun 2005 @ 15:04:43 GMT

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

Hi,

Have a look at which tables are the biggest:

     sel tablename,sum(currentperm)
     from dbc.tablesize
     where databasename = 'dbc'
     group by 1
     order by 2 desc;

You'll probably find the big ones are the resusageXXXX or dbqlXXX tables. These hold (respectively) the resusage data and query log data. Tailor those settings to reduce the amount of space consumed by dbc tables on an ongoing basis.

Also, you should probably look at moving the data from the real dbc tables to a 'history' database.

Cheers,

Dave

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