Archives of the TeradataForum

Message Posted: Tue, 21 Mar 2006 @ 23:08:26 GMT

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

We have a system of stored procedures that add space before a production load to a database and then takes it back after the work is done. We're just putting the auto add and subtract space functionality into production. So we dynamically add the necessary space, return the unused space, and then change the allocation if there's an normal increase. There is also a verify step that checks to see if there's something unusual happening, like if the number of records coming in (for full refreshes) is less than the records that were out there before. It's not integrated, not every process uses it, but it works enough that we like it. It was originally written by one of our dba's who's since passed to the great beyond (well, ok, he went to work for NCR).

iv

PS: Are you out there listening, Andrew?

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