It is also possible to perform this online with DBM GUI on MaxDB 7.6: You can add new datavolumes to the database. When you delete the old datavolumes the data will be distributed across all other datavolumes.
I'll advice you to make a back-up before the action. Regards, Imko Molenbuur P.S. A MaxDB rule of thumb is that the number of datavolumes is the square root of the database size in GB. I your case I would suggest datavolumes with size 10GB or bigger if the database is expected to grow much larger. -----Oorspronkelijk bericht----- Van: Case, Glen [mailto:[EMAIL PROTECTED] Verzonden: donderdag 2 november 2006 21:08 Aan: maxdb@lists.mysql.com Onderwerp: Rebuild database question. Our database size 105GB. We have various sizes of data volumes ranging from 256K to 8GB. I would like to rebuild the database with uniform data volumes like 8GB. Here are the following steps: 1. Cold complete backup. 2. Drop database. 3. Delete data and log volumes. 3. Create database with correct data and log volumes using DBM GUI Manager. 4. Import the complete backup into the new database. I'm planning on keeping the database id the same. Am I missing a step here ? Thanks, Glen _______________________________________________________________________ The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________________________________ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] Dit bericht kan informatie bevatten die niet voor u is bestemd. Indien u niet de geadresseerde bent of dit bericht abusievelijk aan u is toegezonden, wordt u verzocht dat aan de afzender te melden en het bericht te verwijderen. De Staat aanvaardt geen aansprakelijkheid voor schade, van welke aard ook, die verband houdt met risico's verbonden aan het elektronisch verzenden van berichten. This message may contain information that is not intended for you. If you are not the addressee or if this message was sent to you by mistake, you are requested to inform the sender and delete the message. The State accepts no liability for damage of any kind resulting from the risk inherent in the electronic transmission of messages. -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
