Archives of the TeradataForum

Message Posted: Fri, 08 Nov 2003 @ 00:58:51 GMT


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

Subj:		Re: Deleting Resource Partitions

From:		Greene, Thomas L

In V2R4, there is no way to delete a Resource Partition. Once it is defined, it will always exist.

In V2R4, the only way to get rid of resource partitions is to delete the system.gdo file on all nodes, then restart Teradata. You very likely do *NOT* want to do this. However, Mr. Stanek is correct -- If you simply don't use that resource partition, it will not be considered when calculating relative weights. Carrie's Priority Scheduler Orange Book suggests renaming unused resource partitions to make it obvious that the RP is not being used (e.g. RP4_Unused).

I believe in V2R5 (perhaps 5.1), there is a capability to delete a partition as long as the partition is not active. Carrie, can you confirm that?

Yes. V2R5.1 now provides the ability to delete resource partitions etc. without having to destroy the system.gdo file. I have personally used this new feature and can confirm that it works.


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