2006/3/22, Heinrich, Tilo <[EMAIL PROTECTED]>: > 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.
I know (see my last posting). But the issue of IO and space for this operation remains. I'd really love to see resizing of volumes as a feature in MaxDB. robert > 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] > > -- 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]