Hello Robert, Starting with MaxDB 7.6 you can delete data volumes in database state ONLINE. So by adding new volumes and deleting old ones, you have a way of changing the size of a volume without backup/restore.
Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Robert Klemme [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 22, 2006 3:16 PM To: Döhr, Markus ICC-H Cc: Denham Eva; maxdb@lists.mysql.com Subject: Re: Maxdb does not need a DBA? 2006/3/22, "Döhr, Markus ICC-H" <[EMAIL PROTECTED]>: > Hi, > > [...] > > I am not particularly worried about my position, however this > > sounds amazingly good. > > Is this true? Do any of you do dba like work on these > > databases or are they really self maintaining? > > My experience is that no matter how automated systems get > > inevitable you need someone to maintain the tools that do this too. > > We use those database in all our SAP environment and we are in fact very > happy with it :) > > Of course, every software product needs a "maintainer" who will check, if > backups were successfull, apply patches and have a look, that everything is > right. Definitely. > MaxDB has a complete different data storage approach as e. g. Oracle or DB2. > There are not tablespaces, datafiles, extents, and controlfiles. MaxDB uses > Volumes and spreads the data accross those volumes. You have no influence > where a table is stored so you will never run into "hotspots". But it also means that you have no chance to optimize it if the usage pattern is bad; and unfortunately there is no way to change the size of a volume (is there?). I personally found SQL Server to be the most hassle free RDBMS I have worked with. I'm sorry to say that on this list but also YMMV... Kind regards robert -- Have a look: http://www.flickr.com/photos/fussel-foto/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
