From: Ripin Natani > Your answer has cleared quite a few doubts. > Just one more question ... will the autoextender > extend upto the entire disk space limit ? > For example if the original volume added to a database was > say 100Mb. Now suppose the database fills up and there is > say 101MB space remaining on the c:\ drive where the database > is installed. Will the autoextender get the disk space (size > of the last current volume is 100 MB)? as u said the sapdb > software does not check for limits ...but will the OS deny > the allocation ?
Hi Ripin, during "add volume" the database kernel creates a file at the disk with the requested size. If the disk becomes full before the file has the requested size the operating system rejects further file access. Therefore "add volume" return with an error. If the disk becomes only nearly full the "add volume" will be sucessfull, but later you may have problems with other apllications. The Autoextender has a very simple logic for its "add volume". It is mentioned for small databases on personal workstations which should only allocate the required resources. So they start only with one small volume. The concept of the Autoextender is based on sufficient disk capacity. I do not recommend the Autoextender for real database servers. Also for your examples where the disk runs near of its capacity I do not recommend the Autoextender. Because of the "disk full risk" it can not minimize the "db full risk". Bernd -- SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
