Archives of the TeradataForum

Message Posted: Sat, 23 Feb 2013 @ 10:57:27 GMT

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

Hi Roopalini,

There isn't always a direct relationship between the size/growth of the journal db and etl db, it really depends on what type of maintenance commands are being executed.

To take some 'extreme' cases:

- if you update the same row multiple times then each update writes a new row to the journal db but the etl db doesn't change size

- if you delete 100 rows and then insert 100 rows (whether they're the same rows or not) there will be 200 entries in the journal db but the etl db won't have changed row count.

So what is the mix of insert / update and delete in your etl work?

Like you , I wouldn't immediately associate "high cpu skew" with the jurnal db filling up. I think for now you have to treat that as a separate issue.

Cheers,

Dave

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

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