Archives of the TeradataForum

Message Posted: Mon, 17 Mar 2008 @ 23:28:33 GMT

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

I would suggest that you don't create tables to reserve space. This just fills up the disk. You want to have open cylinders on your machine so the system does not perform tasks like mini cylinder packs which can really slow down performance.

I would suggest doing one of two things.

1) create a capacity on demand database. Allocate it with the space you want to reserve.

2) put the space in DBC. Move it when you need to use it. This has the advantage of preventing problems when DBC gets full or even goes negative from large Transient Journals. Disadvatge is you have to keep track of how much extra space you have left to allocate.

Thanks,

Bob Diehl

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