Hello Chris, Yes you can. Yes the data is distributed, during the deletion of a volume.
If MaxDB 7.6 is used you can add/delete volumes using DBMGUI (->Instance->Configuration->Volumes) or dbmcli (db_addvolume, db_deletevolume). You can add and delete volumes in database state ONLINE. Best regards, Tilo Heinrich SAP Labs P.S.: Unless asked otherwise, please send your answers/questions always to the mailing list. Others might be interested in the topic too. -----Original Message----- From: Chris Barlow [mailto:[EMAIL PROTECTED] Sent: Monday, March 13, 2006 3:53 PM To: Heinrich, Tilo Subject: RE: Data Volume Size So If I have the following: 100,000 File A 100,000 File B 100,000 File C I can create the following: 200,000 File D 200,000 File E 200,000 File F And then delete Files A, B and C? When I go to delete A, B and C will MaxDB automatically migrate the data from those volumes to D, E and F? Thanks for you assistance. Chris Barlow -----Original Message----- From: Heinrich, Tilo [mailto:[EMAIL PROTECTED] Sent: Monday, March 13, 2006 6:54 AM To: maxdb@lists.mysql.com Subject: RE: Data Volume Size Hello Chris, if you are using MaxDB 7.6 you can also add new volumes in the size and numbers needed and delete the old small volumes. Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Chris Barlow [mailto:[EMAIL PROTECTED] Sent: Friday, March 10, 2006 6:02 PM To: maxdb@lists.mysql.com Subject: Data Volume Size Is there anyway to increase the size of the current data volumes? I know I can add new volumes and adjust the size of the news ones, but I can't resize the current "in use" volumes. Is there an issue with having many small data volumes, or is it better to have fewer larger volumes? Are there any White Papers on the subject? Is it bad to mix the size of the data volumes? Thanks, Chris This message is intended only for the named recipient(s). If you are not one of the named recipients, you have received this message in error. Please notify the sender immediately and delete the message (along with its attachments) in a way so that no image of it is retrievable or accessible from the computer where this message has been displayed or from any network to which such computer is connected. Any use or disclosure of this message or its contents/attachments by anyone other than the intended recipient(s) is expressly prohibited and could result in civil or criminal liability. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] This message is intended only for the named recipient(s). If you are not one of the named recipients, you have received this message in error. Please notify the sender immediately and delete the message (along with its attachments) in a way so that no image of it is retrievable or accessible from the computer where this message has been displayed or from any network to which such computer is connected. Any use or disclosure of this message or its contents/attachments by anyone other than the intended recipient(s) is expressly prohibited and could result in civil or criminal liability. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
